• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 371
  • Last Modified:

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
0
thomasm1948
Asked:
thomasm1948
1 Solution
 
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
 
thomasm1948Author Commented:
Sorry here is the attachment
Capture.GIF
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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
 
ValentinoVBI 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
 
Alpesh PatelAssistant ConsultantCommented:
Just go to Column/Row group property-> visibility


In that Write expression to conditional visibility of group.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now