Crystal Reports Count true / false field

Technical Questions
Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions

Topic: Count true / false field
	<< Prev Page of 2

Author	Message
nbritton Newbie Joined: 30 Sep 2009 Online Status: Offline Posts: 25	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 Logged

nbritton Newbie Joined: 30 Sep 2009 Online Status: Offline Posts: 25	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 Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	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 Logged

nbritton Newbie Joined: 30 Sep 2009 Online Status: Offline Posts: 25	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 Logged

nbritton Newbie Joined: 30 Sep 2009 Online Status: Offline Posts: 25	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 Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	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... *SUM(*{@TrueCount})
	IP Logged

nbritton Newbie Joined: 30 Sep 2009 Online Status: Offline Posts: 25	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 Logged

nbritton Newbie Joined: 30 Sep 2009 Online Status: Offline Posts: 25	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 Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	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 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.000 seconds.