Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Retrieve Min of Time Post Reply Post New Topic
Author Message
crstar
Newbie
Newbie


Joined: 02 Aug 2012
Online Status: Offline
Posts: 31
Quote crstar Replybullet Topic: Retrieve Min of Time
     Posted: 11 Sep 2012 at 10:12pm
Dear all,
 
I have a report with Grouping by DocNo, under each grouping, there is a list of data, one of the data is Time. Eg:
 
DocNo: 0001
Time
08:03
08:05
 
I would like to retrieve the min of time, means 08:03 to show at the group header.
 
I use Running Total Field,
Field to summarize: Time
Evaluate: On Change of Group - DocNo
Reset: On Change of Group - DocNo
 
But I unable get the valid minimum time at group header.. any error on my analysis?
 
Thanks.
 
 
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 12 Sep 2012 at 1:19am
Running totals do not work in headers.
Use the summary function instead
minimum(time,docno)
IP IP Logged
crstar
Newbie
Newbie


Joined: 02 Aug 2012
Online Status: Offline
Posts: 31
Quote crstar Replybullet Posted: 12 Sep 2012 at 1:59pm
Thanks... :) i use the group formula minimum(time,docno)  is work
IP IP Logged
crstar
Newbie
Newbie


Joined: 02 Aug 2012
Online Status: Offline
Posts: 31
Quote crstar Replybullet Posted: 12 Sep 2012 at 3:53pm
i use this formula, but after that while i use this value (the min value) to do calculation, it prompt error "A running total cannot refer to a print time formula".. any idea on this..? 

Edited by crstar - 12 Sep 2012 at 3:54pm
IP IP Logged
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