locked
SSRS integration with Sharepoint Advantages? RRS feed

  • Question

  • I have Sql Server 2008 R2 installed on server 2003 64bit named "MSSQL", and SharePoint Foundation installed on server 2008 R2 named "SP" which uses MSSQL.  I want to configure SSRS in Sharepoint.

    When I configure SSRS on MSSQL with Sharepoint Integration mode, I cannot navigate to the resulting SSRS URL because Sharepoint is not installed locally.  But I cannot install Sharepoint locally because it requires server 2008 sp2 or higher.

    If I configure SSRS on MSSQL in native mode, then I am able to navigate to the SSRS URL.

    1.  Is there a way to make the above configuration work so that SSRS integrates with SP?

    2.  If not, I need to understand the advantages (besides security, we're small and my users are social workers who are afraid of computers) of integrating with SP to determine if it's worth moving sql server to a server 2008 installation.  (I dont care about the other benefits/performance of server 2008 over server 2003).  I assume I could create a link on our sharepoint page to point to the SSRS URL for reports.

    We are currently using crystal reports for our custom reporting needs, but I'd rather move to SSRS.

    Tuesday, March 22, 2011 5:30 PM

Answers

  • You can't count me as a fan of SharePoint Services. For unsophisticated IT organizations, IMHO it's far too complex. I've discussed these issues with many SharePoint experts and they (for the most part) agree that there are far too many options and issues to make it easy to administer or for end-users to access the reports consistently.

    I would stick with your Report Manager or custom application (built around the ReportViewer control).


    __________________________________________________________________
    William Vaughn
    Mentor, Consultant, Trainer, MVP
    http://betav.com
    http://betav.com/blog/billva
    http://www.hitchhikerguides.net

    “Hitchhiker’s Guide to Visual Studio and SQL Server (7th Edition)”

    Please click the Mark as Answer button if a post solves your problem!

    • Proposed as answer by Challen Fu Sunday, March 27, 2011 2:58 AM
    • Marked as answer by c_manboy Monday, March 28, 2011 7:54 PM
    Tuesday, March 22, 2011 8:37 PM

All replies

  • You can configure a deployment of SQL Server Reporting Services to work with a deployment of Microsoft SharePoint Foundation 2010 or Microsoft SharePoint Server 2010. You must perform configuration steps on both a report server and a deployment of the SharePoint product before users can publish reporting documents to SharePoint libraries and get report viewing and management services on SharePoint sites. The configuration process establishes server connection information; therefore, it is important that you follow the steps in order

    more about topic please visit here http://msdn.microsoft.com/en-us/library/bb326356.aspx

    • Proposed as answer by ErockP3 Wednesday, August 31, 2016 10:21 PM
    Tuesday, March 22, 2011 8:27 PM
  • You can't count me as a fan of SharePoint Services. For unsophisticated IT organizations, IMHO it's far too complex. I've discussed these issues with many SharePoint experts and they (for the most part) agree that there are far too many options and issues to make it easy to administer or for end-users to access the reports consistently.

    I would stick with your Report Manager or custom application (built around the ReportViewer control).


    __________________________________________________________________
    William Vaughn
    Mentor, Consultant, Trainer, MVP
    http://betav.com
    http://betav.com/blog/billva
    http://www.hitchhikerguides.net

    “Hitchhiker’s Guide to Visual Studio and SQL Server (7th Edition)”

    Please click the Mark as Answer button if a post solves your problem!

    • Proposed as answer by Challen Fu Sunday, March 27, 2011 2:58 AM
    • Marked as answer by c_manboy Monday, March 28, 2011 7:54 PM
    Tuesday, March 22, 2011 8:37 PM