I'm having great difficulty getting the toggling to work! I've got a table with a detail row, a group row and a header row. What I want to do is to toggle on a group field hiding and displaying the detail row, but also hide or display specific columns as well as they're not applicable when the detail row is hidden. Is this possible? I've set the initial visibility to hidden in the Details Grouping tab and set the visibility can be toggled by another report item to be the first field in the group row. When I then highlight a column in the table to hide this according to the same toggle item, right click and select properties and set the toggle item to be the first field in the group row as above, I get the following error:
[rsInvalidToggleItem] The table ‘table1’ has ‘CRSRefHeader’ as a toggle item. Toggle items must be text boxes that share the same scope as the hidden item or are in a scope that contains the hidden item, and cannot be contained within the current report item unless current grouping scope has a Parent.
This sort of makes sense, but I don't know how to fix it! Any ideas?