SQL 2008 R2 SSRS and Sharepoint 2010 reporting

Last Post 27 May 2010 07:57 AM by Andrew Fryer. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

27 May 2010 07:46 AM
When does it make sense to opt out for stand alone SSRS installation vs sharepoint 2010 reports deployment?
Andrew Fryer
New Member
New Member

27 May 2010 07:57 AM
If you have sharepoint already I would integrate, traditionally there has been a perfromance hit in doing this (SQL Server 2005/8 on SharePoint 2007), but in the new realease this has largely gone away.
With SharePoint Integration you get integrated security and the reports can be either via web parts or simply appear and behave as documents.

Having said all of that I wouldn't invest in SharePoint just to do this, so integration is the key i.e. reporting integrated with scorecard, documents etc.

Hope this helps Andrew

Acceptable Use Policy