add generic pages to access generated report to export to pdf

[Gilley178]

Right now I can generate a report that groups data per each sub group. I then export them to individual PDF files by a VBA code. So the report with group ID 555 generates with group 555’s data and so on. I need to add generic full pages to each group document. I tried a few things but it doesn’t really work. I’ve ran into random problems/glitches trying different quick fixes. I figure there has to be a correct way to do it. Does anyone know? The pages could be added as PDF’s, or images. Thank you!

[jimatqsi]

Gilley178, Try to be clear and complete with your requests. What does this mean: " I need to add generic full pages to each group document."

I have no idea what you're trying to accomplish.

Jim

[Gilley178]

I generate individual PDF documents from a report in Access. For example report 555 generates with report 555’s group associated information. So there is generally around 300 of these individual PDF files. I need to add 3 generic pages with each pdf file. Generic, meaning that the information on them is the same for each of the 300 PDF files. I need to combine the generic 4 page document with each report. I’m thinking that there has to be a way to do this with the report generation.

[jimatqsi]

Oh, great, thanks for the clarification. Yes, there is a way, by using a sub-report.

Make a new report for your generic pages. Then, add this new report as a sub-report to your design of the existing report. You can do this by simply dragging the generic report to the report footer (or header or where you find it most appropriate) of the main report.

You'll need to look out for some gotchas. A sub-report's page headers never display. So if you need page headers in your generic report, just add grouping to your generic report and move the page headers to the top-most group. Also, you'll probably want to remove the border that appears by default around the sub-report.

Give it a go, you'll find it is very easy to do.

Jim

[NeoPa]

Great solution Jim. I like that :-)

[Gilley178]

Thank you for the suggestion. I have been working on it for the past couple of days. Its good to have learned about sub reports and forms. I unfortunately ran into the same issue though. The main body has a maximum of around 21 inches. The reports are quite difficult to get to generate correctly when sticking into the header and footer. It cuts them up and into multiple pages due to conflicts with the margins. I also experimented with converting the images to specific dimensions using paint and then importing them into access to try and manage the report generation errors. It didn't work though.

[jimatqsi]

It's not very clear what the issues are. 21-inches, top to bottom, is likely to be two pages. You say 'main body', does that mean the report for group ID 555(or similar group) is that long before you add the generic part? What does 'conflicts with the margins' mean?

I don't have any experience with printing images, except an occasional logo here and there.

If you could restate the problems you are having, as clearly and concisely as possible, it may help someone help you.

[strive4peace]

hi Gilley,

would you please provide the VBA code you're using to make the individual files?

It seems to me that each report would be filtered such that there is only one group, create the PDF, then loop to the next group and repeat until done.

How is your report set up? Are you using the Report Header section? Group header/footer sections? Detail section?

thanks!