RECORD SELECTION HELP

[creyes]

IF ISNULL ({MP_INPAR6_VIEW.RECV_ALL_G})=TRUE THEN "NONE RECOVERED"
ELSE IF {MP_INPAR6_VIEW.RECV_ALL_G}="N" THEN "PART RECOVERED"
ELSE IF {MP_INPAR6_VIEW.RECV_ALL_G}= "Y" THEN


//PLEASE FINISH THIS FOR ME - I DON'T WANT ANY OF THE Y'S APPEARING ON THE REPORT AT ALL.
//THE FIELD CONTAINS ONLY Y AND N, AND I USED THE ABOVE FORMULA FOR THE NULL INFORMATION
//WHEN I USE THE RECORD SELECTION TO FILTER OUT THE Y, THEN IT ALSO FILTERS OUT THE NULL FIELDS
//AND ALL I GET IS THE N INFORMATION

 

[synapsevampire]

This doesn't look lie a record selection formula, it looks like a formula.

If you want all rows except those that have "Y", then use the following in the record selection formula (Report->Edit Selection Formula->Record):

{MP_INPAR6_VIEW.RECV_ALL_G} <> &quot;Y&quot;

-k

 

[creyes]

THANKS FOR YOUR PROMPT REPLY!

I TRIED THIS:

{MP_INPAR6_VIEW.RECV_ALL_G} <> &quot;Y&quot; and

{MP_INPAR6_VIEW.INVOLVEMENT_G} = &quot;STN&quot; and
{MP_INMAST_VIEW.REPORTED_DATE_G} = {?Date Range} and
{MP_INPAR6_VIEW.UCR_TYPE_G} = {?UCR Property Code}

(ALSO TRIED IT AT THE BOTTOM) AND IT STILL FILTERS OUT THE NULL FIELDS.

 

[lbass]

What is the relationship among fields in MP_INPAR6_VIEW? If all the other fields in the select statement from MP_INPAR5_VIEW are populated even when {RECV_ALL_G} is null, then try:

(isnull({MP_INPAR6_VIEW.RECV_ALL_G}) or
{MP_INPAR6_VIEW.RECV_ALL_G} <> &quot;Y&quot and
{MP_INPAR6_VIEW.INVOLVEMENT_G} = &quot;STN&quot; and
{MP_INMAST_VIEW.REPORTED_DATE_G} = {?Date Range} and
{MP_INPAR6_VIEW.UCR_TYPE_G} = {?UCR Property Code}

How do you have these two tables joined? On what field? I think you'll need a left join from MP_INPAR6_VIEW -> MP_INMAST_VIEW to allow for no date range if {RECV_ALL_G) is null.

-LB