Geeks With Blogs


eXTReMe Tracker

Head Explodes Too much information

So I'm in Boston at Tech Ed 2006.  Lots to see and learn...  Its been a great time so far.  I went to a session today on changes to improve the integration between SQL Server Reporting Services 2005 (SSRS) and Sharepoint V3 (MOSS & WSS).  Here's a few things I learned:

  • The changes will be part of a SQL Server 2005 SP coming out a month or two after Office 2007 ships.
  • Reports can be stored in Sharepoint document libraries and use Sharepoint's security, including report-level (like item-level) security
  • Report management can be done completely in Sharepoint, including modifying report parameters, security and data-source management
  • Data-Sources can also be stored directly in Sharepoint libraries and managed as well
  • The report viewer web part has been cleaned up with some new functionality, parameters show up on the right-side now instead of the top, which IMO is a better location
  • Reports can be scheduled to generate and send results into a document library, new to this release.

So basically, you won't have to use the report manager interface anymore if you integrate with Sharepoint.  You can still run them side-by-side, from what I know.  There's supposed to be a CTP of this later this summer, so there'll definately be more to see from this in the months to come! 

Posted on Tuesday, June 13, 2006 12:01 PM Sharepoint | Back to top

Comments on this post: SQL Server Reporting Services And Sharepoint V3 integration

# re: SQL Server Reporting Services And Sharepoint V3 integration
Requesting Gravatar...
Could You give an example how to generate report and send it to library in WSS
Left by Marcin Migdal/Poland on Aug 07, 2008 3:56 AM

Your comment:
 (will show your gravatar)

Copyright © Solid | Powered by: