Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: FORMULA BREAKING Post Reply Post New Topic
Author Message
BoltzGirl
Groupie
Groupie
Avatar

Joined: 22 Jan 2013
Online Status: Offline
Posts: 89
Quote BoltzGirl Replybullet Topic: FORMULA BREAKING
    Posted: 16 Jul 2014 at 10:22am

I have a formula that will break as soon as a add back in the commented out section at the very bottom.  Using Crystal XI

{HSD_MEMBER_ELIG_HISTORY.LINE_OF_BUSINESS} like {?LOB} and
{XRPT_AUTH_MASTER_VW.ADMIT_DATE}>={HSD_MEMBER_ELIG_HISTORY.EFFECTIVE_DATE} and
{XRPT_AUTH_MASTER_VW.ADMIT_DATE}<={@TermDate} and
{GROUP_MASTER.GROUP_ID} like {?Health Plan} and
{AUTH_MASTER.STATUS_DATE} in {@Beg date} to {@End date} and
{XRPT_IPA_MASTER_XREF.IPA_PARENT_ID} = {?IPA} and
{AUTH_MASTER.OVERALL_STATUS} ='OP' and
not ({AUTH_MASTER.AUTH_TYPE} in ['DIR','ER','HPC', 'LTC', 'OBS', 'RHB', 'SNF']) and
({AUTH_MASTER.AUTH_TYPE} in ['INJ', 'DME', 'HH'] and
{AUTH_MASTER.DATES_USER_DEFINED_2} in ['INITIAL','MED']) and
not ({AUTH_MASTER.STATUS_USER_DEFINED_2} in ['RECLM', 'RETRO'])
//({AUTH_MASTER.AUTH_TYPE} = "INP" and
//{AUTH_MASTER.SERVICE_ADMIT_TYPE} = "1ELCAD")
 
Any idea what I am doing wrong? Cry
IP IP Logged
kostya1122
Senior Member
Senior Member
Avatar

Joined: 13 Jun 2011
Online Status: Offline
Posts: 475
Quote kostya1122 Replybullet Posted: 16 Jul 2014 at 10:53am
maybe you forgot to add and

{HSD_MEMBER_ELIG_HISTORY.LINE_OF_BUSINESS} like {?LOB} and
{XRPT_AUTH_MASTER_VW.ADMIT_DATE}>={HSD_MEMBER_ELIG_HISTORY.EFFECTIVE_DATE} and
{XRPT_AUTH_MASTER_VW.ADMIT_DATE}<={@TermDate} and
{GROUP_MASTER.GROUP_ID} like {?Health Plan} and
{AUTH_MASTER.STATUS_DATE} in {@Beg date} to {@End date} and
{XRPT_IPA_MASTER_XREF.IPA_PARENT_ID} = {?IPA} and
{AUTH_MASTER.OVERALL_STATUS} ='OP' and
not ({AUTH_MASTER.AUTH_TYPE} in ['DIR','ER','HPC', 'LTC', 'OBS', 'RHB', 'SNF']) and
({AUTH_MASTER.AUTH_TYPE} in ['INJ', 'DME', 'HH'] and
{AUTH_MASTER.DATES_USER_DEFINED_2} in ['INITIAL','MED']) and
not ({AUTH_MASTER.STATUS_USER_DEFINED_2} in ['RECLM', 'RETRO']) and
({AUTH_MASTER.AUTH_TYPE} = "INP" and
{AUTH_MASTER.SERVICE_ADMIT_TYPE} = "1ELCAD")
IP IP Logged
BoltzGirl
Groupie
Groupie
Avatar

Joined: 22 Jan 2013
Online Status: Offline
Posts: 89
Quote BoltzGirl Replybullet Posted: 16 Jul 2014 at 11:05am
LOL.....I just forgot to paste that, but yes I had tried that.  I wish it would have been that easy.... 
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 16 Jul 2014 at 11:36am
I believe you have 2 conflicted statemetns that will never be able to be met at the same time. Likely uoui mena to have an OR between them...?
 
{HSD_MEMBER_ELIG_HISTORY.LINE_OF_BUSINESS} like {?LOB} and...
 'SNF']) and
({AUTH_MASTER.AUTH_TYPE} in ['INJ', 'DME', 'HH'] and
{AUTH_MASTER.DATES_USER_DEFINED_2} in ['INITIAL','MED']) and
not ({AUTH_MASTER.STATUS_USER_DEFINED_2} in ['RECLM', 'RETRO'])
AND
({AUTH_MASTER.AUTH_TYPE} = "INP" and
{AUTH_MASTER.SERVICE_ADMIT_TYPE} = "1ELCAD")
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.027 seconds.