View Single Post
  #1  
Old July 30th, 2007, 06:22 PM posted to microsoft.public.access.reports
AccessHelp
external usenet poster
 
Posts: 161
Default Please help with Grouping

Hello all,

I have a report with a sub-report. The sub-report is located in the Detail
section of the report and linked (master and child) using a book code. The
problem that I am having is when I have records in the sub-report, they will
show for each record in the Detail section of the report. At the same time,
when there are no records in the sub-report, the sub-report area will have a
big area of blank (again) for each record in the Detail section of the
report.

What I like to do is when there are records in the sub-report, instead of
showing after each record in the Detail section of the report, I would like
all the records in the Detail section of the report group and show the
records of the sub-report after the records of the Detail section of the
report for that book code.

On the other hand, when there are no records in the sub-report, I would like
the records of the Detail section of the report grouped without showing a big
area of blank.

Please help. Thanks.