Pie Chart Generation Question

Hi Guys,

I have a question about BIRT Pie chart generation. Here is the brief description of the problem.

I have table A containing Capacity information.

ResourceA 10

And table B contains allocation information.

ConsumerA1 2
ConsumerA2 3
ConsumerA3 3

Now if table B is used to generate the pie chart, then the total pie size for resource A is only 8 but I need to set the pie size to the capacity in table A. Also I need to label the remaining 2 units as "UNALLOCATED". Is there anyway to do acheive this in BIRT?

Thanks for any pointers,

with warm regards,
Venkat Saranathan.

Find more posts tagged with

Comments

mwilliams

Hi Venkat,

What does your data in your dataSet(s) look like? Can you attach your report design running off a .csv file of sample data so I can run it and see your setup? This'll make it easier for me to see if I can figure out something to help.

Thanks.

Saranathan

Mike,

Thank you for offering to help. I found a work around for the problem by modifying the SQL to insert the unallocation data as follows.

ConsumerA1 2
ConsumerA2 3
ConsumerA3 3
Unallocated 2

Basically I created two SQLs one to fetch the allocation information and another to fetch the Unallocation information and combined these two using UNION statement.

Not an ideal solution but works for me.

Thanks again,
with warm regards,
Venkat Saranathan.