Home Forums SQL Server 2005 Business Intelligence Problems Using Expressions to control the Visibility ToggleItem (SSRS 2005) RE: Problems Using Expressions to control the Visibility ToggleItem (SSRS 2005)

  • Hi Dave:

    I have a similar problem. I want to set the "ToggleItem" property of the detail row to an expression, but it appears that SSRS 2005 is truly taking any text supplied in the ToggleItem property as a textbox name, and doesn't bother to process the expression as an actual expression. So, any expression that is typed into the ToggleItem property will fail since no textbox has a name that looks like an expression.

    To highlight my specific situation, I have a parameter where a user can either group by "company" or group by "manager". If a user selects to group by "Company", then I want the ToggleItem of the detail row to be toggled by a textbox in the group header called "GroupName_1": i.e. the report groups by Company, and a user can then toggle to the details to see the managers for a specific company. If a user selects to group by "manager", however, then I want the detail row to remain hidden without any mechanism to toggle its visibility since the managers' data is now at the group level.

    Bottom line: I don't think it's possible to supply an expression in the detail row's ToggleItem property since SSRS will take any text supplied in the property as a textbox name.

    If someone knows a way around this, please share.

    --Pete