I have a project where I need to list all the donations from each donor onto one or more pages. The name and address can only appear on the first page and I have that working. The Total gift amount can only appear at the end of the list of donations (weather that is on a single sheet or at the end of multiple pages) that part is not working. Also, I’m bringing back the donations, but it is bringing back all the donations for each record on each record on its own page. I can fit up to (but no more than) 32 lines of data in my “Donations” text box. The maximum lines on one sheet would be 30 separate donations, one space and the Total Gift Amount. If we have 31 or 32 donations the Total Gift Amount would be the only line on the second page. My donations text boxes take care of the amount of data that appears on each page. What I’m trying to do with the rule “ListOfDonations” is make an external copy of my input file and as long as the DonorID field match between the external and the input file, it should bring back the data for that donor. Right now, the pdf never gets created because there is something wrong with my code on the count. It gets to the end of the list and the estimated page count goes to 9300 something. I just have to stop composing at this point. The output should be as follows:
DonorID 1 - 1 page with one gift with total.
DonorID 2 - 2 pages. First page full, second page half full with total.
DonorID 3 - 1 page full with total.
DonorID 4 - 1 page with 5 gifts and total.
DonorID 5 - 2 pages. first page full (32 lines of data) and second page with the Total only.
The pdf should be 7 pages total. I’m attaching a zip of my project. Any help is appreciated.
Thanks,
Rick J.
FusionPro VDP Creator 9.3.36
Adobe Acrobat XI
Mac OS X Yosemite Version 10.10.5 FP_YES_Test.zip