Export or Print multiple reports from one Access Report by Group

[Dwain Adams]

I have a sales report that is grouped by Salesperson. Each salesperson has
multiple pages of the report and I need to either print it or export it to
PDF as individual reports for each salesperson.

Is there a way to export/print the report into seperate reports for each
Salesperson?

Thanks. I am pretty new to Access, but I have figured out how to get the
report in the structure I want it. I just can't get the information out of
the program in the format. I can print as one PDF document and then go and
cut that up in Adobe, but I wanted to see if Access could do it for me and
save me a bunch of time.

 

[NetworkTrade]

for someone new to Access the way to do it would be to create a Report per
salesperson - and then string together serially the opening of each report
via a Macro. that Macro can be triggered by one button and will then
generate all the individual reports... That is fairly accessible to a
noncoder.

if you are a coder new to Access; you would create a DoCmd to generate a
single report and then code a loop for that command until all Reports have
been generated.

I believe you need Access07 to write to PDF as an embedded function - and
with earlier versions requires an add-in....you can search this area for that
point there is alot of dialog on it.....

 

[Dwain Adams]

WIll I have to write a different report for each Salesperson, or can I write
one report that will just keep running until they are all complete? Can the
Macro also save the reports after it has run them?

I am not a Coder. I am the annoying HR guy that calls the IT professionals
when I need the program to do something, but I don't have any clue on how to
make it work. Actually, I am not completely clueless, but coding is one area
where I know almost nothing.

 

[NetworkTrade]

well... it sounds like it might be most feasible for you to do a report per
salesperson from a tech perspective....make one and just copy it
repeatedly....and the same with the underlying query. a bit brute force if
you have alot....but no coding...

but your question on auto saving the report makes one wonder a little
because the database is where one saves data....generating a report just to
save it is a little contradictory; you can get the report generated on
demand any time so there is no real reason to save it....but having said
that; the save in the macro would be to the same specified path location for
a noncoder so it would only work once and then would write over the document
each time - unless of course you manually move those files in the interim.

most db designers would steer you away from where you are going; I would say
- do not make a report per salesperson; make a report that prompts you for
which sales person you want to view and dynamically view info when you need
to....rather than mechanically generating reports and saving....