Line chart With drop down

Question

I am looking to make a trending Line chart that will be a multipurpose chart.

if my data looks like this:



Year	Weight	Height	Vertical jump
2002	100	5'10"	3"
2003	120	5'10.5"	3"
2004	140	5'11"	3.25"
2005	130	5'11"	3.75"
2006	140	5'11"	3"
2007	120	6'	4"
2008	110	6'1"	4"
2009	100	6'2"	4.5"

is there a way to query the data and us a drop down to change it from a trend of weight by year to Height by year or Vertical jump by year?

i can do this currently but i only know how to do this as a query parameter so every time i select something from the drop down it has to re-query i am hoping to make it refresh just the chart with out having to rerun the query because this could potentially contain a lot of data and want  it to appear instant.

Answer 1

Hi Modbass,

From your description, you are searching a way to sorting the records dynamic, right? If you want to sort the record dynamic without rerun the query, then you can add a interactive sort to the table or matrix. Add interactive sort buttons to enable users to change the sort order of rows and columns in tables and matrices. This feature is supported only in rendering formats that support user interaction, such as HTML. For more information about it, please see:
http://msdn.microsoft.com/en-us/library/cc627509(v=sql.100).aspx

If this is not you want, I am afraid you cannot avoid to rerun the query to sort the record dynamic. Here has a blog about dynamic sorting using parameter in Reporting Services.
http://blog.stevienova.com/2012/04/27/dynamic-sorting-using-parameters-in-ssrs/

Thank you for your understanding.

Regards,

---

Charlie Liao
TechNet Community Support