Print Page | Close Window

Help with Select Expert

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=7012
Printed Date: 29 Apr 2024 at 7:36pm


Topic: Help with Select Expert
Posted By: peggall
Subject: Help with Select Expert
Date Posted: 10 Jul 2009 at 8:22am
I have created two fields, one is @unit which is the first two positions of another field from the DB and the other is @unack which is = to Unacknowledge if = blanks and blanks if valued. I have verified that both fields contain what I want them to.
 
My problem is when using the Select Expert. I start the formula with @unit <> "  " and I test and get what I want. Then I add to the formual with and @unack = "Unacknowledge" and I get nothing, which I have already verified I should have data.
 
Any help will be greatly appreciated.


Replies:
Posted By: DBlank
Date Posted: 10 Jul 2009 at 12:03pm
I am not sure what your data is so do you need this to be an AND statement or an OR statement.
Try just using @unack = "Unacknowledge" to see if that works by itself.
If is does then the AND is the part that is messing your query up because no rows have both conditions.
 


Print Page | Close Window