Print Page | Close Window

Limiting number of records per page

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Writing Code
Forum Discription: .NET programming API, report integration
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=525
Printed Date: 01 May 2025 at 2:41pm


Topic: Limiting number of records per page
Posted By: WalangAlam
Subject: Limiting number of records per page
Date Posted: 15 Apr 2007 at 7:11pm
Am using vs professional 2005, vb.net and sql server express. How do limit the number of record per page.
For example 1 record per page?


-------------
self-taught newbie


Replies:
Posted By: hilfy
Date Posted: 02 May 2007 at 1:38pm
If you want just 1 record per page, group on some identifying info about the record.  For the group footer section turn on New Page After and in the formula button for NewPageAfter put "NoOnLastRecord".
 
If you want another number of records on a page, create the group as indicated above.  Also create a running count of records (I'll call it {#recCount}.  In the New Page After (don't put a check in the checkbox!) formula for the group footer, put something like the following:
 
{#recCount} mod 5 = 0 and NotOnLastRecord
 
This will do a page break for every 5 records - you can change the number as needed.
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Print Page | Close Window