Crosstab report :- cells merged because of repeating value

Reji · 2009-02-14T23:48:46+00:00

Hi, I have a crosstab report as Capacity Booked ...... <hr></hr> J Y J Y FLIGHTNO FROM TO A/C <hr></hr><hr></hr> 1000 LHR DXB 73J 20 140 5 100 3000 MCT LGW 310 15 120 10 80 2000 ABC LHR 310 10 130 11 79 2000 ABC BEY 310 11 131 12 80 .... ..... ..... I have…

Reji

Hi,

I have a crosstab report as

Capacity Booked ......

J Y J Y
FLIGHTNO FROM TO A/C

1000 LHR DXB 73J 20 140 5 100
3000 MCT LGW 310 15 120 10 80
2000 ABC LHR 310 10 130 11 79
2000 ABC BEY 310 11 131 12 80
....
.....
.....

I have created Flt No, From, To, A/C, Capacity and Class as groups(dimensions) and its working fine..

But if the value in Flight No. repeats, the tow cells as merged.(cells with value '2000'); if ?From? is same, they are also merged('cells with value ABC')? How can I avoid this?

Repeat Row Header and Repeat Column Header are set to true. (But this property is used for some other features, rt?).

Thanks in advance

regs,
reji

Find more posts tagged with

Comments

mwilliams

Hi Reji,

Yeah, the repeat row header and column header are for page breaks. Can you send me a flat file of sample data how you have it in your dataSet, so I can make a report with it to see if I can figure something out to help? Also, what version of BIRT are you using?

Reji

hi,
Thank you for your reply.

I am using version 2.3.1

Sample data for the cross tab is attached in the txt file as comma separated values.

For a similar set of data, how it's rendered is attached in the image. You can see flt. no. 685 has a row span of 3..what i want is, it should be repeated in all 3 rows ..(similarly for flt no. 686, 643 etc) . Same rule applies for 'From' column.
I do understand this is the default behaviour of cross tab/group left. But is there any way to say 'show repeated values' (i believe a similar feature is available in Jasper reports)..

Thanks in advance,
Regs,
Reji

mwilliams

Reji,

I'm pretty sure there's no setting to get all the repeated values to show. Here's a workaround that may work for you. If you move all the row dimension headers to the very right "row dimension" column, make each of the element's section -> display value "inline" rather than "block" in the advanced tab of the property editor, set the width of that cell to be enough to handle all of them inline, then hide all of the other blocks with background and border colors to mask the gray lines. This may not work because of the space it leaves on the left side of the page though. Let me know.