Combine 13 different reports

[shm135]

Hi,

I have 13 reports, some of which have different columns. Each report
has a PAGE header so that the report is identified on each page,
incase it runs over one page. In an effort to save paper, and minimize
clicking- I would like each report to print out one right after the
other. Once the last result of one report is listed, I want the next
report to begin- starting with the header.

I'm not too familiar with sub-reports, but I tried having dragging my
second report on top of my first report. But then, I do not see my
page header, and the sub-report only shows as much information as the
size of the box allows it to show. This needs to be dynamic, depending
on the size/content of each report. How can I do this?

Thanks!

 

[Karissa]

If you put your page header info into the report header, it will show.

Set the "Can grow" property of your sub-report to "yes".

 

[Mark Andrews]

You could do something like create pdf files from all 13 reports and then
combine the pdf files into one pdf.
See stephen lebans site (if using access2003 and earlier) or get a pdf
printer driver (win2pdf.com is a good one).
In access2007 pdf exporting is more built-in.
Various pdf merging capabilities out there as well.

I would try ruling in/out the other suggestion before going this route.

Mark

 

[shm135]

You could do something like create pdf files from all 13 reports and then
combine the pdf files into one pdf.
See stephen lebans site (if using access2003 and earlier) or get a pdf
printer driver (win2pdf.com is a good one).
In access2007 pdf exporting is more built-in.
Various pdf merging capabilities out there as well.

I would try ruling in/out the other suggestion before going this route.

Mark









- Show quoted text -

Thanks for both of the suggestions. Mark, I am trying to remove the
whitespace between the reports- and have tried your method but that
only put each report together, without eliminating the whitespace.

Karissa,

I've tried this, and it appears to work when viewing the report.
However, when printing it, it still puts the next report on the next
page rather than immediately following the last result on the previous
report. In report one, I added subreport2 to my report footer. In
report 2, I added subreport 3 in the report footer. Is this proper way
to do things? Each report has a heading that needs to be displayed to
identify the report. How can I do this? Thanks!

 

[Karissa]

I would make one main report to combine the 13 sub reports. Put each
subreport in the order you want them in the detail of the main report; leave
as much or little space between each subreport as you want to have between
the reports when it prints.

 

[Mark Andrews]

You are correct the pdf merge method would only append each report to each
one back to back.

Use the other method suggested.

Only use my method if you CANNOT use the other method suggested.
Mark

You could do something like create pdf files from all 13 reports and then
combine the pdf files into one pdf.
See stephen lebans site (if using access2003 and earlier) or get a pdf
printer driver (win2pdf.com is a good one).
In access2007 pdf exporting is more built-in.
Various pdf merging capabilities out there as well.

I would try ruling in/out the other suggestion before going this route.

Mark









- Show quoted text -

Thanks for both of the suggestions. Mark, I am trying to remove the
whitespace between the reports- and have tried your method but that
only put each report together, without eliminating the whitespace.

Karissa,

I've tried this, and it appears to work when viewing the report.
However, when printing it, it still puts the next report on the next
page rather than immediately following the last result on the previous
report. In report one, I added subreport2 to my report footer. In
report 2, I added subreport 3 in the report footer. Is this proper way
to do things? Each report has a heading that needs to be displayed to
identify the report. How can I do this? Thanks!

 

[shm135]

You are correct the pdf merge method would only append each report to each
one back to back.

Use the other method suggested.

Only use my method if you CANNOT use the other method suggested.





Thanks for both of the suggestions. Mark, I am trying to remove the
whitespace between the reports- and have tried your method but that
only put each report together, without eliminating the whitespace.

Karissa,

I've tried this, and it appears to work when viewing the report.
However, when printing it, it still puts the next report on the next
page rather than immediately following the last result on the previous
report. In report one, I added subreport2 to my report footer. In
report 2, I added subreport 3 in the report footer. Is this proper way
to do things? Each report has a heading that needs to be displayed to
identify the report. How can I do this? Thanks!- Hide quoted text -

- Show quoted text -

Thanks. Please see my paragraph to Karissa, any ideas how to help?:

Basically, I added subreport2 to my report1 footer. In
report 2, I added subreport 3 in the report2 footer. Is this proper
way
to do things? Each report has a heading that needs to be displayed to
identify the report. How can I do accomplish exactly what I want?
Thanks!

 

[Mark Andrews]

Some sort of combine. Perhaps create one main report that does nothing with
13 subreports.

Mark

You are correct the pdf merge method would only append each report to each
one back to back.

Use the other method suggested.

Only use my method if you CANNOT use the other method suggested.





Thanks for both of the suggestions. Mark, I am trying to remove the
whitespace between the reports- and have tried your method but that
only put each report together, without eliminating the whitespace.

Karissa,

I've tried this, and it appears to work when viewing the report.
However, when printing it, it still puts the next report on the next
page rather than immediately following the last result on the previous
report. In report one, I added subreport2 to my report footer. In
report 2, I added subreport 3 in the report footer. Is this proper way
to do things? Each report has a heading that needs to be displayed to
identify the report. How can I do this? Thanks!- Hide quoted text -

- Show quoted text -

Thanks. Please see my paragraph to Karissa, any ideas how to help?:

Basically, I added subreport2 to my report1 footer. In
report 2, I added subreport 3 in the report2 footer. Is this proper
way
to do things? Each report has a heading that needs to be displayed to
identify the report. How can I do accomplish exactly what I want?
Thanks!

 

[shm135]

Some sort of combine.  Perhaps create one main report that does nothingwith
13 subreports.









Thanks. Please see my paragraph to Karissa, any ideas how to help?:

Basically, I added subreport2 to my report1 footer. In
report 2, I added subreport 3 in the report2 footer. Is this proper
way
to do things? Each report has a heading that needs to be displayed to
identify the report. How can I do accomplish exactly what I want?
Thanks!- Hide quoted text -

- Show quoted text -

Thanks for all of your help. I ended up creating a union query to
combine all of the initial as best as possible and used that to create
one report.

 

[Mark Andrews]

glad you got a solution!

Some sort of combine. Perhaps create one main report that does nothing
with
13 subreports.









Thanks. Please see my paragraph to Karissa, any ideas how to help?:

Basically, I added subreport2 to my report1 footer. In
report 2, I added subreport 3 in the report2 footer. Is this proper
way
to do things? Each report has a heading that needs to be displayed to
identify the report. How can I do accomplish exactly what I want?
Thanks!- Hide quoted text -

- Show quoted text -

Thanks for all of your help. I ended up creating a union query to
combine all of the initial as best as possible and used that to create
one report.