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?