Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Issue with "DistinctCount" formula Post Reply Post New Topic
<< Prev  Page  of 2
Author Message
steinertractor
Newbie
Newbie
Avatar

Joined: 27 Dec 2010
Location: United States
Online Status: Offline
Posts: 6
Quote steinertractor Replybullet Posted: 22 Sep 2011 at 9:47am
DistinctCount (fld, condFld, cond)
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 22 Sep 2011 at 10:46am
I have never gotten the "cond" syntax for a boolean to work, only date/time fields.
The below is from crystal help...

Here is a list of the conditions for each summary function:

Boolean conditions

  • on any change
  • on change to yes
  • on change to no
  • on every yes
  • on every no
  • on next is yes
  • on next is no

Date conditions

  • for each day
  • for each week
  • for each two weeks
  • for each half month
  • for each month
  • for each quarter
  • for each half year
  • for each year

Time conditions

  • for each second
  • for each minute
  • for each hour
  • for AM/PM

 


Edited by DBlank - 22 Sep 2011 at 10:46am
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 22 Sep 2011 at 10:48am

however, imo, using the RT or variable formula is an easier and much more flexible solution for conditional summarizations of data.



Edited by DBlank - 22 Sep 2011 at 10:49am
IP IP Logged
steinertractor
Newbie
Newbie
Avatar

Joined: 27 Dec 2010
Location: United States
Online Status: Offline
Posts: 6
Quote steinertractor Replybullet Posted: 22 Sep 2011 at 10:51am
I never could actually get it to work either. The Running Total method ended up working perfectly for me and since these postings I've used it in several other scenarios as well. According to the documentation it *should* work, but I haven't been able to figure it out.
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Quote lockwelle Replybullet Posted: 23 Sep 2011 at 3:25am
alas, you know me... I try to get it done in the stored proc or I use variable formulas (never quite got the hang of running totals...you would have thought it would be a natural)
IP IP Logged
<< Prev  Page  of 2
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