Writing Code
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Writing Code
Message Icon Topic: Limiting number of records per page Post Reply Post New Topic
Author Message
WalangAlam
Newbie
Newbie


Joined: 15 Apr 2007
Online Status: Offline
Posts: 2
Quote WalangAlam Replybullet Topic: Limiting number of records per page
    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
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet 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
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.