section subreport with child subreports
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
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
This discussion has been closed.
Comments
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
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com