Remove totals from crosstab in Ad Hoc VIew


Is it possible to remove the totals from a cross tab in an ad hoc view?

I know how to do this is iReport Deisgner.

vicky.moore's picture
Joined: Aug 5 2013 - 9:37pm
Last seen: 2 years 8 months ago

1 Answer:


Yes, Right click on the column header and choose the "Delete Row Summary" option.  To put it back, click on the "Add Row Summary".

djohnson53's picture
Joined: May 25 2012 - 11:10am
Last seen: 2 days 8 hours ago

PS: You will still get a total for collapsed Rows.

djohnson53 - 7 years 7 months ago

Thanks so much - worked a treat.

vicky.moore - 7 years 7 months ago

After deleting the row summary. It will say can't render chart because the summary was deleted....

adeng_1 - 5 years 11 months ago
show 2 more...

In Jaspersoft studio 6.3.1, it deletes all the row group! What should i do then? Why is it adding the TOTAL ROW forcefully when i don't want/need it??

zain.imtiaz - 4 years 2 weeks ago

How to delete the column total ???

arun.h - 3 years 11 months ago