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

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>?
0
pgmtkl
Asked:
pgmtkl
  • 5
  • 4
1 Solution
 
Chris LuttrellSenior Database ArchitectCommented:
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
0
 
pgmtklAuthor Commented:
I want to hide all rows for a certain group.
0
 
Chris LuttrellSenior Database ArchitectCommented:
not seeing what you are trying to do yet.  Maybe more details or pictures would help?
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
pgmtklAuthor Commented:
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
0
 
Chris LuttrellSenior Database ArchitectCommented:
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

0
 
Chris LuttrellSenior Database ArchitectCommented:
A picture of that to try to help clarify.
SSRS2005RowVisibilityProperty.png
0
 
pgmtklAuthor Commented:
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?
0
 
Chris LuttrellSenior Database ArchitectCommented:
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.
0
 
pgmtklAuthor Commented:
Thanks for the help with this.
0
 
jaythomsupportCommented:
Thanks guys.
0

Featured Post

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.

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