Grouping in BIRT

ssekhar

Hi,

I have problem with grouped column in BIRT.

Here is the detailed explanation with the example.
1. I created a query like this.

select window_id, uic, unit_short_desc, percentage from test where window_id = ?
group by window_id, uic, unit_short_desc

2. i created a report parameter called window_id and assigned a default value for it.
3.i created a dataset parameter and assigned report parameter as a default value.
4. I created a table with grouped column. I grouped it by window_id.
I added a pie chart to the grouped column.

I added 2 conditions to the Map list of grouped column.
one is row[window_id] equals to "05"
another one is row[window_id] equals to params["Window_id"].value(the default value is "04").

window_id column contains 4 distinct values, but i want to generate only 2 pie charts based on above condtion.

My problem here is I am getting only a single pie chart for "04".

Please help me how can I get 2 pie charts.

Thanks in advance
Thanks,
Sekhar.

mwilliams

Hi Sekhar,

Can you create a sample report using the sample database with a similar setup to what you're wanting? This way I can see exactly what you're looking at? Thanks.