Line Chart Advice : trying to drill down…. | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Line Chart Advice : trying to drill down….

I have a relatively simple report that is using a graph which plots total costs by month. I am trying to link this to another report using the drill down on the chart values. I want to be able to pass the chart series (which is in the form of 653…652…651 etc etc) to a parameter in another report. For example If I click on the green line it passes the series value of 653 and if I click on the blue series it passes 654 etc etc.
Can this be done and how?????
I have been playing round with the expressions but just cant seem to link it. It links fine if I hard code a series but then that obviously passes the same value for all the series on the graph!!
Any help would be great!

See this helps &


Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |