How To Remove Special Characters In SSRS Report Builder By Writing Some Custom Code

screen

As shown above, in order to remove the special characters, we have to write some custom code in the report Properties.

Click on Report right corner, as shown in the figure, given below:

add

Click Report properties and select code. You will see the screen, given below:

code

Now, copy the custom code, given below, to the blank area.

Custome Code:


code

Now, go the respective field, which needs to remove the special characters.

Expression

Select Expression and write the expression, given below:

In my case: =code.StripID(Fields!AssignedTo.Value)

Save and run the report.

Output

Output

Hope, you liked my blog. Please share this blog and let me know if you have any difficulties.

X

Build smarter apps with Machine Learning, Bots, Cognitive Services - Start free.

Start Learning Now