Multiple Report Creation

[Louise]

I have developed a report that is grouped by vendor and
lists all the invoices for each vendor. I need to be able
to send each vendor just their section of the report via
SendObject but there does not appear to be any way to do
this. I can only ssend the entire report. Is there
anything I can do to make this work?

 

[Larry Linson]

Separate reports for each vendor is the only way that I know... I don't know
of any way to break up a report, electronically, into sub-parts.

Larry Linson
Microsoft Access MVP

 

[Louise]

The vendor list changes daily and the report needs to go
out to about 200 vendors daily, so seperate reports coded
for each vendor would be impossible. Is there anyway to
automate this process?

 

[Duane Hookom]

Assuming you are using the SendObject method, you could create a recordset
containing all vendors with their email address, primary key field, etc.
Then step through the recordset and
1) modify the where clause of the SQL of the query behind the report
2) send the object.
3) move to the next vendor
I would use DAO to change the SQL. I suppose you could stick the vendor
primary key in an unbound text box and then have the report's query use the
text box in its criteria. I would certainly test this prior to going to
production to make sure the system was in sync ie: the proper report was
going to the proper vendor.