Ok, I am trying to create a report that outputs an answer based on a condition of a field for a group. The formula only outputs correctly if the first record of the group matches the condition. I am using CR XI.
It is grouped on a formula with a specified order.
Here are my formulas:
Grouped on this formula called category:
if {Observations.Standard}="1.30.02.02.00.00.00"
or {Observations.Standard}="1.14.01.03.00.00.00"
or {Observations.Standard}="1.24.01.04.00.00.00"
or {Observations.Standard}="1.27.01.01.00.00.00"
or {Observations.Standard}="1.29.01.01.00.00.00"
then "OP" else
if {Observations.Standard}="2.05.01.02.00.00.00"
or {Observations.Standard}="2.08.01.01.00.00.00"
or {Observations.Standard}="2.20.01.01.00.00.00"
then "MS" else
if {Observations.Standard}="3.04.01.04.00.00.00"
then "CP" else
if {Observations.Standard}="5.10.01.02.00.00.00"
or {Observations.Standard}="5.14.01.02.00.00.00"
then "APS"
here is the conditional formula called score:
if field="(SERIOUS)" then True
I have placed
{@score} in the Group Header.
If I leave the condition off this record {Observations.Standard}="1.30.02.02.00.00.00" (meaning the then the whole group will come back False even though the 2nd-5th records match it.
Any help?
Edited by mpaddock - 24 Mar 2010 at 8:22am