reports: grouping vs. subreports

[annie]

I have used grouping to great advantage with reports that I've designed, and
I only happened to come across the existence of subreports recently. My
investigations into them have not provided me with much useful information.
Can anybody describe to me the situations where subreports are the preferred
method over grouping? What is the difference? I don't even know how to
create a subreport.

Thanks!

 

[Rick Brandt]

I have used grouping to great advantage with reports that I've
designed, and I only happened to come across the existence of
subreports recently. My investigations into them have not provided
me with much useful information. Can anybody describe to me the
situations where subreports are the preferred method over grouping? What is
the difference? I don't even know how to create a subreport.

Thanks!

Whenever you can achieve what you want with grouping then that is likely the
better way to do it. There are layout effects though that can only be achieved
with subreports. For example, non-columnar group header data with columns for
the details, or layouts with two subreports side by side.

I always start out assuming I will not use a subreport and move to them only
when I can't get what I want without them.

 

[Marshall Barton]

I have used grouping to great advantage with reports that I've designed, and
I only happened to come across the existence of subreports recently. My
investigations into them have not provided me with much useful information.
Can anybody describe to me the situations where subreports are the preferred
method over grouping? What is the difference? I don't even know how to
create a subreport.

You create a report that contains the data you want in the
subreport (without usin page header/footer). Once the
report is working, drag it from the database window and drop
it into the main report's design view. Check to make sure
the Link Master/Child properties are set the to the
appropriate linking fields (just like you would for a
subform).

Also, make sure the subreport's data is not included in the
main report's record source table/query as it would be if
you did it all with grouping.