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