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.
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
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...
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.
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
IP Logged
