Thursday, February 07, 2013 1:32 AM
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.
- Edited by Modbass Thursday, February 07, 2013 1:42 AM
Tuesday, February 12, 2013 8:26 AMModerator
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:
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.
Thank you for your understanding.
TechNet Community Support