conditional page breaks

[Guest_imported]

Hi,

I want to present all the records of one column of a database table. Let's say that there are 1000 records for this column, I know Crystal report will list all the records and break pages automatically. My question is: In stead of letting Crystal Report to list all the records and break the pages, is that possible that I control where to break the pages. For example, if the record equals to certain value, print from a new page.

Thanks.

Bin Wang
Universal Hi-Tech Development, Inc.

 

[AdamIT]

Yes. Format your Detail section. Click the Formula button next to "New Page Before". Enter a formula such as:

{table.field} = "ABC123"

Anytime the field is equal to ABC123, that record will start on a new page.

 

[kenhamady]

You can use any Boolean expression here. CR will page break whenever that condition is true. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/