Pie Chart question

iomega55 · Post by **iomega55** » Mon Nov 27, 2006 11:36 am

I have this table:

type ET AT CN
----- ---- --- ----
info01 20 10 30
info02 0 5 20
info03 100 0 0

How can I reflect this information in pie chart, but only totals by column, ie SUM(ET), SUM(AT), SUM(CN) would be the pie series?

Is it easier to get this totals in my webapp and just pass the values to the report as parameters or can it be solved totally in designer?

Thanks again.

Post by **Vital** » Mon Nov 27, 2006 4:30 pm

You can use Datasource from other datasources. Aggregate data before using in piechart.

Thank you.