If you drop the field on the canvas and it is displaying as True /Flase and not a 1/0 then it is boolean (t/f) and not numeric.
For the Running Total try this:
name = TrueCount (or whatever)
Field to Summarize= {Incident.CustomerEscalation}
Evaluate = Use a formula as {Incident.CustomerEscalation} ... You do not really need the TRUE part assuming it is boolean (t/f) but you can use it, it won't hurt
Reset = either
a. NEVER if you have no group an you want a toal for the report
or
b. On change of Group and select the group you want to start back on.
Place the RT in either the Report Footer (if for all records) or the group Footer (if per group reset).
They don't work in Headers and it sounds like that is where you put it. If you drop it on a header it only reads the first record (your 1 or 0 instead of 3).
Does that fix it?
Edited by DBlank - 30 Sep 2009 at 10:13am
IP Logged
