Conditional crosstab column heading 1

[desperateUser]

I have a table reporting on Bureaus. There are some records where the Bureau column is NULL. I've put the following formula in the column heading on the crosstab. The results show the Bureaus as needed, but where the null values are all I get is a blank cell. Is there something wrong with my formula?

I'm using CR 9.0

if {FARBAccSum;1.Bureau} = "NULL" then "No Bureau" else {FARBAccSum;1.Bureau}

Thanks in advance for any help.

Penelope

 

[lbass]

If they are really null, then the syntax would be:

if isnull({FARBAccSum;1.Bureau}) then
"No Bureau" else
{FARBAccSum;1.Bureau}

If they might be blank or null then use:

if isnull({FARBAccSum;1.Bureau}) or
trim({FARBAccSum;1.Bureau}) = "" then
"No Bureau" else
{FARBAccSum;1.Bureau}

-LB

 

[desperateUser]

lbass - Thank you so much. Works beautifully and now I can move on with my life! You are a huge asset to Tek-tips.

Penelope