September 6, 2012 at 7:08 am
I have just released in our company my first series of reports that went from a printed (excel used for creation) to SSRS generated reports. These reports are currently exported Daily in .MHTML format that are used on our internal web site.
I am already getting some requests for things that are either tougher or not available in SSRS (IE: trend lines, second Axis, multiple legends with secondary information about the data shown).
I am curious how others are outputing reports from SSRS for use in your companies? I have thought about having to output my data to excel anyway and use it for the graphing functions, since it is so much better than what we have with SSRS.
September 11, 2012 at 4:49 am
I tend to use the same format as you, rarley I output to Excel, last time I did that was when I sent the output to a group (AD) that requested it in Excel format.
I quite like SSRS graphs though.
September 11, 2012 at 5:29 am
Thanks for the feedback. I have been getting requests for using Trendlines to see how things are going over say an 18 month rolling time frame. Any ideas on how to accomplish that?
I just had a need to create/change to using two Axis on a report as the numbers were related but were on two different levels (hundreds/thousands) vs (hundred thousands). I like SSRS, but am not sure how much I will be able to leverage it. We have some serious Excel folks here (that was their "database" of choice before I got here. 🙂 )
September 11, 2012 at 6:13 am
Im guessing you should check out calculated series - I have used these before to get a "moving average" over a set of data.
Ah excel, you got to love it. says the SQL DBA 😀
September 11, 2012 at 7:28 am
Thanks, I will check out calculated series. Cheers.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply