Cdudej said:
Hello
At the moment i have a multipage crystal report and i have a method
for emailing pdf files. Now the problem comes in because each page of
that crystal report needs to go to a different customer. Is this
possible.
Thanks in advance
You can't split bits out a pdf and email them, ain't gonna happen.
You want to run the report per customer.
Personally, I tend to extract a datatable and present that to the crystal
report.
That means my Crystal reports are easier - I manipulate my data in stored
procedures or SQL which is a way I understand well.
I would maybe add some customer id parameter to my extract code and loop for
all (qualifying) customers.
Spit out a pdf... email... next.
Maybe extract the dataset then filter on each customer, depending on how
much work your extract does.
If you do your report data access within crystal then you'd need to add a
customer parameter or switch data sources in code.
This used to be the best forum for crystal last time I was using it in
anger:
http://www.crystalreportsbook.com/forum/default.asp
I know there is code there that does the datatable substitution thing,
because I posted it.
3 years or so back now though.
