Create Book Report of Reports

  • Thread starter Thread starter Charles Phillips
  • Start date Start date
C

Charles Phillips

Hello,
I am using MS-Access 2003.
I have created a database (db) for taking inventory of ALL computers in a
company.
I have created reports of each dept. I have created a report on "current
computer configuration". I have created a report on "memory configuration"
in each computer. I have created 13 reports...

What I want to know, is there a way to combine / merge the reports I have
created into 1 report, like a book report.
If there is, can/will someone point me to some examples/samples. I have
tried looking, but I believe the content I am using for "search" is
incorrect...


Thank you,


Charles L. Phillips
 
Charels

This may not match your requirements...

One way to get all 13 reports to run in sequence would be to create a macro
and "call" each report, one after the other.

Another would be to add code to the OnClose event of Report1 that opens
Report2, and so on...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Hello,
I am using MS-Access 2003.
I have created a database (db) for taking inventory of ALL computers in a
company.
I have created reports of each dept. I have created a report on "current
computer configuration". I have created a report on "memory configuration"
in each computer. I have created 13 reports...

What I want to know, is there a way to combine / merge the reports I have
created into 1 report, like a book report.
If there is, can/will someone point me to some examples/samples. I have
tried looking, but I believe the content I am using for "search" is
incorrect...

Thank you,

Charles L. Phillips
Click to expand...

I suppose you could put all 13 reports into a single report (embedded
as subreports).

-Kris
 
Hello,
"Thank You", that sounds good too.
I'll try it out...


Thank you,


Charles
 
Charles Phillips said:
Hello,
I am using MS-Access 2003.
I have created a database (db) for taking inventory of ALL computers in a
company.
I have created reports of each dept. I have created a report on "current
computer configuration". I have created a report on "memory configuration"
in each computer. I have created 13 reports...

What I want to know, is there a way to combine / merge the reports I have
created into 1 report, like a book report.
If there is, can/will someone point me to some examples/samples. I have
tried looking, but I believe the content I am using for "search" is
incorrect...
Click to expand...

Are the fields consistent on the reports for different departments? That
is, if the only thing different is the department itself, then the report
name is "data" and that's not really a good practice.

If so, you should include the department name/id as data and put all the
information in a single table or set of tables and print them all in one
report. You can control the page numbering so each department starts over
with Page 1, and just separate the sheets in that report to send only a
department's own report if need be.

Larry Linson
Microsoft Access MVP
 
Back
Top