Reporting Services - Add a trendline with forecast to a chart

[EmmaNikki]

I know how to add a trendline with forecast in Excel. How is it done in SRS?

Thank you,

Emma

[a***@dundas.com]

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

Post by EmmaNikki
I know how to add a trendline with forecast in Excel. How is it done in SRS?
Thank you,
Emma

[EmmaNikki via SQLMonster.com]

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

Post by a***@dundas.com
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

Post by EmmaNikki
I know how to add a trendline with forecast in Excel. How is it done in SRS?
Thank you,
Emma

[Tony Scott]

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

Post by EmmaNikki via SQLMonster.com
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

Post by a***@dundas.com
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

Post by EmmaNikki
I know how to add a trendline with forecast in Excel. How is it done in SRS?
Thank you,
Emma

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200606/1

[p***@gmail.com]

Post by Tony Scott
Emma,
We came across the same problem, so we wrote a Stored Procedure that, for a
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

Post by EmmaNikki via SQLMonster.com
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

Post by a***@dundas.com
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

Post by EmmaNikki
I know how to add a trendline with forecast in Excel. How is it done in SRS?
Thank you,
Emma

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200606/1

can you please send me the procedure for regression line. I need your help

[Cathy Harrison]

Hi Tony,

We are working on a report on SQL 2005 and found your posting. Is it too late to request a copy of the stored procedure you created to solve this problem?

Thanks,
Cath

From http://www.developmentnow.com/g/115_2006_6_0_0_766503/Reporting-Services--Add-a-trendline-with-forecast-to-a-chart.ht

Posted via DevelopmentNow.com Group
http://www.developmentnow.com/g/