crosstab

[mr_jaber]

hi all ,

i have created a new report and tried to use crosstab , i have table of 3 columns country,year and id (all are numbers) , i went through the wizard and every thing is ok , but when i try to "Execute" it it gives me this error :

Error filling print... Error incrementing crosstab dataset

net.sf.jasperreports.engine.JRRuntimeException: Error incrementing crosstab dataset at net.sf.jasperreports.engine.fill.JRFillCrosstab$JRFillCrosstabDataset.customIncrement(JR FillCrosstab.java:654) ...

 

iam using iReport 1.3.2 , any assistance on solving this !! thanks in adnavce

[evert]

Two solutions seems to work

 

1) Create a subdataset and use it in the crosstab

 

2) Put your crosstab in the summary section

 

 

 

:)

[jpg]

Oh. Are those the only choices? Using the Summary section works, as long as I squeeze all the other sections into oblivion. Using the subDataset is not working at all - I get massive duplication (I am using the same query in the subDataset as in the original) - a 2 page table repeated across 217 pages. I am very unclear on how to tweak the relationship between the main query and the subquery. Deleting one or the other does not work (and I get nine blank pages when I delete the base query, what is up with that?) :dry:

 

Anyway, any tips would be great.