I have a set of Customer Survey data, the status field tells me if the survey was ignored or responded to, I need the total number of surveys setn and the total responded to.
I have the total sent, but can not figure out how to get the second set.
I tryed a sub report (this gives ne the option of using w where clause) but i do not know how to pass the date perameter from the main report to the sub.
So I am asking for help to see if this can be done using a query statement in the mani report and not using a subreport.
Thanks
RT
1 Answer:
Hi RT,
create a new Variable with the following settings:
Name: MyCounter
Calculation: Nothing
Reset: Report
Increment: None
Variable Expression: ($F{<responded-or-not-boolean-field-value>} == true ? $V{MyCounter} + 1 : $V{MyCounter}
Initial Value: 0
that should do it. Another way of defining the variable would be:
Name: MyCounter
Calculation: Count
Reset: Report
Increment: None
Variable Expression: ($F{<responded-or-not-boolean-field-value>} == true ? 1 : null
Initial Value: 0
This approach uses the fact, that the count-calculation function only count values different from null
Cheers, Thomas
