Page 2 of 2

null text box

Posted: Mon Aug 02, 2010 4:25 pm
by Jan
Hello,

Please show me your expression.

Thank you.

null text box

Posted: Wed Aug 04, 2010 4:18 pm
by majidsoft
hi
i change my extension of file in float and my problem is solved but my second question is if my field have null value i want to set symbol for example (-) in that field
thank you

null text box

Posted: Thu Aug 05, 2010 12:08 am
by Alex K.
Hello,

Please use {DataSource["ColumnName"] == DBNull.Value ? "-" : DataSource.ColumnName.ToString()} for displaying Null values.

Thank you.

null text box

Posted: Thu Aug 05, 2010 2:41 am
by majidsoft
hi thanks
my problem solved
bye

null text box

Posted: Thu Aug 05, 2010 2:54 am
by Alex K.
Ok! We are always glad to help you!

null text box

Posted: Sat Aug 14, 2010 3:19 pm
by majidsoft
hi
lok my friend this code you send to me change data type to string and when i was to get max or min or avg i faced a error can you change end of that code change tostring for example to double
thank you

null text box

Posted: Sun Aug 15, 2010 12:31 pm
by Alex K.
Hello,

Code: Select all

{IIF(DataSource["ColumnName"] == DBNull.Value, 0,DataSource["ColumnName"])}
But then for the following conditions:
majidsoft wrote:i change my extension of file in float and my problem is solved but my second question is if my field have null value i want to set symbol for example (-) in that field
you have to add conditions to your further calculations.


Thank you.

null text box

Posted: Mon Aug 16, 2010 1:48 pm
by majidsoft
hi
thats true i change my extension of file and i think its work good but when i want to get avg or max or min i faced an error
now thanks to you my problem solved

null text box

Posted: Mon Aug 16, 2010 2:06 pm
by Andrew
Ok! Have a nice day!