hilfy,
Thanks for the respond.
But that is not the case.
My issue is:
Whenever I run the report (crosstab) it gives me long pages because there are many columns.
So, I had to split the crosstab in few columns (e.g.: every 10 columns).
And it works.
But each crosstab will have each Total.
For example, there are 17 columns in the crosstab as shown below:
col_1 col_2 ... col_17 Total
row1 2 5 ... 7 (2+5+...+7)
row2 5 10 ... 4 (5+10+...+4)
. . . ... . .
row5 1 3 ... 5 (1+3+...+5)
Total (2+5+...+1) ..... (7+4+...+5) (total all)
After I split the crosstab every 10 columns it gives me like this:
(First crosstab)
col_1 col_2 ... col_10 Total
row1 2 5 ... 5 (2+5+...+5)
row2 5 10 ... 3 (5+10+...+3)
. . . ... . .
row5 1 3 ... 3 (1+3+...+3)
Total (2+5+...+1) ..... (5+3+...+3) (total all)
(Second crosstab)
col_11 col_12 ... col_17 Total
row1 4 8 ... 5 (4+8+...+5)
row2 3 11 ... 3 (3+11+...+3)
. . . ... . .
row5 2 5 ... 3 (2+5+...+3)
Total (4+3+...+2) ..... (5+3+...+3) (total all)
My question is:
How to remove column 'TOTAL' on first crosstab and print the column TOTAL only on second crosstab which is total from columns1, column2, ..., column17 ?
Thanks in advance for any suggestions and/or helps.
emir