crystal report limit records Query

To make it show 5 records per page do the following

1. Open the report in Design View

2. Right click on the Details section and select Section Expert

3. Make sure the Details section is selected in the Section Expert dialog box. Check the box that says “New Page After”

4. Click the formula editor button to the right of the checkbox.

5. Enter the following formula

if Remainder (RecordNumber, 5) = 0 then true else false

6. Click Save and Close and then click OK.

If you run the report it should break after each 5 rows.

 

Comment are closed.

INFORMATION