locked
SharePoint Integration Mode (SQL server Reporting Services) - Report Deployment Process RRS feed

  • Question

  • Hi,

    I have SSRS running in SharePoint integration mode. I have 45 sites where i have to deploy a report (RDL) with different parameter. I am using a central location for all reports (RDLs) and using "Manage Copies" option to deploy reports to 45 sites.

    Problem:

    1. After deployment i have to RE-setup parameters manually for each report. (45 times)

    2. After deployment i have to RE-setup datasource for each report. (45 time)

    It takes very long to deploy or update the report.I tried to use SSRS webservice to build a tiny application which will take the location of report and automatically deploy it across as well as will setup datasource and parameters but my try failed as the use of SSRS API is not allowed when running in SharePoint integration mode.

    Is there any alternate?

    Help is appreciated.

    Best regards


    SharePoint 2007 (Administration/Development) | Web developer and .NET DTS Programmer | .NET Framework 2.0/3.5 | SQL Server 2008/2005/2k

    Thursday, October 3, 2013 12:31 AM

All replies

  • P.S

    I am running SharePoint 2007 with SSRS 2005


    SharePoint 2007 (Administration/Development) | Web developer and .NET DTS Programmer | .NET Framework 2.0/3.5 | SQL Server 2008/2005/2k

    Thursday, October 3, 2013 12:32 AM
  • more than 50 views and no reply, is this question tooo hard to answer :)

    SharePoint 2007 (Administration/Development) | Web developer and .NET DTS Programmer | .NET Framework 2.0/3.5 | SQL Server 2008/2005/2k


    • Edited by aliusman Friday, October 4, 2013 6:14 AM
    Friday, October 4, 2013 6:14 AM