Teechart and ReportBuilder multi-page query

rbuser

Hi,

I have departments, and in each department I want to display a graph showing
how man Permanent, Casual and Other employees there are. I want a separate
page for each department. Can this be done using TeeChart and
ReportBuilder? (RB V6.03 & TC V5.02).

Thanks

Alex

digitalmetaphors

Hi Alex,

Basically you want one department record printed on each page. For each
page, there is a detail query that should print a chart. If you connect the
detail datapipeline to the chart, it will only print the detail records for
a given master just like a subreport would do. You'll need a master detail
report so that you can connect a chart to print the detail data. In order to
have the pages break, create a simple group that is based on the primary key
of the master. Then set the Start New Page on the group so that the master
will only print one record on each page.


Cheers,

Jim Bennett
Digital Metaphors