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

Print selected pages from two separate reports on one click

P: 6
Hello everybody! I have two separate reports, each contains several subreports. Once in a while it is necessary to print certain pages from both reports for different users. I was wandering if there is a way to build a procedure that would ask first what pages from each report to print on one click. The challenge is that sometimes the pages change - i.e. if there is too much information, what usually was on a first page moves to a second and so on... Any help or ideas will greatly apprciated. Thank you, Serhii
May 1 '10 #1
Share this Question
Share on Google+
3 Replies

Expert 100+
P: 1,221
I think you're going to have to specify the requested information differently. If the user cannot know the page number they cannot specify a page number range.

Can the desired information be specified by subreport instead of page number? If so, then just give them a list of available subreports and they select the ones they want to see. Maybe you don't even mention "subreports" in the form where they make the request, it's probably Greek to the user. But word it so that they know what you are referring to and you know what that translates to in the report/program.

Then in the report.format event you can turn off the unwanted subreports by changing the Source Object to ""

Hope that helps,
May 1 '10 #2

P: 6

thank you for the suggestion. Normally, I would use a number of subreports to construct a resulting document the way it suits the users. However, my issue is of a little different nature. One of the reports is actually a map with plotted events. In order to plot events on the embedded image of a map, the PSet method is used, which works only on Print Format. In other words, I can not include this report as a subreport to any other report. It simply does not work... My guess, this is an Access issue that was designed that way originally. What I am looking for is a way to tell Access to interrupt printing one of the reports after certain number of pages, then print another one-page map report and then continue printing the remaining pages of the first report. It sounds convoluted, but it seems that this is the only way. Any help with this would be greatly appreciated! Thank you! Serhii
May 5 '10 #3

Expert 100+
P: 378
Would it be possible to just filter the reports for the data that's needed?
May 5 '10 #4

Post your reply

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