When I hide the item that toggles the visibility of other items, those items are hidden too.
I'm having an issue in Reporting Services. My detail rows are initially shown, but their visibility can be toggled by the group header. The group header is in a totals row above the detail lines. This works fine, but I'd like to conditionally hide the group header and basically not group if a parameter is set. My group is set to group on an expression =IIf(Parameters!ShowGroup.Value, Fields!Group.Value, ""). Instead of showing the row header as a column to the left of the data fields I want it shown above the fields so it will appear like this: Col1 Col2 Col3 Group Heading 1 Val1 Val2 Val3 Val1 Val2 Val3 To do this, I right-click the Details row group and insert a totals row above. I can then set the expression of the text box to show my group value. I then set the visibility of the detail row to show initially and set "Display can be toggle by this report item" and select the Group Heading text box. The problem is when I set the Row Visibility of the "Group Heading" row to Show or hide based on an expression Not(Parameters!ShowGroup.Value). When I set the parameter to False, the group row hides, but it hides the detail rows as well. Though oddly it will still show the first detail row. If I export the data to Excel, it exports all the rows but they're collapsed and there's a duplicate of the first row at the end of the collapsed group. Any help would be appreciated, though it seems like it's a bug.
October 5th, 2012 7:19pm
Hi, you can try to set the visibility of the group from the grouping pane instead of the row visibility. Regards, Leo
October 7th, 2012 11:26pm
I've tried setting the visibility through row visibility and group visibility and tried row visibility for the group and group visibility for the details and vice-versa. None of the combinations I've tried results in the desired behavior.
November 5th, 2012 12:07pm