Null values

[Praveen]

Hi Friends

I am fetching a column from a database table which has null values also.
when i am showing it in a report it shows blank space instead of null.
now i want to replace all blank spaces in the report with a string and all the notnull values with another string.

Please help when i am using a condition string i am getting only not null values.

Regards
Praveen

[spnvelvet]

Tell me what you are typing in condition

[Edward]

Hi

Please use the following expression in the Text property:

{datasource["columnname"] == DBNull.Value ? "empty" : datasource.columnname.ToString() }

Thank you.