topic Re: Expression to replace a value in ssrs in Report Server

Expression to replace a value in ssrs

M_nwadibia — Mon, 05 Dec 2022 18:38:46 GMT

Please I need an expression to replace 9,999 in column 1 in SSRS. First column is named column1

Re: Expression to replace a value in ssrs

M_nwadibia — Mon, 05 Dec 2022 20:48:26 GMT

The value needed to replace 9999 is "Unknown". I have replaced the value with Unknown in SQL but when I apply filter in SSRS the numbering is not chronological. You can see below it doesnt show 3-9 in the field.

Re: Expression to replace a value in ssrs

d_gosbell — Tue, 06 Dec 2022 00:06:24 GMT

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.