If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
reports: grouping vs. subreports
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! |
#2
|
|||
|
|||
reports: grouping vs. subreports
annie wrote:
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. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com |
#3
|
|||
|
|||
reports: grouping vs. subreports
annie wrote:
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. -- Marsh MVP [MS Access] |
Thread Tools | |
Display Modes | |
|
|