Posted: 5/8/2012
Can anyone suggest some alternate developer tools for creating reports in place of SSRS. After upgrading to 2008R2, many existing reports no longer display properly when using anything but IE or Firefox. Also, in my opinion, the ReportManager is less end-user friendly with its changed GUI. An ideal tool would be cross-browser friendly, allowing a customizable front-end for presentation and automated delivery of our reports. As we don't want to install Sharepoint, PowerView doesn't seem to be an option either.
And...
Has anyone had good success with an alternative tool to ReportBuilder 3.0? We are currently using Excel Pivot Tables connected to our SSAS Cubes for ad-hoc reporting, but would like a report generating tool that is directed more towards the basic end-user instead of the RB 3.0 targeted power-user audience.
Posted: 5/9/2012
You might want to look at m-Power. It works great for web reporting, and is one of the few tools that lets you build web based pivot tables. Here's a link to a web pivot table on m-Power's demo site.
Posted: 5/10/2012
Thanks for the tip Steve, I am checking it out now. Does it work with SSAS cubes?
Posted: 5/11/2012
I know it works with most data sources, but I haven't had much experience with SSAS cubes. That being said, it shouldn't matter much, as it will give you the same results without a cube. It can connect straight to your MS SQL database and let you build web pivot tables (or other reports) without the need to pre-format your data into an OLAP cube.