Modifying row name in cross tab report

[coderight]

I have created a cross tab report. The database field which is used to display as row has null values . Hence in the report i see some records with row name "NULL". i need to replace that "NULL" to "Blank" . is it possible in Cross tab. If so can you pls guide me.

Thanks

 

[IanWaterman]

Not sure how you are getting NULL as a row label, it must mean that someone has etered "NULL" as text in that field.

To eliminate this just creat a formula based on that field and tell it what to show.

eg

If {Fieldname} = "NULL" then "" else {Fieldname}

If is is truly NULL then use

If isnull({Fieldname}) = "NULL" then "" else {Fieldname}

Both formulae assume that the field is a string.

Ian