How to display a table after clicking on a chart in ssrs?

Question

Hi all experts,

I need to display a table control after clicking on a chart. 

I was looking for the visibility property of the table which can be set based upon click on the bar chart.

Please respond asap...

Answer 1

After doing some r&d on net and playing with chart control and its properties, I could find that the series properties of the chart control has an action option. I could not display or hide a tablix on the same page but as a solution to my requirement, I have added a subreport that contains the tabular data for the chart . In the series properties->Action tab, I have set this subreport for redirection. 

Now, when I preview my chart and click on the series displayed on the chart, navigating to subreport containing the tabular data.

Answer 2

Hi Manisha,

If I understand correctly, you want to control the table visibility through clicking the chart. In this case, please refer to the detailed steps below:

1. Create the parameter named Control, check the Boolean option in the drop-down list of the Data Type, and select Hidden in the parameter visibility tab.

2. Specify the default value of the parameter to True.

3. Click the series in the chart and select “Action” in the Properties pane and click the ellipsis as follows:

 

4. Select the “Go to report” tab, and select the self-report in the “Specify a report” tab.

5. Pass the parameter as bellows:

  Name:Control  Vaule:false

6. Right click the table control, select Tablix Properties and select the Visiblity property.

7. Select the tab of Show or hide based on an expression, and add the expression below:

=iif(Parameters!Control.Value=true,true,false)

If you need more assistance, please feel free to let me know.

Regards,
Heidi Duan

 

 

Answer 3

Thanks Heidi. This is what exactly I wanted. Working !!!

Answer 4

Thank you soooooooooooooo much !!!!!!!!!! you helped me alotttttttttttttttttttttttt