Ok, I am building a report for a church that serves as a financial donations letter that can be sent to the individual at the end of the year for tax purposes. The basic report structure is this:
The outer portion of the report is a list which is grouped by MemberID. So for each member the letter is displayed for that member showing that member's contribution for the current year. In group properties I added a page break between each instance of the group.
Inside of the List I have the letter body which includes a table showing the financial contributions of the individual.
Well the person I am doing the report for wants the individual's name to show along the bottom of each page. So if there are two pages in the letter for one individual there should be that individual's name on the bottom right of both pages. For the next person there should be that person's name at the bottom right of the page.
A footer doesn't seem to work because that is not bound to a dataset so you only are able to use aggregate functions such as First(name).
I can't seem to include a text box below the contributions table either because it will only print the name at the bottom of the table, not at the bottom of the page.
Does anyone have a nifty solution for this? I will upload a picture of what the current report looks like:
Thanks a lot!