Talk with the Author
 Crystal Reports Forum : General Information : Talk with the Author
Message Icon Topic: help! Post Reply Post New Topic
Author Message
sanchezgmc06
Senior Member
Senior Member
Avatar

Joined: 21 Jan 2011
Online Status: Offline
Posts: 107
Quote sanchezgmc06 Replybullet Topic: help!
    Posted: 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??
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Quote hilfy Replybullet Posted: 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
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
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



This page was generated in 0.047 seconds.