Wednesday, March 21, 2012

Reporting Services - Add a trendline with forecast to a chart

I know how to add a trendline with forecast in Excel. How is it done in SRS?
Thank you,
EmmaEmma
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
EmmaNikki wrote:
> I know how to add a trendline with forecast in Excel. How is it done in SRS?
> Thank you,
> Emma|||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
andrewb@.dundas.com wrote:
>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
>> 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|||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
"EmmaNikki via SQLMonster.com" wrote:
> 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
> andrewb@.dundas.com wrote:
> >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
> >
> >> 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
>

No comments:

Post a Comment