Hi,
I have a report that is a contract. I need to schedule it to be sent as a pdf at a certain time. It needs to create a seperate copy for each contract. So for example today there might be 5 contracts. I could easily create it to send 1 email with each contract one after the other in the same pdf. What I would like though is it to send 5 emails each email with a different contract. I've come up with a way by creating 20 report views then have an ascending number in the database. So in the example above each contract for tonight would have a number 1 to 20. Then each report view would look for it's own unique number 1 to 20. This would result in 5 seperate contracts emailed and 15 blank reports. This is messy though. Does anyone know of an easier way?
Did you think about bursting?
No I didn't, but I should have because bursting does exactly what I need.
Thanks.