Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: group conditions in count function Post Reply Post New Topic
Author Message
rftd
Newbie
Newbie


Joined: 09 Jun 2008
Online Status: Offline
Posts: 24
Quote rftd Replybullet Topic: group conditions in count function
    Posted: 11 Jun 2009 at 2:42pm

Hi,

Im using the count function and im trying to group by time. Based on the crystal reports help, the format should be Count(fld, condfld, cond)
 
So, following this format, I created a formula field where I inputed:
 
count(some_field, start_time, 'for each minute')
 
However, when I do this, I am informed that "This group condition is not known". This comes as a surprise because the crystal reports documentation says that 'for each minute' is correct.
 
So, my question is this: how do I do the above count and group by minute?
 
Thanks in advance.
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 12 Jun 2009 at 7:15am
do you have a grouping that is based on start_time?  the aggregate functions are based on a group, or if you leave it off, on all records, though I don't know how you would do this with the cond.
 
HTH
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 12 Jun 2009 at 7:34am
try:
Count ({table.field}, {table.timefield}, "by minute")
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.