Reporting Services for End Users

  • Hi,

    We currently use a fairly basic reporting system to report from our SQL data sources. It's easy for end users to create new reports--they drag and drop columns that they want, can add simple criteria, etc. They can also easily export the reports in a number of different formats (xml, csv, excel, pdf, etc.). Although I haven't worked a ton with SSRS, I know it's extremely powerful, but from an end user perspective for building simply reports, is it a relatively easy tool to use?

    Thanks,

    Mike

    Mike Scalise, PMP
    https://www.michaelscalise.com

  • It's not the most easiest tool, because users have to write their own queries. Unless they all use stored procedures or shared datasets.

    Or you can use the report model (some sort of metadata framework) in older versions, but that has been deprecated.

    An easier tool is Power View, but currently it's editing options are very limited.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Hi Koen,

    Thanks for the response!

    Can you recommend any other good end-user reporting tools besides Power View that have good options and are user friendly?

    Thanks,

    Mike

    Mike Scalise, PMP
    https://www.michaelscalise.com

  • You can take a look at Targit, Qlikview and Tableau.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Again, thank you Koen!

    Mike Scalise, PMP
    https://www.michaelscalise.com

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply