Easy Reporting off of SharePoint Data

Yes, it’s sometimes tedious installing and setting up SQL Server Reporting Services on your SharePoint server… but that’s not what this presentation is about.  In this presentation at the Birmingham SharePoint user group meeting, I showed that once SSRS is in place, it is easy to create reports based off of SharePoint list data.  Here is the list of demos that I do, with all the reports being based off of a SharePoint task list:

  • Create a simple table-style report
  • Create a pie chart report
  • Create a pie chart called “Mine by Priority”, which shows the logged in user a chart of only tasks that are assigned to them
  • Create a drill-down pie chart report.  This means that you can click on any piece of the pie to get more details about that part.  It’s a pie chart by priority, but when you click on a specific priority, you get another pie chart that’s showing all of the “Assigned To” people for that priority.  Then you can drill down into any one of those people and see a pie of theirs by status.
  • Create an email subscription to a report.

This is a presentation that I did (on 1/10/2012). It’s an hour and 20 minutes.

The PowerPoint presentation is here: Using Report Builder for List Views and Charting


Technorati Tags: SQL Server Reporting Services,SQL,SSRS,SharePoint,Report Builder,Current User Filter,Report Viewer Web Part


  • If I am in a medium or large farm environment (more than one front end web server), do I need to install SSRS on each front end? I apologize if you answered this in your video, but my company blocks YouTube so I can’t view your presentations.

  • Francesca,
    You only need to install SSRS on one web front end.

  • Just the answer I was hoping to hear – thank you!

  • I really appreciate the video…for some reason I cannot access the powerpoint file? Can check it out to see if it still exists.


  • SSRS Reporting is the best way to get the reports dynamically generated accoeding to the dataset.Good piece of information
    shared in the powerpoint presentation.

  • Alex,
    Yes, it’s there. It’s a PDF file.

  • Can you post the Powerpoint so we don’t need to watch the entire video?

Leave a Reply