Create Book Report of Reports

[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

 

[Jeff Boyce]

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

 

[krissco]

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

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

-Kris

 

[Charles Phillips]

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


Thank you,


Charles

 

[Charles Phillips]

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


Thank you,


Charles

 

[Larry Linson]

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...

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