For each record how to add field to bottom of page

Posted on 2009-12-30
Last Modified: 2012-05-08
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!
Question by:ssoutrs
    LVL 100

    Expert Comment

    What reporting system are you using?


    Accepted Solution

    Sorry about the lateness of my response.  I was on vacation.  I am using SQL Server Reporting Services.
    I actually found out how to do this which I will post so others who are looking for a solution will know.  In SQL Server Reporting Services there is not a built in method of accessing data in the footer area.  But you can access individual variables using the following syntax:


    You can also create a custom VB function that sets a value to a variable then access that variable correctly.

    So I basically just used a textbox in my report, set it to hidden, and put the data I wanted to keep track of in the textbox then accessed it using one of the methods above in the footer.  

    Expert Comment

    I will just say for tax purposes, a detailed list of donations such as this is not necessary.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Read about achieving the basic levels of HRIS security in the workplace.
    Shadow IT is coming out of the shadows as more businesses are choosing cloud-based applications. It is now a multi-cloud world for most organizations. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic…
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now