Search This Blog

Tuesday, November 15, 2011

SharePoint SSRS Integration in Local Mode

If you have understanding that SharePoint SSRS integration can work only with SQL Reporting services than it's not the case.Although, In the previous versions of Reporting Services, this was the only mode available and at SharePoint had to be connected to a Reporting Services report server configured in SharePoint Integrated mode in order to render reports using the Report Viewer.

With the release of SQL Server 2008 R2, Reports can be render without integrating SharePoint farm with a Reporting Services report server. Instead, Report Viewer can use to directly render reports from SharePoint when the data extension supports local mode reporting. But in this mode, SharePoint List and the Microsoft Access 2010 reporting can be used as data source.

When it's integrated in local mode, report can be render that has an embedded data source or a shared data source from an .rsds file. However, can’t manage the report or its associated data source as this is not supported in local mode.

Ref : http://technet.microsoft.com/en-us/magazine/ff686706.aspx

No comments:

Post a Comment