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!