Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Help with Select Expert Post Reply Post New Topic
Author Message
peggall
Newbie
Newbie


Joined: 17 Jun 2009
Online Status: Offline
Posts: 5
Quote peggall Replybullet Topic: Help with Select Expert
    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.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet 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.
 
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.031 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.