Expression null-value as empty string

BerndL

I try to print the result of a expression as empty string if one value is 0 or null. How can I do it? See attached test.

AlexTZ

Hello,

The correct expression is:

Report.I3] == 0 ? -1 : [Report.I2]/[Report.I3

Even if you set ConvertNulls to false, the conversion is always performed in an expression. To check for null or DBNull, you need to use the following method:

Report.GetColumnValueNullable("Report.I3") == null || Report.GetColumnValueNullable("Report.I3") == DBNull.Value

BerndL

Hello,
thanks, I'm understand. But my my question was, how can I return a DBNull-Value or a empty string (not -1 as in my Test) if the result of the expression is not defined so that my appended test works?

AlexTZ

[[Report.I3] == 0 ? null : (object)([Report.I2]/[Report.I3])]

I've converted the result to (object) to make "?" operator working.

BerndL

Thanks much!