Combining Reports

  • Thread starter Thread starter Craig Det
  • Start date Start date
C

Craig Det

I have a MS Access Report question?

I have 50 single page reports that look like forms that are populated from a
query.

I have a form that lists all 50 reports with a check box next to each report
name.

I want to allow the user to select which pages they want to print.
{Example: The 1st 5 reports may be very similar and the user will choose
only one of them.
The same thing for the rest of the reports, but they can choose any
combination of reports to print.}

I will need the selected pages to be combined into a single report,
So they can all be printed, viewed, whatever needed... as a single document.

They can be combined in the order they were checked. No fancy ordering.

[I need the help with combining the reports as a single report. Everything
else I'm ok with.]

Any Ideas? Detailed help, code, would be appreciated!

Craig
 
Craig:

Two ways to do this.

1.) Create a shell report and place a number of empty sub-reports on it
(possibly with page breaks in between). When you user hits OK, then you'd
have open that report in design mode, and using VBA change the control
source of the sub-reports to be the "checked" reports. Size the subs on
this main report to near zero with their can grow set to true so that if the
user selects less subs than you have on the main report, the empty sub
doesn't show. To hide all the activity from the user (opening the report
in design mode) you can use either the Echo = False statement or use a
windows api call called LockWindow which freezes its updating until you
unfreeze by another LockWindow call.

2.) Output each report as a PDF file individually and then merge those files
into one; this would help with archiving as well. You can do this using a
tool like our PDF and Mail Library for Access.
 
I was looking at your products and didn't see a difference between the pro
and pro Plus?
I will try your suggestions and see what happens.

On #2 using your software will it merge the files to one PDF automatically?
Hiding from the user.


SA said:
Craig:

Two ways to do this.

1.) Create a shell report and place a number of empty sub-reports on it
(possibly with page breaks in between). When you user hits OK, then you'd
have open that report in design mode, and using VBA change the control
source of the sub-reports to be the "checked" reports. Size the subs on
this main report to near zero with their can grow set to true so that if the
user selects less subs than you have on the main report, the empty sub
doesn't show. To hide all the activity from the user (opening the report
in design mode) you can use either the Echo = False statement or use a
windows api call called LockWindow which freezes its updating until you
unfreeze by another LockWindow call.

2.) Output each report as a PDF file individually and then merge those files
into one; this would help with archiving as well. You can do this using a
tool like our PDF and Mail Library for Access.
--
SA
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

Craig Det said:
I have a MS Access Report question?

I have 50 single page reports that look like forms that are populated from
a
query.

I have a form that lists all 50 reports with a check box next to each
report
name.

I want to allow the user to select which pages they want to print.
{Example: The 1st 5 reports may be very similar and the user will choose
only one of them.
The same thing for the rest of the reports, but they can choose any
combination of reports to print.}

I will need the selected pages to be combined into a single report,
So they can all be printed, viewed, whatever needed... as a single
document.

They can be combined in the order they were checked. No fancy ordering.

[I need the help with combining the reports as a single report.
Everything
else I'm ok with.]

Any Ideas? Detailed help, code, would be appreciated!

Craig
Click to expand...
Click to expand...
 
Back
Top