Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Minimum Date from Date Range Post Reply Post New Topic
Author Message
mtapp
Newbie
Newbie


Joined: 10 May 2018
Online Status: Offline
Posts: 1
Quote mtapp Replybullet Topic: Minimum Date from Date Range
    Posted: 15 May 2018 at 1:43am
I have a formula that pulls in data based on the date the event went to a status of 33.(10/01/2017-10/31/2017). However if someone makes a mistake and changes the status twice during the date range I entered it is being picked up twice and doubles the $ amount. Is there a way to only pull the data based on the MINIMUM date from the range?
Current data returned:
Date went to 33     status     name     amount     unique id
10/1/2017     to 33     mmt     $1,000      123
10/15/2017     to 33     mmt     $1,000      123
                       $2,000      
                    
Results wanted:
10/1/2017     to 33     mmt     $1,000      123
                       $1,000      
Thank you
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet Posted: 15 May 2018 at 4:43am
There is a round about way of doing it.  I assume that there is some sort of account number you can group on. If so then you can group on the Date and either in the Group Header or Group Footer (depending how you sort the group) show the 'details' and hide the detail line.  Thus you will only show the minimum date.
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.