I am using Cross Tab orientation in my report. There is no option to ask the component to create subtotals per column or row. In previous version, there was a suggestion to add extra bands to total the values accordingly. I have managed to add a band after the cross tab band to sum each column by using the same grouping and ordering.
But I cannot seem to get a band to show the totals for each row (i.e. on the right side of the cross tab cells). When I tried to use horizontal orientation band and add the region cell to the right side of the cross tab cells, the generated Excel fails to load.
How can I create cross tab report subtotals for each row ?
Can you share an example please ?
Regards,
CK