Regression FormulaI made a frustrating discovery a few weeks ago that I’m still dumbfounded by and keep hoping someone will surprise me with an answer, but so far my forum postings have yielded no fruit. 

We have standardized on the increasingly popular Microsoft SQL Reporting Services as our standard report writing architecture at the office.  It is great because it is very similar to Crystal and offers a bunch of features such as a web service API, supports report subscriptions and tons of other useful elements. 

The discovery I made however is that while the graphing components are a stripped down version of the Dundas controls, the ability to plot a simple trendline on a line chart or scatter plot is non-existent.  We have gotten so used to looking at trend lines and Excel has made it so easy to do this, just a couple clicks and you can quickly see how things are trending using a variety of regression formulas.  We use SQL Reporting Services 2005, and apparently, adding a trend line means you have to do it the hard way.  Y=MX+B, how hard could it be?…let me tell you, it isn’t something they teach you in SQL 101.  If anyone else out there has found a relatively painless way of doing this, please share!

Popularity: 38% [?]

Other Posts that May Interest You