CrossTabs and Detail Band

[2006 JR Open Discussion]

By: rsood - rsood72

CrossTabs and Detail Band

2006-07-19 09:54

Is it true that Crosstabs would work only if we put them in the summary band of a page..though the sample shows them in the detail band too. Everytime I put crosstabs in the detail bands I get the following error

Caused by: net.sf.jasperreports.engine.JRException: Crosstab data has already been processed.

I also sometimes get the following which is nested in the above exception

NESTED BY :

net.sf.jasperreports.engine.JRRuntimeException: Error incrementing crosstab dataset

I have my own datasource which happens to be a vector of custom object. This object has the fields that contain row group, col group header, detail header values and regular groups. I also found I cannot group a crosstab using regular groups, i would have to make those groups part of cross tabs by making two row groups and col groups.

 

This is my guess on why I am getting the error...every time it gets a record it tries to process the cross tab from the beginning ..so that is fine with the first record but if I had more than one element in my vector or more than one record than the processing again from the beginning hits the processed flag and it throws the exception....so I am guessing that detail band is not the right place to put a crosstab..

could someone shed more light into this.

thank you...Teodor hope you are reading this and can help me out..

thank you.