Forum Discussion
M_nwadibia
Resolver III
Resolver IIIExpression to replace a value in ssrs
Please I need an expression to replace 9,999 in column 1 in SSRS. First column is named column1
This is possible to do. You just need to right click on the field in your tablix control and then change the expression from something like:
=Fields!ID.Value
to something like this:
=iif(Fields!ID.Value=9999,"Unknown",Fields!ID.Value)
This is using an example column called "ID" you would need to change this based on the field name in your dataset.
d_gosbell
Super User
Super UserThis is possible to do. You just need to right click on the field in your tablix control and then change the expression from something like:
=Fields!ID.Value
to something like this:
=iif(Fields!ID.Value=9999,"Unknown",Fields!ID.Value)
This is using an example column called "ID" you would need to change this based on the field name in your dataset.