I recently had to create a chart in SSRS which needed to be have some generalized settings – in this case the X-axis of the chart needed to be adjusted as per the supplied parameters. The X-axis can be any type of values : Category values, Year or Month values. I have a tablix in my report and based on the action performed on it, the Chart should change the X-axis. A simple solution is to create three different charts and show/hide them by controlling the visibility property. However, I wanted a more flexible solution.
Please look into the complete article on www.sql-server-performance.com
Tags: SSRS, Charts, Generic, Grouping, expand, collapse, dynamic