I am using ReportViewer to chart a dataset, and I wish to show a trendline over time. This requires me to use the value for the first day in calculating the trandline for each subsequent day - is it possible to refer to previous values in the chart, or to set variables when the chart is run with the starting value?
I don't wish to use a Parameter as I would prefer to delegate the calculation of the first value to the ReportViewer rather than the calling application.
Thanks!