SSRS Report Matrix Column Group If Statements


I have a report matix that counts how many referrals our doctors make per month.  I need an iff statement that would allow me to add together our endo-provider and endodontist together as one column.

The reason why I have them separated in my SQL code is because I want the bar chart on the report to graph them separately so that the key stakeholders can have a quick view of the 2

Thank you for all of your help in advance
Who is Participating?
thomasm1948Connect With a Mentor Author Commented:

The colums that calculate the specialties (endo-provider, endontist, etc) is actually one column in one of our tables.  The report matrix seperates them into seperate columns.  

Tried using the calculated field option but I don't know how to add the information together because the Fields!Specialty.Value can have other values within it that the report will automatically create the column for
ValentinoVBI ConsultantCommented:
" I need an iff statement that would allow me to add together our endo-provider and endodontist together as one column."

Sounds to me like you need the + operator instead of an IIF? Unles you've only told us part of the story.

You could add a calculated field to your dataset which represents your endo-provider/endodontist concatenation.  To do that,  right-click the dataset > Add Calculated Field.  Then use the fx button on the empty line at the bottom to enter an expression like:

Fields!endoprovider.Value + Fields!endodontist.Value

(or use an IIF somehow if that's what you need)

You can now use that new field in your matrix.
thomasm1948Author Commented:
I hoping to hide the endo-provider columns and have it added to the endodontist column

Is that possible
thomasm1948Author Commented:

I feel like an idiot on this one.  After thinking about it I figured I always can have two columns in my SQL code.  1 that illistrates the different types of endonotist and the 2nd that just generalizes the endontist as one type).  Now my code shows the correct information in the Chart and Grid

I will keep this one open just in case someone can show me how to do it in reporting services
thomasm1948Author Commented:
I was able to figure it out
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.