Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Record with too many results Post Reply Post New Topic
Author Message
stratos
Newbie
Newbie


Joined: 22 Mar 2010
Location: United States
Online Status: Offline
Posts: 3
Quote stratos Replybullet Topic: Record with too many results
    Posted: 05 Nov 2010 at 8:39am
I'm running a report against a scheduling program.

I am returning all results for a days appointments, with a status of confirmed. The application allows the user to confirm the appt. multiple times. Everytime they confirm the appointment it creates another record in the database for the same status code.

How can I formulate the report to return only the latest of the two confirmed status records. Where status is equeal to "C". I need to use a max function but not sure how?? Please Help Thanks...


M     HHWY      9:00 am 9/7/2010 4:59:54PM "C"
M     HHWY      9:00 am 9/8/2010 12:37:50PM "C"


Edited by stratos - 05 Nov 2010 at 10:33am
IP IP Logged
SunnyA84
Newbie
Newbie
Avatar

Joined: 05 Nov 2010
Online Status: Offline
Posts: 5
Quote SunnyA84 Replybullet Posted: 05 Nov 2010 at 10:58am

Hi

the formula is :
{Date.field} = Maximum ({Date.field},{field.name}).
 
note : "{field.name}" here is either M or HHWY whichever you want to group it by.
 
you first need to make a group on either M or HHWY and then put the formula in the Group selection.


Edited by SunnyA84 - 05 Nov 2010 at 10:59am
Sunny
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.031 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.