I have to export a pdf by selecting multiple fields values.
I have to loop through 2 fields: CONTRACT and YEAR
Let's suppose :
A 2010, 2011
Please note I don't have a Nprinting Licence, so what I did is : I generated a simple PDF Report in which I copied my objects ( 1 table + 1 bar chart).
I used the report banding option to loop through the multiple values of YEAR and then a small vb script to loop through CONTRACT (see attached files).
The result is : 3 PDF Files (1per contract) with mulitple pages (1 page per year)
What I am looking for is a way to merge all the pdf files into one single PDF, the only way I found to do it for now is manually by clicking on "Wait and Collect" and then combine the PDFs.
PS; I use PDFCreator as printer for the report
Is there any function, VB script or option to do it ?
Thanks a lot 😃 !
Solved! Go to Solution.
Thanks for ur reply !!
Yes, I did it but only for one field.
As I have to loop through two fields, I did a loop using a vb macro to loop through the second field (which generates several pdf files) !
Thanks a lot Neelam, it's exactly what I was looking for
I never knew you can loop through a field in the report page settings !
Thanks again for your help
i wanted to try your solution but the macro module seems to be empty.
Could you please upload it again please?