How to select two columns and display in a single column, if either of them is null, in SSRS report?

Question

0.00/5 (No votes)

See more:

Hi,

Is there any expression for selecting two columns and display it in a single column of report, if either of them is null?.

For example: In SQL I can use coalesce:

coalesce(column1,column2) -- which selects column1 when column2 is null and vice versa.

Is there any alternative for this, in SSRS, where I can select either column1 or column2 and display in a single field of my report ??

Please help.

Thanks,
DhivyaJ

Posted 14-Apr-13 21:35pm

Dhivya.J

Updated 15-Apr-13 20:03pm

v5

Add a Solution

Comments

ZurdoDev 15-Apr-13 10:00am

Can't you just do it in SQL?

Maciej Los 16-Apr-13 2:14am

Good question! My virtual 5.

Dhivya.J 15-Apr-13 23:30pm

Hi. I know this is possible in SQL and i want this to be handled in my report only.

Maciej Los 16-Apr-13 2:14am

Why to torture yourself?

Dhivya.J 16-Apr-13 2:24am

Hi Los. I am not torturing myself and right now I dont have rights to do this in SQL. That is why i wanna handle it in report.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

babu saravanan · Answer 1 · 2013-04-15T20:10:00

Try this:
right click the tablix column and select Expression.

C#

=Fields!FirstName.Value & IIF(Fields!FirstName.Value = "", "", "; ") &
 Fields!MidName.Value & IIF(Fields!MidName.Value = "", "", "; ") &
 Fields!LastName.Value & IIF( Fields!LastName.Value = "", "", "; ") &

to check is null or empty:

C#

IIF(Fields!NursingActionsClose.Value="","ifNulltakeThisPart","ifNOtNullTakeThisPart")