You may want to use Power View in SQL Server Reporting Services 2012 assuming you have SharePoint available.

If you are using SSRS 2008 then you can create a Report Model which your permitted users can use to create reports.