locked
Is there a way for end users to design\construct their own reports? RRS feed

  • Question

  • My first time using SSRS. Reports requirement of the ASP.Net project I'm working on has a large number of reports and the customer keeps coming up with more reports they want to add. Given the large number of reports being asked for, I'm wondering if there is some way for end users to design\construct their own reports as part of the application?

    What I have in mind is to provide only the most critical reports myself and give them facility to "self-service" and design themselves for the rest but is this possible?
    Saturday, December 11, 2010 1:19 PM

Answers

  • This is totally possible. You can use report builder. It is a MS Office based client tool that the users can use to design and deploy their own reports. Although it is not a prereq, i would recommend creating report models and then users can create reports simply by dragging and droping without any knowledge of the underlying data sources.

    http://technet.microsoft.com/en-us/library/dd220460.aspx

    http://msdn.microsoft.com/en-us/library/ms167048.aspx

    http://www.mssqltips.com/tip.asp?tip=1115

    Hope this helps.

    Saturday, December 11, 2010 4:36 PM