I have a column breaking up employees by disability plans and have the following columns PLAN EMPLOYEENAME EMPLOYEEID SALARY I set up the report so that it initially shows the total salaries for both of the plans and has a drill down feature to list each of the employees and their salaries. What I would like it to do is hide the employeename & employeeid columns unless I drill down through the plan column. Thus, it should initially look like this: PLAN SALARY Longterm $XX,XXX Shortterm $XX,XXX And, if I expand either longterm or shortterm, it now looks like this: PLAN EMPLOYEENAME EMPLOYEEID SALARY Longterm John 123 $XX,XXX Mike 234 $XX,XXX Shortterm Tom 345 $XX,XXX I've looked and the best I can do is to make a 2 step process -- first, expand the rows (to see the individual amounts) and then expand the column to show the employee names. Is there any way I can do it in one step -- i.e. when they expand the rows, it automatically expands the columns?

HI shy You can do this by setting column visibility option, for that you need to be sure that you have put all column other the PLAN in column section of your matrix. Please let me know if this helps. Hopefully i have answered you correctly. Thanks, Hasham

I tried doing that and I got the following error message: "The tablic 'Tablix1' has 'Plan' 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." As a note, for the toggle item, I selected the Plan textbox. If I choose the column header, it works except I have 2 steps to do then: 1) Expand the rows by clicking on the Plan 2) Expand the columns by clicking on the Plan column header. Basically, it looks like as follows: Notice the expansion button for both the column header as well as both plans. I have to click both to get Employee Names (the same would apply for Employee ID but I'm starting with one field and then will do both once I get one working). Is it possible to link the expansion of the rows to the expansion to the column as well. In other words, once I expand either of the Disability columns, the Employee Name column appears automatically as well.

Hi Syoungkin, From your description, you want the EmployeeName column and EmployeeId column to be hidden when the parent group is collapsed in the drilldown report, right? As per my understanding, its not supported in Reporting Services currently. When we add a toggle to a textbox, the textbox must share the same scope as the hidden item or is in a scope that contains the hidden item. But here has a workaround for this scenario, the steps below are for your reference: Drag a matrix onto the design surface.Drag Salary field from dataset to the details. Put the expression below to your row group: =Fields!EMPLOYEENAME.Value & " | " & fields!EMPLOYEEID.ValueRight-clcik RowGroup in the RowGroup pane and select Add Group, then click Parent group.Select Plan in the Group by drop-down list. Select the Add group header check-box.Drag Plan field to the group header. Delete the first column.Right-clcik RowGroup in the RowGroup pane and select Group Properties, then select Visibility in the left in the Group Properties window.Select Hide in the When the report initially run radio button.Select Display can be toggled by this report item, and select Plan in the drop-down. The screenshot below are for your reference: Regards, Charlie Liao