Daniel Bowlin (8/7/2012)
SSRS is a great tool for canned reports, and reports that need a variety of parameters. It is not a what-if tool. Most people understand Excel, so I think a great ad-hoc reporting tool is either Excel or PowerPivot which is very Excel like. It is possible to configure them to connect directly to a data model or data source.
Thanks.
We do have a 2012 license but running 2008 because of 3rd party apps