How to do pie chart by group??

Carrie · Post by **Carrie** » Tue Aug 18, 2009 3:09 am

Hi...may i know how to do the pie chart in grouping?
i facing a big problem on this..anyone can help me???
:dumb:

Post by **Edward** » Tue Aug 18, 2009 6:34 pm

Hi Carrie,

For rendering Pie Chart in such reports you have to replace grouping with the Master-Detail relationship in report. Please follow the steps:

Select Report object in the 'Properties' window of the report. Set CacheAllData property in true.

Based on the DataSource for grouping create 'Data From Other Data Source' datasource. This datasource must be used as the master source in the report.

Add a relation between 'Data From Other Data Source' (master) and that datasource you used for grouping (detail).

Place a Databand with 'Data From Other Data Source' as its datasource in the page.

Place a PieChart Into this databand.

Set PieChart.DataSource = your detail datasource.

Set PieChart.DataRelation = your new relation.

Thank you.

Carrie · Post by **Carrie** » Wed Aug 19, 2009 10:05 pm

Edward,
What is the meaning of create 'Data From Other Data Source' datasource?
is it my report have 2 datasource there?
if so means after I generate my report there will show 2 datasource on my report?
hope you can help me solve this question..
thank you.

Post by **Jan** » Fri Aug 21, 2009 3:28 am

Hello,

"Data from other Data Source" is special datasource which allow made some additional operation on standard datasource. Please check attached image.

Thank you.

Carrie · Post by **Carrie** » Sun Aug 23, 2009 10:30 pm

Thanks Jan..I found the 'Data From Other Data Source' datasource already..
I still have a problem is I only can set PieChart.DataSource = detail datasource but failed to set PieChart.DataRelation = new relation..
May you tell me the step by detail?
Thank You.

Post by **Edward** » Mon Aug 24, 2009 5:08 pm

Hi Carrie,

Please find report template and video. You can open attached report in the Demo.exe sample application which is a part of standard installation.

Video

Thank you.

Carrie · Post by **Carrie** » Tue Sep 01, 2009 1:55 am

Thanks Edward.It's working..

but now I still have a small problem is how can I join the data in data source by group?

I mean only show a pie chart with grouping data but not show the data and chart one by one..

hope you can help me to solve this problem..thanks..

Post by **Edward** » Tue Sep 01, 2009 7:58 pm

Hi Carrie,

You are welcome.

Sorry, this feature is not available in Pie chart.

Thank you.