Print Page | Close Window

Set limited records in detail section!

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=17312
Printed Date: 06 Apr 2025 at 5:11am


Topic: Set limited records in detail section!
Posted By: atp2K3
Subject: Set limited records in detail section!
Date Posted: 14 Aug 2012 at 4:27am
Hello all,
 
I read the link how to set maximum number of record in detail section in Crystal Report at   http://stackoverflow.com/questions/5483252/how-to-set-maximum-number-of-record-in-detail-section-in-crystal-report - http://stackoverflow.com/questions/5483252/how-to-set-maximum-number-of-record-in-detail-section-in-crystal-report  
 
I applied that code with the index 1, 2, 3, 4, 5 not 1, 3, 4, 5, 6 as posted but I have an issue on paging when the number of records is equal 6. In my Crystal Report, there are two pages: first page contains 6 records and the second blank page is displayed 5 empty blank records. I expect to see one page with 6 records only. How do I can suppress the second page? Thanks in advance.    
 


Replies:
Posted By: hilfy
Date Posted: 14 Aug 2012 at 4:52am
I would set suppress formulas on the sections in the Section Expert.  The formula would look like this:
 
PageNumber > 1
 
-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: atp2K3
Date Posted: 14 Aug 2012 at 7:44am
Hi,
 

I am not always suppressed the second page. Suppose to be 15 actual records in database, there are even having three pages. I only need to supress the blank second page in case of number of actual records is equal 6. Therefore, your suggestion were not working. I also try several other options for suppress under Section Expert but in vain? I really appreciate your expertise on Crystal Report how to work around with my issue. I look forward any inputs soon. Thanks in advance.


Print Page | Close Window