Thursday, March 12, 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...............

Docker Tutorial

 I have listed all the necessary commands of Docker below. In case if any is missing or if any improvement required, please share in comment...