Print Page | Close Window

Top N most recent

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
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=13772
Printed Date: 07 May 2024 at 12:46pm


Topic: Top N most recent
Posted By: bigdummy76
Subject: Top N most recent
Date Posted: 16 Jul 2011 at 3:21am
I have a report created with a date range input parameter. The date range is used by sub-reports which may or may not include all records within the date range. To limit the size of certain sub-reports within that date range I want to pull only the N most recent records.
 
Input date range is 1/1/2011 to 6/30/2011. For sub-report X I want to include only the 10 most recent dates.


Replies:
Posted By: sharona
Date Posted: 19 Jul 2011 at 5:01am
you can create a top n sort report but the easiest way might be to create a conditional supression.
create a formula for record count
then surpress the subreport records based upon the count


-------------
sharona


Print Page | Close Window