SSRS Line graph, would like to show scrolling 3 months of statistics on category axis
Worrking in report services, I have a line graph Series groups as tractor type, category groups of DAY and week ending(sorted decending), and values of Percent active. I would like this report to display 3 months of data, but would like to be able
to scroll to an older date, without having to enter new date range parameters.
I can't seem to find where to define this.
Thanks!
SharonSharon
May 13th, 2011 4:09pm
Hi Sharon,
Generally, the built-in chart of Reporting Services only supports a fixed data range without scrollbar. As you posted, we can use parameter to change the data range. Since you need
to scroll the chart without inputting parameters, one workaround is to use 2 textbox to drillthrough the report and change the parameter values. For the detailed steps, please refer to the similar thread at
http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/113752bb-4410-4167-b702-55bbb9bdc68f
Thanks,
Tony Chain
Tony Chain [MSFT CSG] | Microsoft Community Support
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
May 19th, 2011 5:14am