How To Put A Footer On The Bottom Of Sets Of Pages In A Report

Hi forum members.


I'm a new SQL Reporting user and could use some guidance.

Here is a simple explanation of my application: imagine a report which prints out a grade report for each of 10 students. Depending on how many notes a teacher makes on the student's individual grade report, each student's report might be 1 or 2 pages long.

To create this report I just used a List report item and laid out a typical grade report and filled in the appropriate fields (name, teacher, etc.) from my dataset query.

When I run the report, it is running great and the students and their grade reports all print out.

The problem I am running into is I want to make sure each student's name is on page 2 if the grade report for that student goes more than 1 page (so pages aren't separated from each other or mixed up). I tried using a Report Footer, but that just put the first student's name at the bottom of every page. I could put a textfield at the bottom the list control but that would just appear at whatever length page 2 ended up being (basically you could have a "footer" at mid-page if the whole list only took up 1.5 pages).

How can I create a footer for each set of pages? Basically this would be a "footer" to the list control itself.

Thanks in advance!
Dave
davehunt00