Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Page Break based on a Fields Condition

Status
Not open for further replies.

cyreports

Programmer
May 12, 2010
89
US
I have a report with two grouping levels.

Group 1 = Data.PaymentType
Group 2 = Data.CreditCardType

Per my clients request, they would like Cash and Check Payment Type on the first page and Credit Cards on a separate page. I am not sure how to do this. I have tried the "New Page Before", "New Page After" and the other options and can't seem to get this to work. Any help is appreciated.
 
Set the New Page Before formula on the Group1 Header to be something like:

{Data.PaymentType} = 'Credit Card'

This should give you a new page before any credit cards.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.
 
Just what are you doing? "New Page Before" on Group Header 2 ought to work.

Have you got 'keep group together' checked? (Right-click on a group setion and select 'Change Group' to check.)

This is based on Crystal 11. It always helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods sometimes change between versions, and higher versions have extra options.


[yinyang] Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP [yinyang]
 
Please disregard. I put the following formula in NEW PAGE BEFORE on group1 and it resolved my issue: {Data.PaymentType} = "Credit Card"
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top