Can I add a Trendline to an RDLC report?

I have an RDLC report based on custom Data sets used in a WPF application. I have a Chart with a simple line chart. IS there a way I can add a trendline开发者_JAVA技巧 to this RDLC report?

I had this problem recently, and just solved it this very minute.

My solution (might not be the best) was to use a stored procedure from the same database as the data to add 'trend' data to the columns returned.

To do the same, you'd need some knowledge of linear regressions, etc. Which I got from stackoverflow here

Are you using a database driven dataset or a static dataset, such as XML? If you're using SQL Server, I can paste the function I used and you can take from it what you like =)