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.

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


"Dwain Adams" wrote:

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

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" wrote:

> 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.....
> -- 
> NTC
> 
> 
> "Dwain Adams" wrote:
> 
> > 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.

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


"Dwain Adams" wrote:

> 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" wrote:
> 
> > 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.....
> > -- 
> > NTC
> > 
> > 
> > "Dwain Adams" wrote:
> > 
> > > 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.