CrossTab Grouping Header Display

[irnewbie]

Hi

 

I am using crosstab in iReport 3.7.4 and have found some help here with this design;

http://jasperforge.org/plugins/espforum/view.php?group_id=83&forumid=101&topicid=72213

The problem I am having now that I cannot find the solution is that I am grouping by say town and the crosstab shows results for each town but every record is split up into each town even if more than one results for the same town is there.

for example it will be like this:

town A

Results 1

town B

Results 1

town A

Results 2

but I am trying to get:

town A

Results 1
Results 2

town B

Results 1

I am not sure if it is the town column, which is what I am resetting the cross tab by. Do I need to change the resetting or change the town column to another band then update the resetting by part of it?

The town column is in the Group header, the cross tab is in the group footer.

Would anyone have any suggestions?

Thanks

IRNewbie

 

 

[irnewbie]

Hi

 

I don't suppose anyone knows how to do this?

 

Thanks

 

IRNewbie

[irnewbie]

Bump. does anyone know? I am using two row values and one column value but there is no option to group the results.

how can I group the results by a field from the query? All it does currently is show a group per result seperately as described in my first post.

Thanks

IRNewbie

Post Edited by irnewbie at 04/05/2011 14:38