ssrs 2012 - How to give expression for a textbox when multiple fields are used in the textbox of rdlc? -


need display [feature] - [featurestatus] - [featurepercomplete]% if feature field has value or else need display n/a, expreession need give enter image description here

try changing

=iif(fields!feature.value nothing, "n/a",fields!feature.value & " - " & fields!featurestatus.value & " - " & fields!featurepercomplete.value & "%") 

to..

=iif(isnothing(fields!feature.value), "n/a",fields!feature.value & " - " & fields!featurestatus.value & " - " & fields!featurepercomplete.value & "%") 

this relies on feature column being null in circumstances - null, or blank?


Comments

Popular posts from this blog

commonjs - How to write a typescript definition file for a node module that exports a function? -

openid - Okta: Failed to get authorization code through API call -

thorough guide for profiling racket code -