Make a separate report for each group...

[aalex]

Hello guys,

I have a database with one table that keeps records of outgoing phone calls made by my work colleagues. At the end of each month i run a report that reads from this table and returns data grouped by "Person" and starts each group on a new page.

So i print the report (almost 600 pages) and sort them by each person (about 100 people) and then i distribute them manually.

What I would love to be able to do is to print a separate file for each person and then email each person their own file, which would contain their own records.

I have already tried to use Leban's ReportToPDF and it worked in that it converted the full report to PDF but i do not know where to start in order to break up this report into many small ones.

Any help would be much apreciated, although i should alert people that i just started using access and know nothing about programming.


Thanks

aalex

 

[pbaldy]

There are a couple of ways to do this type of thing. To use SendObject or OutputTo directly, the report generally needs to filter itself. Ways include having its source query filter based on a form or things like this:

http://granite.ab.ca/access/email/reporttomultiplerecipients.htm

Another way that can work is to open the report filtered using a technique like this:

http://www.baldyweb.com/wherecondition.htm

and then exporting or sending the report, then closing it again. I generally use a method like the first, but the second works.

 

[aalex]

Hello pbaldy, and thanks very much for responding.

i apologise for my newbieness, but how would i go about implementing either one of the solutions you propose?

Would i need to have a form on which i will add a command box to call the procedure?

Sorry if this is a silly question, but i really dont know how to go about implementing.

Your first proposal sounds more appropriate because its end result is exactly what i need done, but i cannot understand what it requires me to do...

Any further insight would be apreciated.

Thanks once again for your time.

aalex