Dinamically change XAxis scale

Hi,

I have a report consisting of a line chart. The X Axis represent datetime information, while the Y Axis represent machine speed data. The data is sampled every minute from a production machine

I want to let the user select the start and end dates/times for the report. I'd like for the X Axis to "adjust" to the time span selected by the user. For example, if the user selects a timespan of a whole week, I sure don't want to show X Axis labels for every sample (1 per minute), but if the user enters a span of 1 hour, then it might be fine to show 60 labels.

Is there a way to handle such a situation ? Would I be better off not using Reporting Services for that, and use a 3rd party charting component ?

Thank you.

[763 byte] By [LucMorin] at [2007-12-25]