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

What's my best bet

edited May 2003 in General
RB v6.03, Delphi 6 SP2.

I'm some what new to RB and have trouble deciding the best approach for a
report we need.

The report will have a common header and footer band for all pages.

The twist is in the detail band. We need to print data for parts required to
build our panels. The parts come in 6 basic type (each type has the
different fields that describe each type). Each type can have several parts
(each part has different data for it's fields).

Types may or may not need to be printed and the number of part will be
different from panel to panel.

What would be the best approach?

TIA
Tom

Comments

  • edited May 2003
    Tom,

    I would recommend trying a Master-Detail-Detail style report. Your master
    dataset should hold the part types. The first detail dataset should have
    the parts required for each type, and the second detail dataset should
    contain the data for each individual part. Then in the detail band of the
    report, you can use two subreports to display the detail information for
    each part type. Check out the ReportBuilder Developer's Guide
    (\RBuilder\Developer's Guide) for a complete tutorial on creating
    Master-Detail-Detail reports. You may also want to check out the Drilldown
    tutorial as well.

    --
    Best Regards,

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