Force new page (report)

  • Thread starter Thread starter Wayne-I-M
  • Start date Start date
W

Wayne-I-M

None of the normal (keep together, etc) seem to work with this - obviously
missing something.

I have a report based on a query.
The report shows 16 pictures on each page. (lift pass photos) - 300+ pages.
I have a calclated column in the query based on date of birth
The results are Child - Junior - Adult
I need the report to split so that Child - Junior - Adult have seperate pages
There should be around 30 pages of Child
There should be around 40 pages of Junior
And the rest would be Adult

I have the [PassType] in the header and also in the detail. Normally I
would use the grouping to do this but - not working ??

As an example
John Smith DoB = 04/08/1999 should be the last Junior
John Smith DoB = 04/08/2000 should be the first Child
These 2 should be on a different page (with diffent header) - but they are
just following on - on the same page.

Any suggestions would be helpful.

Thank you.
 
Back
Top