Toggle Expand (-) And Collapse (+) Symbols Are Wrong -- sql server reporting services

G. Ray Giacalone
7/18/2006 3:54:09 PM

Using Reporting Services on SQL 2005
Microsoft Internet Explorer 6.0.2900.2180
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600

I have a report that expands and collapses rows in a table but its showing
the wrong symbols
to expand (-) and to collapse (+). The report opens with everything
expanded and I control
the expand/collapse with the Visible property of the row using something
like the following:

Hidden = IIF((Parameters!ExpandAll.Value=0), True, False)
ToggleItem = (field name above current row)

How do I get the right expand and collapse symbols back?

Thanx!

Tim Dot NoSpam
7/19/2006 9:38:31 AM

Look at the InitialToggleState property. The default is Collapsed. You
need to set its expression to "=IIF(Parameters!ExpandAll.Value = 0, False,
True)" or vice versa. I always get that wrong... Collapsed V. Expanded is
a boolean and I'm assuming Collapsed == False, but I'm left handed, so my
logic is usually backwards....

-Tim

[quoted text, click to view]

sql server reporting services : Toggle Expand (-) And Collapse (+) Symbols Are Wrong