Friday, March 23, 2012

Multiple Group/Detail Records are not showing

I have a report with a page header, a report header and footer, and many group headers, one group / detail line, and some group footers.

The problem is that only one record per ID is allowed in the one group/detail line. Both records per ID will show in data view but not in the report output. I do not have "allow duplicates" selected anywhere that I am aware of.

Where else can I look?

Thanks,
cj

I assume you are using table in your report. Is your table detail grouped on ID? If so, all rows with the same ID will be grouped into one. Try removing the grouping in Details Grouping and see if you get all records displayed.

No comments:

Post a Comment