Reset dataset in subreport
I'm currently attempting to build a report, including a sub-report which
uses the exact same dataset but presents a different set of information.
The dataset is used in the detail section of the main report, and the
sub-report is a section sub-report. However, the sub-report will only
ever print the last line item in the dataset.
Main Report
Detail
----> Line 1
----> Line 2
----> Line 3
Sub-Report
Detail
----> Line 3
Is there some way that I can reset the dataset to start from the
beginning again? As the report I'm working with already has a
pre-defined dataset that I can not change, adding a duplicate dataset
isn't an option.
Regards,
John Kennison
uses the exact same dataset but presents a different set of information.
The dataset is used in the detail section of the main report, and the
sub-report is a section sub-report. However, the sub-report will only
ever print the last line item in the dataset.
Main Report
Detail
----> Line 1
----> Line 2
----> Line 3
Sub-Report
Detail
----> Line 3
Is there some way that I can reset the dataset to start from the
beginning again? As the report I'm working with already has a
pre-defined dataset that I can not change, adding a duplicate dataset
isn't an option.
Regards,
John Kennison
This discussion has been closed.
Comments
Make sure that you are connecting the childreport to the datapipeline. Each
report/childreport will traverse the datapipeline to which it is assigned.
Each will traverse all records in the dataset from first to last.
A report/child report that is not connected to a datapipeline will print a
single detail band and then stop. Each data-aware control will print the
value of the current record. I think that is why you are getting only the
last detail record displayed by the subreport.
--
Nard Moseley
Digital Metaphors Corporation
www.digital-metaphors.com
Best regards,
Nard Moseley
Digital Metaphors
www.digital-metaphors.com