Skip to main content

Posts

Showing posts from March, 2009

How to Restrict (Limit) Rows in Crystal Report??

To restrict number of rows in a page on Crystal Report you have to follow these steps:

1) Setup a Running Field from Detail section. Give it name RecCount for the sake of example.

2) Now, goto Section Expert and in Detail Section, click the x+2 button next to the 'New Page After' option and use the formula :

{#RecCount}/10 = int({#RecCount}/10)

that's all.......

Execute your report and see the result.

If later some time you have to change the number of rows then you will simply do it from here by specifying your rows limit requirement.

Enjoy...............