Print Page | Close Window

help!

Printed From: Crystal Reports Book
Category: General Information
Forum Name: Talk with the Author
Forum Discription: Ask Brian questions about his books and give him your comments. Like the book? Hate the book? Have suggestions? Let me know!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=16485
Printed Date: 18 May 2024 at 5:49pm


Topic: help!
Posted By: sanchezgmc06
Subject: help!
Date 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??


Replies:
Posted By: hilfy
Date 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


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Print Page | Close Window