Page break based on value of sort field

  • Thread starter Thread starter T.Yaya
  • Start date Start date
T

T.Yaya

I have an existing report that sorts on OR suite. OR1, OR2, OR3.. etc.
We have added room for procedures, PROC1, PROC2, etc. I was hoping to
modify the existing report (rather than have 2) that would send a page break
when the room name changed from "O" something to "P"something (O*, P*).

Possible?
Thanks, T Ya
 
T.Yaya said:
I have an existing report that sorts on OR suite. OR1, OR2, OR3.. etc.
We have added room for procedures, PROC1, PROC2, etc. I was hoping to
modify the existing report (rather than have 2) that would send a page break
when the room name changed from "O" something to "P"something (O*, P*).
Click to expand...


Use the Sorting and Grouping winsow (View menu) to create a
group on the expression =Left(suite, 1). Select Yes for
the Group Header property.

Add a text box to the new group header section and set its
control source to the same expression. Set the section's
ForceNewPage property to Before Section.
 
Back
Top