Link to home
Start Free TrialLog in
Avatar of pgmtkl
pgmtkl

asked on

ssrs hiding group

If i have grouping on and it contains 3 sections and want to only hide duplicates in one of those sections. how can i do that>?
Avatar of Chris Luttrell
Chris Luttrell
Flag of United States of America image

by sections are you meaning, 3 columns of data or what?
you should be able to hide duplicates of a given column by setting the property value to the name of the group
SSRS2005TextboxProperties.png
Avatar of pgmtkl
pgmtkl

ASKER

I want to hide all rows for a certain group.
not seeing what you are trying to do yet.  Maybe more details or pictures would help?
Avatar of pgmtkl

ASKER

I have an ssrs reports that has 3 groups - sfw, hdw, no app. within those 3 groups the sfw and hdw will have duplicate rows so i dont want to hide anything. in the 3rd group i have the below example of data- some rows are duplicates and i want to hide all detail rows only in the no app group that have duplicates. i cant hide duplicates in whoe report

servera  12
servera  12
servb    1
servc  1
servt  12
servt  12
try putting something like this in the Row>Visibility>Hidden property.
That is the only way I can think of to do that for only one subset of records.
=IIF(Fields!yourGroupField.Value="3rdGroupValue" and Fields!yourField1.Value=Previous(Fields!yourField1.Value),True,False)

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of Chris Luttrell
Chris Luttrell
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of pgmtkl

ASKER

i am getting the definition is not valid that the hidden expression for table refers to table1_group2 . reprot expressions can only refer to fields within current data set scope, if inside an aggreate, the specified data set scope. do i need to change something?
your are going to have to share more details, I do not know exactly what you put in your expression or how table1_group2 relates to it.  table1_group2 sounds like a GroupName or something.  When I used Fields!yourGroupField.Value="3rdGroupValue",  I was refering to the field value that makes up the 3 groups you mentioned: sfw, hdw, no app.
Avatar of pgmtkl

ASKER

Thanks for the help with this.
Thanks guys.