How to replace NULL values in SSRS with words?

Question

I do not have much experience in SSRS and I've realized that the best way to replace NULL values from a result set (returned to SSRS) is to use this:

=IIF(IsNothing(Fields!MyField.Value),"NA",Fields!MyFields.Value)

But how to apply this exactly? I'm not sure what to do with this line. Thank you in advance for any help!

Check here: http://stackoverflow.com/questions/19234993/ssrs-expression-replace-null-with-another-field-value — Rahul Tripathi, Apr 20 '15 at 18:54
unfortunately that link did not have the answer I was looking for. — LearnByReading, Apr 21 '15 at 17:21

score 4 · Accepted Answer · answered Apr 20 '15 at 19:56

4

Right click on the text box you want the information to appear, click Expression and enter script in the box.

voila.

enter image description here

answered Apr 20 '15 at 19:56

Trubs

If you also VOTE UP the question, it will help others because right now with zero votes it doens't show up in searches.... – LearnByReading Apr 21 '15 at 17:21

score 0 · Answer 2 · answered Apr 20 '15 at 18:51

0

You could use the COALESCE command in your SQL statement.

SELECT COALESCE(MyField,'N/A') AS 'MyField' FROM dbo.clients

answered Apr 20 '15 at 18:51

MAlvarez

Unfortunately, this problem had to be resolved at the SSRS level (as access to code isn't avaiable for this instance) – LearnByReading Apr 21 '15 at 13:01

2 Answers2