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>?
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?
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
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.
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)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.Valu e="3rdGrou pValue", I was refering to the field value that makes up the 3 groups you mentioned: sfw, hdw, no app.
ASKER
Thanks for the help with this.
Thanks guys.
you should be able to hide duplicates of a given column by setting the property value to the name of the group
SSRS2005TextboxProperties.png