I'm in need of a bit of report layout wisdom.
The pertinent database tables are Donors and Contributions.
The Goal is to print out a report for each donor listing their contributions for a defined date range.
Each donor's report will have a header naming the non-profit doing the reporting (all the same) followed by the name & address of the donee followed by a variable length 2 column section listing donation date, designation of gift, and amount. Occasionally this listing will span 2 pages. The end of the report will have a total of donations for that period and some verbiage.
The issues I'm seeking guidance on are:
1) would you make this a single report grouping on donors, or make the report a "single donor" report and run it once for each donor in the table?
... as a single donor report I can identify a page 2 (if there is one) and change the header to something like "Report for John Doe (cont'd)", but I'm having trouble doing that with running all the donors as a single report.
2) the donation listing section.... Is this where you'd use a subreport? The trouble I've run into is that the second (right-hand) column spans the whole page, rather than starting vertically where the left column began.
THANKS
The pertinent database tables are Donors and Contributions.
The Goal is to print out a report for each donor listing their contributions for a defined date range.
Each donor's report will have a header naming the non-profit doing the reporting (all the same) followed by the name & address of the donee followed by a variable length 2 column section listing donation date, designation of gift, and amount. Occasionally this listing will span 2 pages. The end of the report will have a total of donations for that period and some verbiage.
The issues I'm seeking guidance on are:
1) would you make this a single report grouping on donors, or make the report a "single donor" report and run it once for each donor in the table?
... as a single donor report I can identify a page 2 (if there is one) and change the header to something like "Report for John Doe (cont'd)", but I'm having trouble doing that with running all the donors as a single report.
2) the donation listing section.... Is this where you'd use a subreport? The trouble I've run into is that the second (right-hand) column spans the whole page, rather than starting vertically where the left column began.
THANKS
