SQL 2008 R2 SSRS and Sharepoint 2010 reporting

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

--
27 May 2010 08: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 08: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
---