How to show Total in rowGroup level of a "Crosstab"?

[sanjayapradhan30]

Hi,

I am trying to show the data fetched from query as shown in below as a cross tab.

what i am trying to achive is to show  Equipment, Total Kilos and Re-Use in row Group level, and shortname as colums, and their corresponding sums.

But, the issue i am facing is since there are two rows having Total kilos 40 each for equipment "All_WTN_TEST X 50" the total is shown as 80, which is wrong.

I need to show the sum of total kilos equipment wise.(e.g All_WTN_Test - 40 + Printers 0 = 40) if printer is of 5 Kg then (40+5=45))

since equipments are 2 so sum of those two should be show.

 

Can any one please let me how to achive this? (I am bit new to jasper report design)

  

Thanks in advance.

 

Regards,

sanjaya

[hozawa]

Probably the best answer is to create a case in the Tracker to get the bug resolved.