This is my selection criteria on a new report and I obviously have my parens in the wrong place for the ending OR statements as the report is only pulling the first line that is 'CHG REFERRAL TYPE: OBS TO INP'. It's not picking up the last 2 lines of the stmt.
{AUTHS.IPACD} = {?IPA} and
{AUTHS.GRPID} like {?HealthPlan} and
{AUTHS.ReferralType} like {?AuthType} and
{AUTHS.PLNTP} like {?LOB} and
{AUTHS.Status} = "Approved" and
{AUTHS.DecisionDateTime} in {?BegDate}to {?EndDate} and
(
({AuthStatusChangeLog.CHGFNC} like 'CHG REFERRAL TYPE: OBS TO INP')
or
({AuthStatusChangeLog.CHGFNC} like 'CHG REFERRAL TYPE: OPT TO INP')
or
({AuthStatusChangeLog.CHGFNC} like 'CHG REFERRAL TYPE: OPT TO OBS')
)
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