Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Cross tab. Position row total in next column

Status
Not open for further replies.

thebigbadwolf

Programmer
Jul 7, 2010
67
CY
Hello everyone,
I have a crosstab with one row (equipments) and two columns (month and job type).

The results appear fine, no problem with that. But the results doesn't fit in a A4 page. (there are 12 months is here! lol)
So i would like to position the row total of the month under the row, not in the same line as the equipment.
ie.
instead of
[pre] january february[/pre]
[pre] DF CM TOTAL DF CM TOTAL[/pre]
[pre]equipment1 2 5 7 5 1 6[/pre]
[pre]equipment2 1 0 1 2 2 4[/pre]
[pre]equipment3 0 3 3 5 5 10[/pre]


this:
[pre] january february[/pre]
[pre] DF CM DF CM[/pre]
[pre]equipment1 2 5 5 1 [/pre]
[pre] 7 6 [/pre]
[pre]equipment2 1 0 2 2 [/pre]
[pre] 1 4 [/pre]
[pre]equipment3 0 3 5 5 [/pre]
[pre] 3 10 [/pre]


any ideas?
 
ok, forget my previous post, i'm just gonna export the report to excel so no problem.

But i have another issue.
Can i have on the end right of the report, the total of DF, CM per equipment?
like:

[pre] january february TOTAL
DF CM TOTAL DF CM TOTAL DF CM
equipment1 2 5 7 5 1 6 7 6
equipment2 1 0 1 2 2 4 3 1
equipment3 0 3 3 5 5 10 5 8
[/pre]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top