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...............

2 comments:

Anonymous said...

how to connect CRviewr in vb

Zeeshan Ahmad Memon said...

Its quite simple. In Visual Studio.NET, inside ToolBox CrystalReportViewer(CRViewer) is placed. Simple Drag it and drop it on form.