I have a chart in SSRS that shows the count of items per department. I also
have a table in the report that is hidden initially. In the action of the
Data Values, I want to display the chart and pass the dept ID to the chart to
filter the data. Clicking each data point on the chart drills down and shows
the details in the table. Is this possible? I have tried many ways and seem
to be hitting a dead end.