Answered by:

Make a rectangle as a toggle item using ssrs2012

Question

I have a rectangle in which I displayed information selected as parameters in the report 0 Here I would like to make this rectangle as toggle item as it is shown in the image . Any help will be the most appreciated .

Answers

From the description, I understand that you want to add toggle icons to the rectangle in your report.

As the screenshot you posted, I think you may export the report in Excel format and open it. In Reporting Services, we can interactively expand or collapse report items for a table or matrix, expand or collapse rows and columns associated with a group. Please
refer to the link:
http://technet.microsoft.com/en-us/library/dd220405.aspx. If you only would like to add toggle icon to a rectangle, I think it’s not supported based on my test.

Please provide the report design for further analysis, I will test the issue in my test environment.

All replies

I have a rectangle in which I displayed information selected as parameters in the report 0 Here I would like to make this rectangle as toggle item as it is shown in the image . Any help will be the most appreciated .

Regards .

Hi,

I have a rectangle in which I displayed information selected as parameters in the report

How you did this , can you please elaborate . Within Rectangle do you have any other report item ?

Toggle item based on what? Do you've any other report item based on which you want rectangle display to be toggled? I dont think the screen shot you posted is from SSRS report. It looks more from an Excel spreadsheet.

From the description, I understand that you want to add toggle icons to the rectangle in your report.

As the screenshot you posted, I think you may export the report in Excel format and open it. In Reporting Services, we can interactively expand or collapse report items for a table or matrix, expand or collapse rows and columns associated with a group. Please
refer to the link:
http://technet.microsoft.com/en-us/library/dd220405.aspx. If you only would like to add toggle icon to a rectangle, I think it’s not supported based on my test.

Please provide the report design for further analysis, I will test the issue in my test environment.

Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.