More than a page for every record
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
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
This discussion has been closed.
Comments
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
It work very well.
Thanks for your support,
Jose Maria Sanmartin