Having crosstab displaying sections

Hi there, I am a fresh new user of BIRT (2.2.2) and I came here to seek for some advice or help.

This is my situation : I'm creating a crosstab in a report that uses 3 dimensions :
- One called "Application"
- One called "Severity"
- Date dimension

I am displaying for theses dimensions a calculated value that represents a sum of "anomalies"... So I have it done correctly, but I am not really satisfied with the display of the crosstab.

In fact I would that one of the dimensions, the Application, is showed as kind of a Section, and then the crosstab is displayed for every value of that section. Like Grouping in fact, but I can't have it working !

As an image is worth hundreds words, I am attaching 3 files that are representing my actual crosstab layout and display, and the way I would like it to be displayed.

So here are my questions :
- Is it possible to do what I want to do with this version of BIRT ?
- What Report Objects should be used ?

Please note that I tried actually with including my crosstab into a Tab having Application Group, but I had an awckward behavior, like croostab displaying 15 times for each group value, and with non correct data...

Thank you for any ideas !

Find more posts tagged with

Comments

mwilliams

Hi Yasso,

Are you required to use 2.2.2? Or can you upgrade to a 2.3.x version? In 2.3.x, you can use a crosstab as a subreport and filter it based on the outside table. In 2.2.2, it seems to have a problem with the filter on the crosstab. There were many upgrades to the crosstab element from 2.2 to 2.3.

Yasso

Hi mwilliams and thank you for your answer,

I was indeed required to use 2.2.2 but it looks like an upgrade is possible, so I'm going to try the 2.3 version asap. In the meen time, could you tell me the big steps to do that ? as far as I understand, I have to :
- create a subreport and put a crosstab on it
- use a filter based on the outside table ? (could you please describe this step a bit more).

Is that right ?

Thank you anyway, I might get back to you if I'm still unable to do that

P.S : Do you know where can I find documentation on these functionalities ?

Thanks !

Yasso

Hi again !

Ok I almost have it done correctly.

I placed my crosstab inside a Table having a group on "application". My crosstab is filtered based on the "application" of the table and it works... almost fine ! Now I have my table displaying the Group elements (one application) and then it displays like 23 crosstabs !!! the crosstabs contains only rows for the first application, so filtering is ok, but why do I have more than 20 crosstabs ???

In my Table, a put the crosstab into the Detail Row, is that a mistake ? Because if I put the crosstab into the Footer Row, it works perfectly as expected !

So I would like to ask you, is this normal behaviour ? because it seems to me that it's messy to put the crosstab into the footer row...

Thanks