I have created a matrix report. In columns section there is a field called Ccy In Data section, there is the field called value In rows section there is a field called code Then I right clicked on the Code column matric header and then selected Add Group, Parent Group, Group by country field, and checked the both checkboxes for add group header and footer. The cell where I have placed the Code field, is now set to true for InitialToggleState. The cell where I have placed the country field, is now set to true for InitialToggleState as well. The visibility of the cells where I have placed value and Code is set to hide initially but toggle with the country field. so column groups is value Row groups are country and then Code When the report is run in preview, I see the country field expanded with - sign next to it for each row. The Code and Value fields are not shown as expected. Question: Why is it that eventhough there is a - sign i.e. the country field is not expanded, still I see the gaps on the right hand side for the columns which are NOT shown? The report should only show the expanded sections if I click on the - sign but I see the spaces for the area which can be expanded. Hope you know what I mean. Any thoughts please? Thanks

Hi arkiboys, If I understand correctly, the toggle added to the Country textbox is set to expanded initially, however, the Code field is hidden at run time. Besides, there is white gap between the Country group footer and group header when the Code texbotx is hidden. The two issues occur because: The InitialToggleState property setting of the Country textbox doesnt affect the initial visibility of the Code textbox.You set the visibility of the Code textbox rather than the Code group when adding the toggle. To avoid the issue, please following the steps below: Remove the current visibility settings on the Code textbox, including the toggle setting.Right click on the Code group from the Row Groups pane, and open the Group Properties dialog box. Click the Visibility tab, select the Show option, and set the group to be toggled by the Country textbox.Keep the InitialToggleState property of the Country textbox as True. Regards, James Please Visit: TechNet Cross Product & Scenario Based Support Forum(Chinese Edition)

Thank you