Section Expert, Suppress, working opposite? 1

[loveyoursite]

CRV10 I have a report with a Review.Rating string field which contains either a blank or 6 ratings. I only want to see the records with a blank rating or a rating of 02 or a rating of 06. I could not get the select criteria to work as it would only bring back the 02 and 06 but not the blanks.

Then I tried to use a Detail, Suppress Formula of
{REVIEW.RATING} <> "02" and
{REVIEW.RATING} <> "06" and
{REVIEW.RATING} <> ""
it only brought back the 02 and 06's. If I leave the suppress formula in the report but deselect the box beside "Suppress" then the report brings back what I want.
Does anyone by any chance know why?

Thanks!

 

[lbass]

First check your report options (file->report options) and make sure you do not have "convert nulls to default values" checked. Then try a record selection formula like:

isnull({Review.Rating}) or
trim({Review.Rating}) = "" or
{Review.Rating} in ["02","06"]

-LB

 

[loveyoursite]

Thanks so much for your response! I did not have convert nulls to default values checked in the report options. I tried your formula and it brought back every record and the rating field result was either true or false. How do I get the rating of blank, 02 or 06 to show in the result and no other results?

 

[lbass]

The formula belongs in the record selection formula area. Go to report->selection formula->RECORD and enter it there.

-LB

 

[loveyoursite]

Thanks so much, that worked!