Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Count true / false field Post Reply Post New Topic
<< Prev Page  of 2
Author Message
nbritton
Newbie
Newbie
Avatar

Joined: 30 Sep 2009
Online Status: Offline
Posts: 25
Quote nbritton Replybullet Posted: 30 Sep 2009 at 12:13pm
ohh i think i know where your headed with that. Let me give that a try. If i understand. i will summerize the incidentnumber field and elevate on the customeresc field.
IP IP Logged
nbritton
Newbie
Newbie
Avatar

Joined: 30 Sep 2009
Online Status: Offline
Posts: 25
Quote nbritton Replybullet Posted: 30 Sep 2009 at 12:17pm
Ok excellent that did it!!

If you dont mind i would like to pick your brain on one more related item to this. Is there anyway to get that in the Report Header section?
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 30 Sep 2009 at 12:21pm

If you had a 1:1 of row:incidentnumber you can use the other suggestion for creating a formula field to make an "if field=true then 1 else 0" and then SUM that. the SUM can go in a header (unlike a RT).

If not you would need to have a way to count in your source data like creating a stored procedure
or
use a sub report
or
possibly a Graph or Crosstab.
Any of those work for you?


Edited by DBlank - 30 Sep 2009 at 12:21pm
IP IP Logged
nbritton
Newbie
Newbie
Avatar

Joined: 30 Sep 2009
Online Status: Offline
Posts: 25
Quote nbritton Replybullet Posted: 30 Sep 2009 at 12:29pm
That may work. I will work on that. Can you do the if and sum in the same formula or does it require two formulas one call the other to sum it?
IP IP Logged
nbritton
Newbie
Newbie
Avatar

Joined: 30 Sep 2009
Online Status: Offline
Posts: 25
Quote nbritton Replybullet Posted: 30 Sep 2009 at 12:34pm
i don't think it is a 1:1 because it give me the 47 number again, when i do that.

Thanks Again for the help today!!
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 30 Sep 2009 at 12:34pm
One to convert
"TrueCount"
if field=true then 1 else 0
A second to Sum (or use the insert Summary function). I think only formulas that could be created via the Insert Summary can be displayed on headers without messing up the numbers...
 
IP IP Logged
nbritton
Newbie
Newbie
Avatar

Joined: 30 Sep 2009
Online Status: Offline
Posts: 25
Quote nbritton Replybullet Posted: 30 Sep 2009 at 12:36pm
Yep thats what i did with the truecount, and then i used the insert summary and did a sum on the formula. it gave me the 47 again, so its counting the journals.
IP IP Logged
nbritton
Newbie
Newbie
Avatar

Joined: 30 Sep 2009
Online Status: Offline
Posts: 25
Quote nbritton Replybullet Posted: 30 Sep 2009 at 1:29pm
Ok so as a chart works great to show that information though, because you can do a chart with distinct count on incident number.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 30 Sep 2009 at 1:34pm
Yes, if you grouped the chart design on the T/F field then you would be able to use the DC of the inc# to show totals for TRUE and totals for FALSE

Edited by DBlank - 30 Sep 2009 at 1:35pm
IP IP Logged
<< Prev Page  of 2
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.