How to report in MOSS

Quick post to make a note of how to do basic reporting using MOSS.
If you have MOSS 2007, your best reporting options are:
  1. Deploy the Content Query Web Part (http://www.datasprings.com/resources/articles-information/about-sharepoint-content-query-web-part). This will provide a basic (QBE-type) interface to generating lists about your documents.
  2. If you need more complexity, best option is to integrate SQL Reporting Services with MOSS 2007 (http://mosshowto.blogspot.com/2009/01/integrating-sql-server-2008-reporting.html). This will allow you to write T/SQL and use drag/drop tools. Both options query the catalogue.
  3. If you have problems configuring them to work together (this was the first time, these products worked together); this will help (http://www.docstoc.com/docs/78198021/Reporting-Services-SharePoint-Integration-Troubleshooting).
If you have MOSS 2010, your best reporting options are:
  1. Deploy the Content Query Web Part (http://blogs.msdn.com/b/ecm/archive/2010/05/14/what-s-new-with-the-content-query-web-part.aspx). It is installed and operates slightly differently to the previous version of MOSS; hence the different link.
  2. If you need more complexity, best option is to integrate SQL Reporting Services with MOSS 2010 (http://msdn.microsoft.com/en-us/library/bb326356.aspx). This will allow you to write T/SQL and use drag/drop tools. Both options query the catalogue. Again – this operates slightly differently to the previous version of MOSS; hence the different link.
  3. Once integrated then you create reports using Report Builder like this (http://fendy-huang.blogspot.com/2011/02/create-ssrs-report-with-sharepoint-2010.html). This is broadly the same as it was for MOSS 2007.
This entry was posted in Collaboration, Development and tagged . Bookmark the permalink. Post a comment or leave a trackback: Trackback URL.