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

section subreport with child subreports

edited January 2006 in General
at run time we load various rtm files depending upon the reports options
the user selects. i create a subreport for each of the rtm files to be
used. each subreport has its own query- no master/detail or links,
basically each query is self contained. we have 24 possible rtm files
that can be run one at a time or the user may request to run all 24 at
the same time. 23 of the 24 subreports are a single childsubreport. so
i create the subreport and runtime as a section report so the report
will print all of its records before proceeding to the next subreport.

the one odd subreport, containing 6 child subreports. the intent is if
this report is selected, it will run its 6 child reports for the single
record before moving to the next record in the query, so basically for
each record in the query there should be 6 reports generated (one for
each of the child subreports). as with the others i'm creating the
'parent' subreport as a section style. the subreport does not have a
datapipeline associated with it, the pipelines are on the child subreports.

so what i need is to
read the record, print child subreport1, print child subreport2, ....
print child subreport6;
read next record and print each child subreport...

obviously i haven't gotten this to work correctly ... what the best way
to create this type of report?

thanks!
-martha

Comments

  • edited January 2006
    Hi Martha,

    For each record in the main report, are all the subreports printing the same
    data? For instance, does the data in the 6 subreports need to change based
    on the main report's record? If so, you will need to create a master-detail
    report, linking a dataset with all of the initial records with detail
    datasets that the subreports access.

    If not, you should simply be able to place 6 subreports inside the detail
    band of the main report and link that report to a pipeline. Then for each
    record, all six subreports will print.

    --
    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.