asked on

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

TempDBA

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.

thomasm1948

ASKER

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

thomasm1948

ASKER

Sorry here is the attachment
Capture.GIF

Nico Bontenbal

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

ASKER CERTIFIED SOLUTION

ValentinoV

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Alpesh Patel

Just go to Column/Row group property-> visibility

In that Write expression to conditional visibility of group.