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

Reset dataset in subreport

edited July 2004 in End User
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

Comments

  • edited July 2004

    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
This discussion has been closed.