How can I print out a report by record

[CSCS]

Hi all,

I'm designing this database that contains schools name (with primary key SchoolID) and the name of teachers in each schools (with primary key TeacherID).

I designed a report but it will print out all the schools each with it's teachers, but what I need is to print out each school with it's teacher in a different paper. i.e. print out by school.

any help will be very much appreciated!

Best regard,
CS.

 

[tomj]

Group by SchoolID

If I'm interpreting this correctly, you want to produce a new page everytime the SCHOOLID changes. Add a SCHOOLID header in your report form and in the properties section for the header, under the FORMAT tab, select Force New Page and KEEP TOGETHER as Yes.