I have what I thought was a simple record selection for my Crystal Report (using 2013 Support Pack 7, v 14.1.7.1853) and I just cannot get one of the lines to work.

I am trying to pull in all records that have the following:

{ATS.GR} like {?HthPl} and
{ATS.PL} like {?PLTYP} and
{ATS.DecDateTime} in {@Beg Date}to {@End Date} and
{ATS.IPA} = {?IPA} and
{ATS.RefType} = "HH" and
{ATS.Stat} = "Approved" and
{V_SupplementalDataServiceType.ServiceType} in ['INITIAL','MED'] and
Not ({AuthStatusChangeLog.CHGFNC} like '*ADHOCLTR*')

The last line is the one not working. It is pulling in records that still have a line in the 'StatChgLog' that have the word ADHOCLTR.

There are multiple lines per record in this StatChgLog and I am trying to only pull the records that 'do not' have any line that has this ADHOCLTR context in any of the lines.

Any ideas as to why?



Edited by BoltzGirl - 06 Jun 2017 at 6:07am

I am looking at a group of records and yes, wanting to exclude any of the rows in that group that have ADHOCLTR in it. For some reason, it's not working and it's including records that have ADHOCLTR. So weird....cannot figure it out.

look to see if you have any spaces between any of the letters.
Try a simple formula field fro testing
{AuthStatusChangeLog.CHGFNC} like '*ADHOCLTR*'
Place it on the detail row and see if you get True/False as expected.
Use it to tweak until you figure out what is going on with that field.