Placing Parens Please (PPP)
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22644
Printed Date: 28 Apr 2024 at 9:16am
Topic: Placing Parens Please (PPP)
Posted By: BoltzGirl
Subject: Placing Parens Please (PPP)
Date Posted: 17 Jul 2018 at 12:27pm
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')
)
-------------
Always appreciate the help!
|
Replies:
Posted By: kevlray
Date Posted: 18 Jul 2018 at 7:46am
|
Just a question, not that it changes anything. Why are you doing a like if you are not using a wildcard?
|
Posted By: BoltzGirl
Date Posted: 18 Jul 2018 at 7:58am
RESOLVED: I was trying to delete my post but it would not let me, but have found my answer and it was not my parens. Thank you!
-------------
Always appreciate the help!
|
|