Skip to Content
0
Former Member
Jun 08, 2009 at 02:39 PM

Or statement not working in record selection formula

26 Views

My report is to bring out all cases where any of a list of fields is null.

In all cases the following parameters apply:

{?Start} <= {NVAPR.StartDate} and

{NVCasCat.Code}<>"C" and

{NVApNoTy.Code}in ["AP","EPS","EWCL","FLYT","PC","PWS"] and

{NVAPR.CaseType}<> (132) and

isnull ({NVAPR.SignOffDate})

This works fine.

I then need to add the following variables and this is where Iu2019m having trouble

isnull ({NVTresOf.Description}) or

isnull ({NVAPR.EnquiryType}) or

isnull ({NVCasCat.Code})

u2026u2026u2026

If I code it like this I still get all of the records the first variables bring out.

{?Start} <= {NVAPR.StartDate} and

{NVCasCat.Code}<>"C" and

{NVApNoTy.Code}in ["AP","EPS","EWCL","FLYT","PC","PWS"] and

{NVAPR.CaseType}<> (132) and

isnull ({NVAPR.SignOffDate})

or

//2

{?Start} <= {NVAPR.StartDate} and

{NVCasCat.Code}<>"C" and

{NVApNoTy.Code}in ["AP","EPS","EWCL","FLYT","PC","PWS"] and

{NVAPR.CaseType}<> (132) and

isnull ({NVAPR.SignOffDate}) and

isnull ({NVTresOf.Description})

//3

or

{?Start} <= {NVAPR.StartDate} and

{NVCasCat.Code}<>"C" and

{NVApNoTy.Code}in ["AP","EPS","EWCL","FLYT","PC","PWS"] and

{NVAPR.CaseType}<> (132) and

isnull ({NVAPR.SignOffDate})and

isnull ({NVAPR.EnquiryType})

or

{?Start} <= {NVAPR.StartDate} and

{NVCasCat.Code}<>"C" and

{NVApNoTy.Code}in ["AP","EPS","EWCL","FLYT","PC","PWS"] and

{NVAPR.CaseType}<> (132) and

isnull ({NVAPR.SignOffDate}) and

isnull ({NVCasCat.Code})

Iu2019ve also tried to use the following with the same results.

Always use this editor

Always use this editor

Always use this editor

  • Plain Text

  • Preview

Please Wait ...

Click for bold Click for italics Click for underline Click to display text as code Click to insert a link Spell Check

Please enter a URL.

URL -- example: http://mysite.com/ Link Text(optional) -- example: My Site

My report is to bring out all cases where any of a list of fields is null.

In all cases the following parameters apply:

{?Start} <= {NVAPR.StartDate} and

{NVCasCat.Code}<>"C" and

{NVApNoTy.Code}in \"AP\",\"EPS\",\"EWCL\",\"FLYT\",\"PC\",\"PWS\" and

{NVAPR.CaseType} (132) and

isnull ({NVAPR.SignOffDate})

This works fine.

I then need to add the following variables and this is where Iu2019m having trouble

isnull ({NVTresOf.Description}) or

isnull ({NVAPR.EnquiryType}) or

isnull ({NVCasCat.Code})

u2026u2026u2026

If I code it like this I still get all of the records the first variables bring out.

{?Start} <= {NVAPR.StartDate} and

{NVCasCat.Code}<>"C" and

{NVApNoTy.Code}in \"AP\",\"EPS\",\"EWCL\",\"FLYT\",\"PC\",\"PWS\" and

{NVAPR.CaseType} (132) and

isnull ({NVAPR.SignOffDate})

or

//2

{?Start} <= {NVAPR.StartDate} and

{NVCasCat.Code}<>"C" and

{NVApNoTy.Code}in \"AP\",\"EPS\",\"EWCL\",\"FLYT\",\"PC\",\"PWS\" and

{NVAPR.CaseType} (132) and

isnull ({NVAPR.SignOffDate}) and

isnull ({NVTresOf.Description})

//3

or

{?Start} <= {NVAPR.StartDate} and

{NVCasCat.Code}<>"C" and

{NVApNoTy.Code}in \"AP\",\"EPS\",\"EWCL\",\"FLYT\",\"PC\",\"PWS\" and

{NVAPR.CaseType} (132) and

isnull ({NVAPR.SignOffDate})and

isnull ({NVAPR.EnquiryType})

or

{?Start} <= {NVAPR.StartDate} and

{NVCasCat.Code}<>"C" and

{NVApNoTy.Code}in \"AP\",\"EPS\",\"EWCL\",\"FLYT\",\"PC\",\"PWS\" and

{NVAPR.CaseType} (132) and

isnull ({NVAPR.SignOffDate}) and

isnull ({NVCasCat.Code})

Iu2019ve also tried to use the following with the same results.

{?Start} <= {NVAPR.StartDate} and

{NVCasCat.Code}<>"C" and

{NVApNoTy.Code}in ["AP","EPS","EWCL","FLYT","PC","PWS"] and

{NVAPR.CaseType}<> (132) and

isnull ({NVAPR.SignOffDate})

and

isnull ({NVTresOf.Description})or isnull ({NVAPR.EnquiryType})or isnull(({NVCasCat.Code})

-

Draft saved at 4:37 PM