Joined: 03 Dec 2011
Online Status: Offline
Posts: 4
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.
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