Crosstab-Repeating Row Group data for each Measure

[chetan_33]

Hi All,

 

I have a cross tab wherein I want the data in the row group 1 to be repeated for all the rows which are generated for row group2 and so on.

 

To explain considering the sample ShipmentsReport.pdf located at "jasperreports-1.2.5demosamplescrosstabs" OR "jasperreports-1.2.5docssamples"

 

In this the first row headers are for region and second is for city. In sample region is shown once for all cities belonging to same region.

I want to repeat the value of region for all cities in the first column instead of just displaying it one time.

How to do this.

 

Also am looking for layout solution posted at

 

http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=215&func=view&catid=8&id=311

[lucianc]

You can use the header of the second row group to print both the first group label and the second group label (by simply using two text fields). If you want it to look like two separate cells, you can draw a vertical line inside the row header.

 

Another option would be to create a dummy row group with a constant expression and use its header to display the first group label.

 

HTH,

Lucian

[chetan_33]

lucianc thanks again

that was really a simple trick

I didnt understand the second option you told. Can you please explain me.

 

Also I noticed that with my original cross tab the label headers doesn't come properly above the data of the row group .The width of the row col groups seems to change even if I dont have stretch Type or stretch overflow defined. Any help on that.

[lucianc]

If you have two row groups A and B, you can obtain an extra row header that repeats for each B entry in one of the following ways:

1. Create a new group X between A and B having the same bucket expression as B. The header for the Y group would repeat for each entry in the B group.

2. Create a new group Y after B having a constant bucket expression (e.g. a fixed String). Again, the header of the Y group will repeat for each entry in the B group.

 

 

I'm not able to understand what kind of an alignment problem you have. Can you be more specific? What are the label headers and the data of the row group? Whose width changes and where (HTML export, PDF export, etc)?