Sorting/Blank Fields Issue

[wanzek]

I have a report that is sorting by the following formula:
If {EMCM.udFleet}='Y'
then 'Category: '&{EMCM.Category}&' '&{EMCM.Description}
Else
""

What I am trying to accomplish is if the Category of Equipment has a Yes checked for fleet then to include the category else print nothing. However, something is wrong with my formula because I am getting a row at the top of my report of a category that is printing but does not have a yes checked for fleet. Any ideas?

Thanks

 

[lbass]

You are seeing the default "". Why not use the criterion in your selection statement?

{EMCM.udFleet}='Y'

Otherwise, consider sorting in descending order and also check "suppress blank section" in the section expert->detail section. Or still in the section expert->suppress->x+2:

isnull({EMCM.udFleet}) or
{EMCM.udFleet} <> "Y"

-LB