Showing posts with label Group of record to display. Show all posts
Showing posts with label Group of record to display. Show all posts

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.