I have added a cross-tab to my report and need some help in formatting it. The columns are months and the rows are financial number. My problem is that most of the months are not populated with data at this time and what the cross-tab object does is eliminated the column when there is no data. This presents a problem since columns are shifted over. See example below
|
9 |
10 |
11 |
Total |
| Total |
2347.5 |
834475.6 |
0 |
836823.1 |
|
10 |
Total |
|
|
|
500.347.3 |
500.347.3 |
|
|
|
11 |
Total |
|
|
|
84198.5 |
84198.5 |
|
|
I want the colums to align even if there is no data for the column and if possible can I eliminate the column headers 9, 10, 11 and Total completly?
IP Logged
