Hello, I have three columns in table in which I am displaying three charts, for ex: day level, month level and year level. Instead of displaying all three charts from the beginning I want end user to choose which one they want to see. So basically, I want to put three textboxes in a column header that says "D", "M" or "Y" and when user click either one, appropriate chart should be displayed in the column....something like this image http://bespokeinvest.typepad.com/.a/6a00d8349edae969e20120a577077c970c-popup Problem I am facing is to hide/show 3 charts (those are layed down on top of each other) toggled by three textboxes. Initially Day chart will be visible, when I click Month textbox I want to hide Day chart and Show month chart. But reporting services does not allow that. I can only select one textbox as a toggle. I know I can achieve same kind of functionality creating a parameter and selecting which chart to display, but I don't want report to run each time user want to change the view. Any suggestions?

Hi, The toggle item enables users to interactively show or hide report items in the report. However, since there 3 charts need to be switched, based on my testing only using toggle cannot meet the needs. Generally speaking, we can use parameter to achieve this as you posted, but the report need be executed again after changed the parameter value. So, I’m afraid this might be a product limitation, please submit your suggestion at https://connect.microsoft.com/SQLServer/. You feedback is valuable for us to improve the product and service level, and we appreciate your understanding. Thanks, Tony ChainTony Chain [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.