Last post Mar 23, 2011 05:20 AM by You-Hu Fu
Mar 10, 2011 03:07 PM|hfamili|LINK
We have a SaaS based product and the end users have expressed the desire to create custom/ad hoc reports. I was doing some research and came across SQL Reporting Services. However, I am still fuzzy as to how I can enable end users to design their own reports.
My research seems to indicate that the users need to use Report Builder or Visual studio to create their reports but we don't want a) the client to have to download/buy a thick client 2) give direct access to the database through the firewall. We'd like the
end user to simply use our own .NET application to create their reports within the product. Is there a way/component that we can put in our application that'll allow the users to create their own reports using pre-configured datasets in SQL reporting services
(that we expose)? We don't want them to see the whole schema and/or any database connection parameters. Further, our end users are from different entities so we'd also need to limit/segment each entity to their own reports.
Thanks for your input.
Mar 23, 2011 05:20 AM|You-Hu Fu|LINK
This paper introduces Microsoft SQL Server 2005 Report Builder and demonstrates how to build an end-to-end ad hoc reporting solution for enterprise customers using Report Builder and Microsoft SQL Server 2005 Analysis Services OLAP, please refer to this
You could also refer to MSDN Webcast: End-User Ad Hoc Reporting with SSRS (Level 300) https://msevents.microsoft.com/cui/webcasteventdetails.aspx?eventid=1032273699&eventcategory=5&culture=en-us&countrycode=us