Is there any way to use an Expression for a ToggleItem on a RowGroup or TextBox? The 2008 BIDS only allows selection of TextBoxes for the ToggleItem Property.

Please see http://lukehayler.com/2010/02/custom-visibility-toggling-ssrs-2008/, it explains how to do thatArthur My Blog

That link only shows how to use a Visibility Properties; it doesn't show a way to use an Expression for ToggleItem.

=IIF(Fields!YEAR.Value = 2001, True, False) and the picture shows the expression you need to set (in your case it will be similar)Arthur My Blog

That shows how to change the Group Visibility. I want to use an expression to set the ToggleItem. In the picture you posted that's the dropdown underneath "Display can be toggled by this report item:" and it's set to the TextBox "YEAR".

Found an old suggestion for this on MS Connect: https://connect.microsoft.com/SQLServer/feedback/details/264530/report-designer-allow-expression-to-choose-toggleitem Please add your votes!

Hi Dbooksta, Currently, it is not supported to configure the toggle item by using an expression. That is to say a report item can only be shown/hidden by a unique toggle item in any condition. Personally, I recommend you submitting this good suggestion at https://connect.microsoft.com/SQLServer/. If the suggestion mentioned by customers for many times, the product team may consider to add the feature in the next SQL Server version. Your feedback is valuable for us to improve our products and increase the level of service provided. Thanks for your understanding. Regards, Mike Yin