By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,830 Members | 1,746 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,830 IT Pros & Developers. It's quick & easy.

Printing a report with subreports

P: 1
Hello,
I have a MS Access 2000 question.
I created a main report that consists of different subreports in the Detail section. I have a couple of queries that create tables for certain cities (the user enters the City ID). Everything works fine until the user enters an ID for a city that we don't have information for in all tables and then wants to see the report.

When printing the separate subreports - the report still shows up just with an empty line below the table heading (which is the report header) - which is good.
When printing (also preview) my main report only the subreports that have records for that city show up and the subreport with no entry for this particular city will not show up at all.
I would like to see the table heading (report heading) in my main report - if nothing else as a placeholder on my report (in stead of big white spots).

It would be great if somebody can give me a hint how to solve this problem.

Thanks,
Martina
Sep 7 '07 #1
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
Hello,
I have a MS Access 2000 question.
I created a main report that consists of different subreports in the Detail section. I have a couple of queries that create tables for certain cities (the user enters the City ID). Everything works fine until the user enters an ID for a city that we don't have information for in all tables and then wants to see the report.

When printing the separate subreports - the report still shows up just with an empty line below the table heading (which is the report header) - which is good.
When printing (also preview) my main report only the subreports that have records for that city show up and the subreport with no entry for this particular city will not show up at all.
I would like to see the table heading (report heading) in my main report - if nothing else as a placeholder on my report (in stead of big white spots).

It would be great if somebody can give me a hint how to solve this problem.

Thanks,
Martina
Put the headings for the subreports on the main report and just keep the details in the subreports. That way the headings will always print.
Sep 8 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.