Menu
I need to write an SSRS expression to check and replace NULL field value with another field value. Can this be done?
390
If we are getting the data from a Database, we can use ISNull or COALESCE function to replace Null values with values we would like. But if we want to replace the Null/Blank values in SSRS Report, we need to use IIF and Isnothing functions in expressions.
In SSRS a multi-value parameter cannot include a NULL value, so users can't filter the data for NULL values.
SubTotal. Value) is Null (the IsNothing() function that it is in returns a True if it is Null and a Fales if it isn't), then a zero is returned by the expression; otherwise the SUM(Fields! SubTotal. Value) is used.
How to check if a parameter is NULL in SSRS? The IsNothing() function returns True if the Paramter value is NULL , otherwise it will return FALSE.
=iif(isNothing(Fields!FV1.Value), Fields!FV2.Value, Fields!FV1.Value) If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
