Posted By: sanchezgmc06 — 18 May 2012 at 8:19am
I have a simple report in which i need crystal rpt to evaluate if any of the field values are 2 or 3 then leave then show the row
my report is grouped by clientid
to display the most recent assessment i moved all my fields to the group footer
my fields (70 of them) display a value of 0,1,2,or 3
what i need to do is display any client that has any of those fields answered with a 2 or 3
i tried the select expert i selected each field and said is one of 2 or 3 but that did not work because it will only give me all the clients whom have 2 or 3 only in all fields
suggestions??
Posted By: hilfy — 25 May 2012 at 6:46am
In the Select Expert, you'll need to edit the formula to use "OR" instead of "AND". If you have any other criteria in addition to the 70 fields, you'll also need to put parentheses around the total set of "OR" statements. So it will look something like this:
Condition 1 and
Condition 2 and
(Field1 in (2, 3) or
Field2 in (2, 3) or
Field3 in (2, 3) or
...
Field70 in (2, 3))
-Dell
