Force a page break
Hi - can someone please tell me how to get this to force a page break after each change in last name.
Code:
«LAST_NAME» «COURSE_NUMBER» «COURSE_TITLE» «COMPLETION_STATUS»«Next Record»
«LAST_NAME» «COURSE_NUMBER» «COURSE_TITLE» «COMPLETION_STATUS»«Next Record»
«LAST_NAME» «COURSE_NUMBER» «COURSE_TITLE» «COMPLETION_STATUS»«Next Record»
«LAST_NAME» «COURSE_NUMBER» «COURSE_TITLE» «COMPLETION_STATUS»«Next Record»
«LAST_NAME» «COURSE_NUMBER» «COURSE_TITLE» «COMPLETION_STATUS»«Next Record»
«LAST_NAME» «COURSE_NUMBER» «COURSE_TITLE» «COMPLETION_STATUS»«Next Record»
«LAST_NAME» «COURSE_NUMBER» «COURSE_TITLE» «COMPLETION_STATUS»«Next Record»
«LAST_NAME» «COURSE_NUMBER» «COURSE_TITLE» «COMPLETION_STATUS»«Next Record»
«LAST_NAME» «COURSE_NUMBER» «COURSE_TITLE» «COMPLETION_STATUS»«Next Record»
«LAST_NAME» «COURSE_NUMBER» «COURSE_TITLE» «COMPLETION_STATUS»«Next Record If»
Page 2 should start with Anton
Results Page 2
ALMAGUER CA-AA494 ASPE100e First Time Adoption (CICA 1500): Canada Not Enrolled
ALMAGUER CA-AA526 ASPE101e Financial Instruments - Recognition, Measurement and Impairment (CICA 3856): Canada Not Enrolled
ALMAGUER CA-AA527 ASPE102e Financial Instruments - Hedging and Derivatives (CICA 3856): Canada Not Enrolled
ALMAGUER CA-AA528 ASPE103e Goodwill and Intangible Assets (CICA 3064): Canada Not Enrolled
ALMAGUER CA-AA529 ASPE104e Stock-based Compensation (CICA 3870): Canada Not Enrolled
ALMAGUER CA-AA530 ASPE105e Employee Future Benefits (CICA 3461): Canada Not Enrolled
ALMAGUER CA-AA531 ASPE106e Asset Retirement Obligations (CICA 3110): Canada Not Enrolled
ALMAGUER CA-AA533 ASPE107e Disclosure under ASPE: Canada Not Enrolled
ALMAGUER CA-AA503 ASPE110 Cdn GAAP to ASPE Transition Workshop: Canada Not Enrolled
ANTONCA-AA494ASPE100e First Time Adoption (CICA 1500): CanadaNot Enrolled
Each page decreases Almaguer by one and adds Anton - I would like all of Almaguer on one page, all of Anton on the next and so on....
I'm using { NEXTIF { MERGEFIELD LAST_NAME } = ''''}
Thanks ~ E
|