Set visible record in detail section in crystal report

Question

Hello friends I have use crystal report in my asp.net application. I have set visible record to 5 in my detail section. but when in detail section having only 5 record so 5th record remains on same page and next page is show blank. So I want to count total no of record in detail section and write logic if totalcount>5 set visible record = totalcount+1 by programatically.Please help me. Regards Ajay

Saineshwar Bageri · Answer

To make it show 5 records per page do the following Open the report in Design View Right click on the Details section and select Section Expert Make sure the Details section is selected in the Section Expert dialog box. Check the box that says New Page After Click the formula editor button to the right of the checkbox. Enter the following formula if Remainder (RecordNumber 5) = 0 then true else false Click Save and Close and then click OK. If you run the report it should break after each 5 rows.