Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Select expert condition problem Post Reply Post New Topic
Author Message
Gadi
Newbie
Newbie


Joined: 03 Dec 2011
Online Status: Offline
Posts: 4
Quote Gadi Replybullet Topic: Select expert condition problem
     Posted: 23 Oct 2012 at 2:53am
I'm trying to add select conditions to my report.
it's suppose to look like this:

{firms.FIRM_CODE} = 90.00 and
val(left(totext({ACNTS_MNTH_BLNCS.ACNT_CODE}),3))=971 and
{ACNTS_MNTH_BLNCS.CUR_CODE} = 1.00 and
({@REAL_STORNO_STAT} <> X and
month({VU_ACNTS_PRM_TRNS_CRD.EVNT_DATE}) = {@only_month}) and
{acnts.ACNT_STAT} = "Y"

notice the brackets.
when I press ok it removes my brackets so the condition changes.
any ideas why this is happening and how to fix it?
thnks in advance.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 23 Oct 2012 at 3:40am
since all of your parts are AND statements the parenthesis in red are extraneous and that is why they are being removed.
IP IP Logged
Gadi
Newbie
Newbie


Joined: 03 Dec 2011
Online Status: Offline
Posts: 4
Quote Gadi Replybullet Posted: 23 Oct 2012 at 4:58am
right, silly me.
I should have used or.
IP IP Logged
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