Solved

group visibility in SSRS

Posted on 2008-10-20
3
1,026 Views
Last Modified: 2012-05-05
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
Comment
Question by:Nyana22
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 7

Expert Comment

by:natloz
ID: 22761696
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
 

Author Comment

by:Nyana22
ID: 22762955
i tried this, but didn't work
0
 
LVL 7

Accepted Solution

by:
natloz earned 500 total points
ID: 22767467
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

Featured Post

Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Problem Statement In an SAP BI BO Integration project when a BO universe is built on a BEx query, there can be an issue of unit & formatted value objects not getting generated in a BO universe for some key figures. This results in an issue whereb…
So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

735 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question