Web based reporting delivery with Microsoft SQL 2008

checkonetwo
checkonetwo used Ask the Experts™
on
I looking to standardize our analytics/ reporting and move away from Crystal Reports.  All our applications run off of Microsoft SQL 2008.  Can anyone recommend a web based product that will allow us to setup web viewable reports?  I need security per user so the sales staff can view the accounting reports.  Qlikview has a nice look but, was looking for a more cost effective solution.  I havn’t had an opportunity to review SQL Reporting Services and not sure if this will meet my requirements  Any recommendations appreciated.
Thank you
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
SQL Reporting Services has all the features you describe (and more :-) )
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
SSRS should meet your needs.

FYI - building a report in SSRS is a vastily different process than building a Crystal Report.  Be prepared for a learning curve and the requiement for training.

What are your reasons for moving away from Crystal?

There are tools that can help but you will basically have to recreate all the reports you have written from scratch.

mlmcc
We are also moving from Crystal for cost reasons. We have moved several reports to SSRS and have found that, while the SSRS interface is not difficult to use, the average user does have troubles with it. We are also now building simple .NET web applications for our users that helps out with the oddities of SSRS that seem to give our users troubles.

As mlmcc stated, there is a learning curve but I have found that I can do more with SSRS that I was able to do with Crystal. As far as cost is concerned, while SSRS is free, you need to consider your time in learning the new environment. Once you have it mastered, I do believe it is the best option.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial