CODEWITHSUNDEEP
c#visual-studiocrystal-reports
shunilkarki
shunilkarki

Reputation: 85

How to display 20 records on every page of crystal report?

I am new to crystal reports and I need to print 20 rows of data per page. I found this on the web but it is not working on my system.

if Remainder(Recordnumber,20)=0 then true else false

My system only prints a row per page.

Upvotes: 0

Views: 21299

Answers (4)

bendataclear
bendataclear

Reputation: 3850

If you are using Crystal reports 2008/2011 there is a new options in the details section properties in the section expert - 'New page after: X Visible Records':

Example image

Upvotes: 0

user734028
user734028

Reputation: 1111

To make it show 10 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, 10) = 0 then true else false

  1. Click Save and Close and then click OK.

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

Upvotes: 1

Asif
Asif

Reputation: 2677

To show 20 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, 20) = 0 then true else false

  6. Click Save and Close and then click OK.

Upvotes: 1

Richard Morgan
Richard Morgan

Reputation: 7681

Could it be something pedantic as RecordNumber is Recordnumber in your code?

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

Upvotes: 0

Related Questions