all groups > sql server reporting services > june 2006 >
You're in the

sql server reporting services

group:

Reporting Services - Add a trendline with forecast to a chart



Reporting Services - Add a trendline with forecast to a chart EmmaNikki
6/2/2006 4:47:11 PM
sql server reporting services: I know how to add a trendline with forecast in Excel. How is it done in SRS?

Thank you,

Re: Reporting Services - Add a trendline with forecast to a chart andrewb NO[at]SPAM dundas.com
6/6/2006 9:38:07 AM
Emma

I would like to invite you to try Dundas Chart for Reporting Services.
What you are attempting to do is simple with our RS offering and an
example of this is included with our distribution.

Please visit www.Dundas.com to download a fully functioning eval
version.

Thanks

Andrew Bryan
Dundas Software



[quoted text, click to view]
Re: Reporting Services - Add a trendline with forecast to a chart EmmaNikki via SQLMonster.com
6/6/2006 5:21:58 PM
I took a quick toor of your website - the product looks great. I'd be buying
it with my funds, so can't do that.

Thanks, anyway.

Emma

[quoted text, click to view]

--
Message posted via SQLMonster.com
Re: Reporting Services - Add a trendline with forecast to a chart Tony Scott
8/15/2006 5:00:02 AM
Emma,

We came across the same problem, so we wrote a Stored Procedure that, for a
given set of values , would return the Linear Regression values of:

@XCOUNT:
@XSUM :
@XSUMSQUARE:
@YSUM:
@SUMXY:
@SLOPE:
@INTERCEPT:

being the standard elements of calculating Linear regression. The Slope
indicates the Trend.

If you want a version of this, I can supply you it, it costs nothing, but I
will not post it on the forum at present.

Tony

[quoted text, click to view]
AddThis Social Bookmark Button