Home Subreports
New Blog Posts: Merging Reports - Part 1 and Part 2

Subreport with teechart

edited April 2007 in Subreports
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.

Comments

  • edited April 2007
    Hi Anji,

    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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited April 2007
    Thanks Nico,
    But i have RB version 9.02 and I cannot open the project you have sent, the
    property ppReport1.EmailSettings does not exists.

  • edited April 2007
    I'm sorry but I am unable to create examples with older versions of
    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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
This discussion has been closed.