Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: How to put in and/or as a select option? Post Reply Post New Topic
Author Message
jpeel
Newbie
Newbie


Joined: 27 Aug 2014
Online Status: Offline
Posts: 2
Quote jpeel Replybullet Topic: How to put in and/or as a select option?
    Posted: 05 Sep 2014 at 12:40am
We are trying to write a report that has selection criteria where we really need the equivalent of and/or but I can't seem to find how to do that at all?
 
{Part.Product_Grp} = {?Product Group} and
({Part.Stored_Qty} > 0.00 or
{PO_Detail.Del_Complete} = "N" or
{WO.Qty} <> {WO.Cur_Qty})
 
So the first criteria is required but after that we need the records if any of the next 3 are valid but we are struggling to know how to express that....
Cry
 
Please help us if you can - we would be joyful!Smile
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 05 Sep 2014 at 3:48am

Your syntax using the parenth is correct but my guess is that it is not working due to null values or you have not outer joined the tables correctly.

In the formula expert try and set the option about NULLS to 'use default values for nulls'.
IP IP Logged
jpeel
Newbie
Newbie


Joined: 27 Aug 2014
Online Status: Offline
Posts: 2
Quote jpeel Replybullet Posted: 08 Sep 2014 at 12:23am
Thanks for the reply.
 
I've tried the default values for nulls but this doesn't make any difference.
 
I did also try changing the links and they were all 'Left Outer Join' anyway and the enforced join is not enforced?
 
If anyone could help this would be so helpful. It seems such an easy question to pose but it's foxing us! 
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 08 Sep 2014 at 4:16am
To debug this I would create 4 distinct formula, one per condition and then place all 4 formula fields on the detail section so I can see if I am getting the expected results per condtion. Also notyou will need to remove your select formula for this to be of themost value.
What do you see when you do this?
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.016 seconds.