Print Page | Close Window

how to limit records per page

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=17700
Printed Date: 05 Apr 2025 at 5:38am


Topic: how to limit records per page
Posted By: rajendran
Subject: how to limit records per page
Date Posted: 05 Oct 2012 at 6:55pm
I am using crystal report 8

i extracted 50 records from database to my report.
i want to display
15 records in page1,
10 records in page2,
20 records in page3 and
remaining in last page

i know to display equal number of records in every page. But if i want different number of records in different page then how do i do it. kindly help me.

rajendran


Replies:
Posted By: hilfy
Date Posted: 08 Oct 2012 at 4:04am
Try this:
 
1.  Create a formula that will count the number of records as they print.  I'll call this {@RowCount}.
2.  Go to the Section Expert, click on the formula button to the right of New Page After (DO NOT check the checbox!)
3.  Add something like the following formula:
 
 {@RowCount} in (15, 25, 45)
 
This should give you the page breaks you're looking for.
 
-Dell


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

Posted By: rajendran
Date Posted: 09 Oct 2012 at 8:36pm
{@RowCount} in (15, 25, 45) this code got an error message saying the string need to be closed

so i tried like the below one

{@@RowCount} in "15,10,5"     this code got accepted, but i did not get the desired output.

Can you help me. it is very urgent for me.

Posted By: hilfy
Date Posted: 11 Oct 2012 at 3:40am
Try {@RowCount} in [15, 25, 45]
 
-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