Sub reports

I would like to place a subreport on an existing report.  Where on the main report do I place the subreport so that it will print right after the main report?  Both reports are using the same query.

I placed on the first grouping footer I am not getting the headings of sub report.

Thanks
KdankwahAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

AccessGuy1763Commented:
I think the best place to put it would be the Report Footer if you really want it after the entire main report.  Putting it in the first grouping footer would cause it to show once per grouping .
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Access won't show headers or footers for subpreports. You have to create a new Group and put your headers there. See this EE question for more details:

http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_28099650.html
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Also define what you mean "right after the main report".

Do you mean after the ENTIRE report, or after each Detail section in the report?
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

KdankwahAuthor Commented:
After each detail section.
0
etech0Commented:
So put it in the detail footer. You might have to right click on detail and click 'show header and footer'
0
KdankwahAuthor Commented:
I I want it after the entire report then should I put right after the main group footer which is my Dept footer, right?

Thanks
0
etech0Commented:
You should put it in the section called "Report Footer"
0
Jeffrey CoachmanMIS LiasonCommented:
I'm confused, ...First you say:
"right after the main report?"

Then you say:
"After each detail section. "

Now you say again:
"after the entire report "

Lets be clear.
Please post a sample of the report as it stands now, then post a clear graphical example of what you need...
0
KdankwahAuthor Commented:
I am so sorry, this is it I have summary report and a detail report.  I want the detail report to run right after the summary report.  I hope I am clear now.

Thanks
0
AccessGuy1763Commented:
It's not clear to us which one of those two is the main report.  Incidentally, if you make them both subReports and make a main report to give them a home then you can just put them in the order you want.
0
KdankwahAuthor Commented:
Summary report is the main report.

Thanks
0
etech0Commented:
AccessGuy1763's idea was a good one - make a "shell" of a report with nothing in it, and then just bring both reports into it.

Or you can put the second report in the report footer of the first one.
0
AccessGuy1763Commented:
So if "Summary" is the main report, you have to put the "Detail" report as a subreport in "Summary"'s Report Footer section.  Incidentally, calling reports just "Summary" and "Detail" is very confusing considering one might think you are talking about the detail section of the report and not a totally separate report named "Detail".
0
KdankwahAuthor Commented:
I tried that but the problem is the headings don't show up.  I listened the video on Youtube and it mention that you can use dummy groups for the headings.  I will try that and see. I will leave this open in case I have to come back.

Thanks
0
AccessGuy1763Commented:
Which headings are you referring to?  I have a report I'm working on at this very moment that is nothing but a container to hold 4 sub reports.  I have my headings in the Report Header of the sub reports and all of them show up.
0
AccessGuy1763Commented:
Wait did you try putting the headings in the Page Header of the sub report?  Only the main Report has Pages so they wouldn't show up.
0
KdankwahAuthor Commented:
Each of the report has headings.  Does your container has page header or report header?
0
AccessGuy1763Commented:
Here is my design:

Main Report:
Report Header = Main report title
Detail Section has 4 distinct sub reports

- Each sub report has a title (think of it as a report section title) and appropriate headers for each column all in their individual Report Header sections.
- Each sub report has the main fields in the detail section.
0
KdankwahAuthor Commented:
Thanks, I will try this and get back to you.
0
Jeffrey CoachmanMIS LiasonCommented:
Kdankwah,

This is why I asked for a sample database, then we can save all the time of guessing what you have, and guessing what you want...
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.