Column Binding possible in a Cross Tab?

Using BIRT 2.3, I've got a cross tab with two summary fields (total events, reject events) that are counts of data set columns. On the same row I'd like to add a column to divide the reject event by the total events for the percent rejects. I've not had any success trying to use a data item. What's the best way to do a calculation based on summary fields?

Find more posts tagged with

Comments

bsolnek

I've tried adding a derived meaure
(data["TOTAL_EVENTS"] - data["REJECT_EVENTS"]) / data["TOTAL_EVENTS"]
which displays the same value on each row, namely the percent of the Grand Total values instead of the percent of the individual row values.

mwilliams

Hi bsolnek,

So, you can figure the value, now you just want to replace it with a text string? Can you set up a similar report with the sample database? If not, could you attach a small sample of data in a flat file of some sort for me to work with so I can see what kind of data you're dealing with? Thanks.

bsolnek

Thanks Michael!

At your prompting I went and created a small example using the ClassicModels sample DB, and lo and behold it worked. I then returned to my production report and created a new Cross Tab with all the same data items as originally and it too worked. I'm both happy and miffed.

(BTW, this type of scenario has happened before to myself and others here, where something doesn't work but a new "clone" does work.)

mwilliams

bsolnek,

I'm not sure that I've seen this issue before myself. If there's any way you can recreate the issue and send me the report so I can see it fail so I can create another just like it and see it work, that'd be great. Not sure exactly what would cause this except maybe an issue with the XML source.

bsolnek

Not sure I can reproduce it at this juncture, but I'm pretty sure it is in the XML source, and may be related to adding and then deleting (trial and error) items via the GUI.

mwilliams

bsolnek,

Well, hopefully it doesn't cause you too much of an issue. Possibly upgrading to 2.3.2 or 2.5 when it comes out later this summer would solve any issues with that happening. Good luck! Let us know whenever you have questions!