Use SSRS in SharePoint integrated Mode when….. (We already love SharePoint at my organization)
If your organization or company is already taking advantage of SharePoint, then plan on installing your SQL Reporting Services instance in SharePoint integrated mode. The reason? If your organization recognizes SharePoint as a one stop shop for content management, document management, collaboration, team sites, search…..on and on….then the natural place for your report consumers and business analysts to access their reports is within SharePoint.
Use SSRS in SharePoint integrated Mode when…..(We are pretty sure we are going to love SharePoint at my organization)