Break Page on Data Change 1

[alhamil5]

In the source data for my report, records are grouped, i.e. all sales for sales rep #1 appear as individual rows, then all sales for rep #2, then rep #3, etc. The number of rows per rep will vary each time the report is run, so there could be 5pp of sales for rep #1, one page for rep #2, etc.

I can identify the switch from one rep's records to a different rep's records based on the value of a certain field that appears in every row, i.e., if the field = 1 it's a rep #1 record, if field = 2 it's a rep #2 record, etc.

How can I force a page break each time the value of that field changes so that each rep's recordset begins at the top of a fresh page? Is there some kind of "OnChange" function I can apply, using the identifier field? Thanks!

 

[dgillz]

Format the group section, and clieck thee "new page after" checkbox.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

dgilsdorf@trianglepartners.com

 

[alhamil5]

There are no "groups" in my report. All the relevant data is in the "details" section of the report. The data is coming in from a .csv flat file, in the same order as it is to appear in the report---this is necessary because the sorting requirements are unorthodox. The sort order of the records within each sales rep's data is determined by another system process, it's not a simple alpha or numeric sort, nor is it a sort with any kind of consistency that would allow me to sort the data on the receiving end after reading the flat file.

 

[alhamil5]

Solved my own problem - I selected the "details" section, checked the conditional formatting box for New Page After and for the formula, I entered this:

Next ({rep# field}) <> {rep# field}

Sometimes it's the most obvious solutions that elude me while I'm looking around for something more complicated...