Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: filtering out old records? Post Reply Post New Topic
Author Message
sandyrivers
Newbie
Newbie


Joined: 14 Mar 2007
Online Status: Offline
Posts: 4
Quote sandyrivers Replybullet Topic: filtering out old records?
    Posted: 14 Mar 2007 at 10:28am
Hi all, first post.
 
I'm a complete newbie when it comes to writing formulas in Crystal 10 and I'm having trouble wrapping my head around a solution to a problem I'm having.
 
I've created a report that displays test score records for an online exam. The report currently shows the Completion Date, Score, and Participant Information each time a user takes the exam, so if someone takes the exam more than once I see a second record with a new completion date and score, as well as the record for the first attempt. What I'd like to do is filter out the old records so that only the most current data is populated.
 
Can anyone give me some guidance on a formula I could write that determines if a person's name or something along those lines shows up again later in the report (it's sorted by date) and then filters out the old record if more current data exists?
 
Thanks for any help!
 
-Sandy
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 14 Mar 2007 at 10:54am
Assuming your inner group is at the Exam Name level....Go to the Sort Expert and add a descending sort on the Completion Date field.  Use the Exam Name group header section(s) for your data, suppress the details and the group footer.  This should give you just the most recent date for the exam.
 
-Dell
Proviti, Data & Analytics Practice
www.protiviti.com/US-en/data-management-advanced-analytics
IP IP Logged
sandyrivers
Newbie
Newbie


Joined: 14 Mar 2007
Online Status: Offline
Posts: 4
Quote sandyrivers Replybullet Posted: 14 Mar 2007 at 11:00am
Hi Dell, thanks for the reply!
 
Right now I've only got one group going that groups by Site Location (I have several branches I report on) and everything else is in the Details section. I'll try adding an inner group and playing around with it like you suggest.
 
Thanks again!
 
-Sandy
IP IP Logged
sandyrivers
Newbie
Newbie


Joined: 14 Mar 2007
Online Status: Offline
Posts: 4
Quote sandyrivers Replybullet Posted: 14 Mar 2007 at 11:07am
Quick reply I know... I tried what you said and I think you may have misunderstood my original post. You solution does give me the most current record for the exam, but it only give me one record. What I need to show is a list of everyone who has completed the exam with their most current score, so that if a person only took the test once it displays the first record and if a person took the test more than once it shows his/her most current record. I guess what I'm saying is that I need the most current record for each person, not for the exam as a whole.
 
Hopefully that makes sense. Again thanks for the response! Hopefully you can help me further!
 
-Sandy
IP IP Logged
sandyrivers
Newbie
Newbie


Joined: 14 Mar 2007
Online Status: Offline
Posts: 4
Quote sandyrivers Replybullet Posted: 14 Mar 2007 at 11:10am
Sorry I tend to type before I think things through.... using your advice I modified it to include the person's name as the group instead of the exam name and I think that's gonna do it.
 
Thanks for your help!
 
-Sandy
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.017 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.