Reporting services 2008 report builder 2.0


  • Hi,


    I have got reporting services 2005 (default instance - http://localhost/ReportServer ) and reporting services 2008 (configured using report server configuration manager 2008 - http://localhost:8080/ReportServer_SQL2008/ReportService2006.asmx ).


    I have got VS 2008 SP1, SQL Server 2008 and Report Builder 2008 2.0.

    I created a report using report builder 2.0 and deployed it on report server 2008.


    I created a C# console application in order to change query sql (let's say by changing where clause) for that report programmatically:


    using System;

    using System.Collections.Generic;

    using System.Linq;

    using System.Text;

    using System.Web.Services.Protocols;

    using SSRS2008ReportBuilder.SSRS2008;


    namespace SSRS2008ReportBuilder


    class Program


    static void Main(string[] args)


    SSRS2008ReportBuilder.SSRS2008.ReportingService2006 rs = new ReportingService2006();

    rs.Credentials = System.Net.CredentialCache.DefaultCredentials;

    Property name = new Property();

    name.Name = "Name";

    Property description = new Property();

    description.Name = "Description";

    Property[] properties = new Property[2];

    properties[0] = name;

    properties[1] = description;



    Property[] returnProperties = rs.GetProperties(

    "/foldername/Contractor", properties); //fails here


    foreach (Property p in returnProperties)


    Console.WriteLine(p.Name + ": " + p.Value);



    catch (Exception e)








    I set web reference SSRS2008ReportBuilder.SSRS2008 to http://localhost:8080/ReportServer_SQL2008/ReportService2006.asmx


    An error is generated

    "System.Web.Services.Protocols.SoapException: This operation is not supported on a report server that runs in native mode. ---> Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedNativeModeException: This operation is not supported on a report server that runs in native mode.\n   at Microsoft.ReportingServices.WebServer.WebServiceHelper.EnsureSharePointMode()\n   at Microsoft.ReportingServices.WebServer.ReportingService2006..ctor()"


    Both instances of report servers (2005 and 2008) configured to run in native mode - no sharepoint integration.


    Any ideas?


    Any links to object model for a report build using report builder.


    Tuesday, September 23, 2008 5:25 AM


All replies

  • For a native mode server, you'll want to use ReportService2005, not ReportService2006.


    • Proposed as answer by Rajni Kaushal Thursday, May 21, 2015 7:58 AM
    Tuesday, September 23, 2008 5:44 AM
  • I have got 2 instances of reporting services - one 2005 (default) and 2008.


    I want to deploy a report on 2008 instance and set programmatically query sql for a dataset in that report.


    ReportService2006 should point to 2008 instance.


    Tuesday, September 23, 2008 5:50 AM
  • The ReportService2006 endpoint is used when the server is in SharePoint-integrated mode.  In native mode, the ReportService2005 endpoint should be used.  Try connect to this URL instead:




    Tuesday, September 23, 2008 5:58 AM
  • I am also attempting to programmatically set/change the query for a dataset in a report prior to generating a snapshot, without having to grab the entire rdl definition changing the definition in a temp rdl and setting that back on the server. Please let me know if you resolve this I am getting the same error, and maybe switching to sharepoint integrated mode is the answer but I am looking for a better answer.

    Thursday, July 2, 2009 4:40 PM