We help IT Professionals succeed at work.

Crystal Reports - Formula to find a certain value

jnikodym
jnikodym asked
on
1,607 Views
Last Modified: 2014-08-13
I need to search through a data column to see if a specific value exists.  If it does i need my formula to display true.  If the value does not exist i need it to display false.  I want to display this in my Page Header.
Comment
Watch Question

Senior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
I'm trying to determine if that value exists once the report has run with the parameter selected.  I don't have the value in my report.  So, say there is a column in my dataset called City.  I won't to search all the values in that column and determine if the  city St. Louis exists in the column.  If it does, return true, if not, return false.
Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013

Commented:
That pair of formulas will do what you want.  

Did you try it?

mlmcc

Author

Commented:
that works, thank you
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.