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

More than a page for every record

edited April 2004 in End User
Hello,

Imagine I have a table with the following fields:

FieldA01: String;
FieldA02: String;
FieldA03: String;
...
FieldB01: String;
FieldB02: String;
FieldB03: String;
...
FieldC01: String;
FieldC02: String;
FieldC03: String;
...
FieldD01: String;
FieldD02: String;
FieldD03: String;
...

I want to print a page for fieldsA when there is something in FieldA01, a
new page for fieldsB when there is something in fieldB01, a new page for
fieldsC when there is something in fieldC01 and so on.

How can I do it?

I am using ReportBuilder Enterprise 7.

Thanks,


Jose Maria Sanmartin

Comments

  • edited April 2004

    1. Create a main report and remove the header/footer so that the layout
    contains only a detail band..

    2. Connect the report to the DBPipeline.

    3. Add 4 subreports and set each to PrintBehavior of pbSection.

    4. Access the workspace for each subreport and layout the fields
    corresponding to field set (FieldA, FieldB, etc).

    5. Use the main report DetailBand.BeforePrint to set the subreport
    visibility.

    if myPipeline['FieldA01'] <> '' then
    mySubReport1.Visible := True
    else
    mySubReport1.Visible := False;


    With the above conifguration the main report will traverse the data. Each
    section subreport will print a single page.




    --
    Nard Moseley
    Digital Metaphors
    http://www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited April 2004
    Nard,

    It work very well.

    Thanks for your support,

    Jose Maria Sanmartin

This discussion has been closed.