Page 1 of 1

Null values

Posted: Thu Jan 21, 2010 10:55 pm
by 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

Null values

Posted: Fri Jan 22, 2010 2:49 am
by spnvelvet
Tell me what you are typing in condition

Null values

Posted: Fri Jan 22, 2010 3:00 am
by Edward
Hi

Please use the following expression in the Text property:

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

Thank you.