How to Insert page break after certain rows?

[JYOUSAF]

How to display certain rows on new page in crystal 2011.  

1. In Section Expert -> Details - > Paging  à New Page Before 

I have this formula but its not working

If Remainder(Recordnumber, 14)=0  then true else false

Any insights?

1. Thanks.

[former_member203168 · Accepted solution]

Hi Ramil,

To make it show 14 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.
4. Check the box that says “New Page After”

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

6. Enter the following formula
7. if Remainder (RecordNumber, 14) = 0 then true else false

8. Click Save and Close and then click OK.

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

--Praveen G

[JYOUSAF · Accepted solution]

Praveen thanks for your reply!

There is no checkbox next to 'New Page After'.  Rather it has two options i.end of section and ii. Visible records.

I clicked on visible records and in x-2 formula editor typed the formula but getting the following error

"A constant expression is required here"

[Former Member · Accepted solution]

Hi Ramij,

Just do this.It will show 14 records per page.

[former_member203168 · Accepted solution]

HI,

Check the check box in New Page After  > Visible Records.

in the visible box enter 14, then Click on OK

--Praveen G

[JYOUSAF · Accepted solution]

how about multiple page breaks after 14 and 21 rows?

[Former Member · Accepted solution]

Hi What you meant by multiple page breaks.You want to show 14 rows in 1st page and 21 rows in next page and soon.

Please clarify

[JYOUSAF · Accepted solution]

need a page break after line 14 and 21.

[Former Member · Accepted solution]

Hi

Try this

Goto paging tab->New page after-> end of section->x-2 .

Then write this

if pagenumber=1 and recordNumber=14 then true

else if  pagenumber=2 and RecordNumber=21 then true

this also working

if pagenumber=1 and Remainder(recordnumber,14)=0 then true

else if  pagenumber=2 and Remainder(recordnumber,21)=0 then true