Link to home
Start Free TrialLog in
Avatar of ssoutrs
ssoutrs

asked on

For each record how to add field to bottom of page

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!
contributions-letter.png
Avatar of Mike McCracken
Mike McCracken

What reporting system are you using?

mlmcc
ASKER CERTIFIED SOLUTION
Avatar of ssoutrs
ssoutrs

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I will just say for tax purposes, a detailed list of donations such as this is not necessary.