What's the best way to design a muliple section sub-reports report?
Hi,
I want to design a muliple section sub-reports report. What i would like to
have is a Mainreport, that just is a collection off my different
sub-reports. So i put my different sub-reports in the header band of the
Main report, DataPipeline property of my Main report is set to nil, it don't
need to be printed because it's just the wrapper of my sub-reports. Every
sub-report PrintBehavior is set to pbSection. Every sub-report is a fully
seperate designed report with its own DataPipelines. The problem i get is
that on some sub-reports some controls with an other pipeline then the main
pipeline of the sub-report don't have any values. If i put them on a
seperate sub-report inside with its DataPipeline set to the same pipeline it
works. Other thing i see that headers only are printed on the first page of
every sub-report, sub-sequent pages are filled with detail bands from top to
bottom. Mayb i'm doing things the wrong way, so what's the best procedure to
design this kind of reports. Where to put the sub-reports on the main
report? Can i leave the DataPipeline from my Main report unassigned bc the
Main report doesn't need to be printed?
Greetings,
Filip Moons
I want to design a muliple section sub-reports report. What i would like to
have is a Mainreport, that just is a collection off my different
sub-reports. So i put my different sub-reports in the header band of the
Main report, DataPipeline property of my Main report is set to nil, it don't
need to be printed because it's just the wrapper of my sub-reports. Every
sub-report PrintBehavior is set to pbSection. Every sub-report is a fully
seperate designed report with its own DataPipelines. The problem i get is
that on some sub-reports some controls with an other pipeline then the main
pipeline of the sub-report don't have any values. If i put them on a
seperate sub-report inside with its DataPipeline set to the same pipeline it
works. Other thing i see that headers only are printed on the first page of
every sub-report, sub-sequent pages are filled with detail bands from top to
bottom. Mayb i'm doing things the wrong way, so what's the best procedure to
design this kind of reports. Where to put the sub-reports on the main
report? Can i leave the DataPipeline from my Main report unassigned bc the
Main report doesn't need to be printed?
Greetings,
Filip Moons
This discussion has been closed.
Comments
what you are trying to do is certainly doable (i do it all the time)
- you don't have to assign a pipline to the report (main) itself, just set
the properties of the report so that the report always be printed
- i would place all subreports into the detail band of the main report
- each subreport needs its own pipeline if you want to print data, but since
the sub report only masters the assigned pipeline it will not print values
out of another pipeline, you will have to make sure that other pipeline is
opened and then you'll only will be able to print out the values of the
current record since the subreport will not traverse the data in that other
pipeline
depending on what you're after you could get the desired data into the
pipeline of the subreport by means of joined tables or by pulling all data
into a memory dataset and printing that one, but i guess you'll be better
off with another nested child subreport
- never had a problem with the headers, just set the property to repeat the
header on subsequent pages
cu
marc