Tuesday, March 12, 2013

Crystal Reports Display Only one Record Per page





Working on Crystal Report is cool!!
Every  thing i write on my blog is actual issues/problems or discovers worked out in real time scenarios.

So

My requirement was to Display 1 record on one page or to Suppressing the blank page .


  1. Open Crystal  Reports -> Blank Report-> Get the data either from BW or excel or any other source.
  2. Drag and drop the required fields onto the page to view the Report.
  3. To view 1 record per page : Go to Section Expert from the menu or right click on the required section.
  4. Section Expert in the Group Footer. select the check box for suppress blank pages & New Page After. 
  5. Beside them we have X+2 formula tab. 
           PageNumber=TotalPageCount

           save and close.

           Now Run the report..

           Every page is displayed with Record No and Record Details.



No comments:

Post a Comment