report printing

[Guest]

Hi,
I have created a report that is 70 odd pages long. The report is a list
of people and is grouped by a code. Each code is on a differnet page of the
report. I was wondering if there is a way of running the report as a whole
(all pages) and then when it is printed to a pdf, i could run some vb code
that will break the report into each code and save a pdf for each code, so I
end up with many smaller reports rather than one.

I appreciate that could set a parameter to run the report by each code
rather than as a whole, but this will take the user much longer.
Does any one have any suggestions?

Thanks

 

[Guest]

Have you tried changing your group settings in the design view of your report
for Keep Together as NO?

 

[Guest]

Sorry, perhaps I didn't explain myself very well. I'm perfectly happy wth
the report lay out. maybe a small example might make things clearer.

Lets say the report consists of 5 pages.
Page 1 has a list of people for code BSS001
Pages 2 and 3 list people for code City001
Pages 4 and 5 list people for code City002.

What I want to happen is when the report is run it shows the 5 pages and
when the user selects to print (which is defaulted to pdfcreator) it will
print page 1 only and save it as filename BSS001, then it will print pages 2
and 3 only and save them as filename City001 and then it will print pages 4
and 5 only and save them as filename City002. So I end up with a pdf file
for each code. Does that make sense?