sql server reporting services: expand visibility for recursive detail row based on prompt value -- sql server reporting services

expand visibility for recursive detail row based on prompt value

Patty B
10/21/2005 1:25:04 PM

sql server reporting services:

I have a table with hierarchical data where I am toggling the recursive items
underneath. I am setting the initial Visibility setting for the details group
based on the recursive level. My visibility expression looks like
"=IIF(Level("PathName_Details_Group")=0,False,True)" and I have the
Visibility can be toggled by another report item box checked with the field
specified.

This all works very well normally, but I would like to have a prompt
(boolean for expand all true/false) that will automatically expand all of the
detail rows. How do I do this?

Re: expand visibility for recursive detail row based on prompt value

Robert Bruckner [MSFT]
10/21/2005 6:05:46 PM

Assuming you have a boolean report parameter ExpandAll, modify the
visibility expression to:
=iif(Parameters!ExpandAll.Value OR Level("PathName_Details_Group")=0, False,
True)

-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]