none
Reporting services 2008 report builder 2.0

    Question

  • 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;

    try

    {

    Property[] returnProperties = rs.GetProperties(

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

     

    foreach (Property p in returnProperties)

    {

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

    }

    }

    catch (Exception e)

    {

    Console.WriteLine(e.Message);

    }

    }

    }

    }

     

    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

Answers

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
    Moderator
  • 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:

     

    http://localhost:8080/ReportServer_SQL2008/ReportService2005.asmx

     

    Tuesday, September 23, 2008 5:58 AM
    Moderator
  • 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 mmcgowa3@hotmail.com. 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