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.


Difference Between Apache Common Logging and Log4J

Dear Folks, Log4j is a logging framework, i.e. it provides the code to log messages while Commons-logging is an abstraction layer for log...