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...............
I have created this blog to place some of important things on it for my personal use and also to help others. Now a days I am doing job as Software Engineer in a company. I have completed my graduation in Computer Science from University of Sindh, Jamshoro, Pakistan.
Subscribe to:
Posts (Atom)
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...
-
Above problem occur when you have not added a group (of which User try to login) in your local policy login. To resolve the issue, follow t...
-
In my case, this error pertains to Oracle Merge query . After 30 minutes of time wastage and a lot of hunting on different forums, I come to...
-
Yesterday, I start SQL Server 2005 and try to connect with sa user but was enable to connect with the 'sa' user and got this error: ...