Report displays all, but I only need most recent
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Tips and Tricks
Forum Discription: Have you learned some great tricks to share with the group? Post them here!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=8044
Printed Date: 03 May 2025 at 8:27pm
Topic: Report displays all, but I only need most recent
Posted By: dlue
Subject: Report displays all, but I only need most recent
Date Posted: 15 Oct 2009 at 8:40pm
I have a report that is displaying more than one result but I only want the last (newest) result to post. I can't seem to write a formula that isn't a custum formula. I'd like to use the Select Expert to display only the records that I want by choosing 1 or 0 but custom formulas do not display in the Select Expert. Any suggestions??
|
Replies:
Posted By: Jyothi Yepuri
Date Posted: 15 Oct 2009 at 9:38pm
|
Post some sample data from database and how you want to display the data in the report
Jyothi |
Posted By: MKnepper
Date Posted: 12 Nov 2009 at 9:45am
|
Did you get an answer on this issue - I have the same problem? ------------- MKnepper |
Posted By: flanman
Date Posted: 18 Dec 2009 at 7:21pm
| I have had to do this several times. What I normally do is create a group and sort the data in asc order. Then do a summary and you can choose the topN record for that field in the group footer. Then move your pertinant fields into the header row and surpress the details row. |
Posted By: AdamField
Date Posted: 04 Jan 2010 at 9:17am
|
you could also use the section expert and do a recordnumber = 1
if you only need the first record
|
Posted By: lockwelle
Date Posted: 19 Jan 2010 at 7:34am
|
or you could depending on where you need the data, just display the group footer...most sorts are from oldest to newest, so the newest record is the last one, and this is the one displayed in the group footer....
Or reverse the sort order and display in the group header, and suppress the details.
|
Posted By: sunnydd
Date Posted: 23 Jan 2010 at 4:21pm
| It depends on what the data looks like when it is returned. It is possible to accomplish this in a variety of ways. I suggest that you post a sample of your data. |