|
Buy Support
Incidents |
|
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
|
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
|
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
|
Click Here
|
Buy Support
Incidents |
|
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
|
Click Here
|
|
| Column headings not coming across |
| Author |
Message |
| CD |
| |
| Group | : Members |
| Posts | : 9 |
| Joined | : 2008-02-21 |
|
| Profile |
|
| Posted : 2008-06-09 15:47:18 |
I have created a "sales by customer summary" report with the column headings "class". But in excel they just appear as Amount 1, mount 2 etc.Where am i going wrong?
sp_report SalesByCustomerSummary show Text, Label, Amount parameters DateMacro = 'ThisYear', SummarizeColumnsBy = 'Class' |
|
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2008-06-09 16:29:10 |
Your report uses:
sp_report SalesByCustomerSummary show Text, Label, Amount parameters DateMacro = 'ThisYear', SummarizeColumnsBy = 'Class'
and when your report runs, Amount will be changed to Amount_1, Amount_2 Amount_3 etc depending on the number of Classes you have as well as a "Unclassified" and "TOTAL" column.
Simply expand your report to define the Class names you have:
sp_report SalesByCustomerSummary show Text, Label, Amount_1 as Class1, Amount_2 as Class2, Amount_3 as Unclassified, Amount_4 as TOTAL parameters DateMacro = 'ThisYear', SummarizeColumnsBy = 'Class' |
|
|
|
| CD |
| |
| Group | : Members |
| Posts | : 9 |
| Joined | : 2008-02-21 |
|
| Profile |
|
| Posted : 2008-06-09 16:45:07 |
Not following totally i have 11 clases.
The first is Artists
Second is Builders-House
Could you entere those as an example for me please.
thanks |
|
|
|
| Tom |
| |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2008-06-10 08:33:12 |
Ok, for you it would be:
sp_report SalesByCustomerSummary show Text, Label, Amount_1 as Artists, Amount_2 as Builders-House, Amount_3 as Class3name, Amount_4 as Class4name, Amount_5 as Class5name, Amount_6 as Class6name, Amount_7 as Class7name, Amount_8 as Class8name, Amount_9 as Class9name, Amount_10 as Class10name, Amount_11 as Class11name, Amount_12 as Unclassified, Amount_13 as TOTAL
parameters DateMacro = 'ThisYear', SummarizeColumnsBy = 'Class' |
|
|
|
|