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

group visibility in SSRS

Hello,
i have on report in SSRS,
It has 3 groups, so 2 levels and the details level.
The initial visibility of lev 2 is toggled by lev 1
The inial visibility of the detail level is toggled by the lev2.
I have one field in the detail level, and i want depending o it's value to show or not the line item in the detail.
If this field value is not 1 i need to show the items...
How can i accomplish this please?
thanks
0
Nyana22
Asked:
Nyana22
  • 2
1 Solution
 
natlozCommented:
Click on the detail row, and in properties go to Visibility -> Hidden and select <Expression>

for the expression do something like:

=IIF(Fields!varFieldName.Value = 1, True, False)
0
 
Nyana22Author Commented:
i tried this, but didn't work
0
 
natlozCommented:
Are you getting an error, what is happening?
Maybe you have to cast to an integer such as

=IIF(Cint(Fields!varFieldName.Value) = 1, True, False)
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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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