Subreport with teechart
Hi,
Delphi Version: 7
RB Version: 9.02
Tee Chart Pro Version:7.04
I have a master table with school Id.
Detail table with school id, childcount, pink, blue, yellow.
I want to create a master-detail report, with a pie-chart showing the % of
pink, blue, yellow for each schoolId.
I have created 2 datapipelines, and the detail band has a subreport, with
datapipeline to the detail table.In the subreport (not in the new tab, but
the section)i have added a pie chart. I do not understand how i should get
this pie chart to display values for the current schoolId.
Can someone please help me ?
Anji.
Delphi Version: 7
RB Version: 9.02
Tee Chart Pro Version:7.04
I have a master table with school Id.
Detail table with school id, childcount, pink, blue, yellow.
I want to create a master-detail report, with a pie-chart showing the % of
pink, blue, yellow for each schoolId.
I have created 2 datapipelines, and the detail band has a subreport, with
datapipeline to the detail table.In the subreport (not in the new tab, but
the section)i have added a pie chart. I do not understand how i should get
this pie chart to display values for the current schoolId.
Can someone please help me ?
Anji.
This discussion has been closed.
Comments
If you would like to show the percentages for each individual school ID, you
will need to place the chart inside the subreport's title or summary band
and connect to the detail pipeline using "color" as the label and "count" as
the pie value. Below is a simple example I created that demonstrates this.
http://www.digital-metaphors.com/tips/MasterDetailTeeChart.zip
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
But i have RB version 9.02 and I cannot open the project you have sent, the
property ppReport1.EmailSettings does not exists.
ReportBuilder. The example consists of a master/detail report with the
Customers and Orders tables in the DBDEMOS database (linked on CustNo).
I created a group on CustNo in the main report and placed a subreport
connected to the Orders dataset in the detail band. Inside the subreport I
placed a DBTeeChart inside the Title band and connected it to the Orders
dataset using OrderNo as the labels for the pie chart and AmountPaid as the
pie value. This created a report that shows a pie chart for each customer
displaying the amount paid per order.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com