Reputation: 13
In SSRS, I have a chart that displays data in columns by month. I want to be able to click a column in the chart and go to another report with that month as the parameter for the new report. Is that possible? If so, how do I do it?
Upvotes: 1
Views: 1914
Reputation: 8113
It is possible. This is called "drill-through". You just have to right-click on the column, open "properties", go to the "action" section and check "Go to report". Chose your report and add the field as parameter to this new report.
Forgive me if the labels are wrong, my client uses a foreign version of SSRS and I can't remember all labels by heart.
Hope this helped!
Upvotes: 3