SSRS Filter Groups

Hi was wondering how to filter groups in reporting services.  I need to filter out a group where column1 contains a D:

Group 1:  this group of rows should not be displayes
5011      
5015      
D5110      
5003      
5011    
5000      

Group 2: this group of rows should be displayed
3400      
9992      
3302

So far my report shows everything.  Thank you for your help in advance
thomasm1948Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
ValentinoVConnect With a Mentor BI ConsultantCommented:
To the participating experts: this is a duplicate question, you may want to refer to the original for more info: http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL_Server_2008/Q_27985272.html
0
 
TempDBACommented:
So, if D comes before any digit, you want to exclude all the numbers that start with that digit?
ITs better you do it from the backend itself while creating your dataset.
0
 
thomasm1948Author Commented:
No I need to remove the whole group.   Attached is a print screen of my current report.  Where group of rows that contain a D-Code in it, I need to remove the whole group.  It is kind of hard to explain but I think the print screen will make more since.

Basically I need to remove the group that contains a D-Code in any one of the rows within in the group
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
thomasm1948Author Commented:
Sorry here is the attachment
Capture.GIF
0
 
Nico BontenbalCommented:
I haven't tested this so I'm not sure it will work.
You could try an expression like this for the hidden property of the group:
=max(iif(left(fields!column1.value) = "D",1,0))=1

Open in new window

0
 
Alpesh PatelAssistant ConsultantCommented:
Just go to Column/Row group property-> visibility


In that Write expression to conditional visibility of group.
0
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.