• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 769
  • 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
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

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