Example of using SSRS SOAP API

This example uses adventure works sample  database and reports, please refer to books on line for setup instructions.

1.       Open Visual Studio and create a console application (VB or C#)

2.       Replace the code in Module.vb or Module.cs with the appropriate code snippet

a.       C#

using System;

using SoapAPI.ReportService2005;

 

class Module1

{

 

         public void Main()

         {

                 ReportingService2005 rs = new ReportingService2005();

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

 

                 rs.Url = "http://Localhost/reportserver/reportservice2005.asmx";

 

                 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("/AdventureWorks Sample Reports/Company Sales", properties);

                          Property p;

                          foreach ( p in returnProperties) {

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

                          }

                 }

 

                 catch (Exception e) {

                          Console.WriteLine(e.Message);

                 }

                 finally {

                          Console.ReadLine();

                 }

         }

 

}

b.      VB

Imports System

Imports SoapAPI.ReportService2005

 

Module Module1

 

    Sub Main()

        Dim rs As New ReportingService2005

        rs.Credentials = System.Net.CredentialCache.DefaultCredentials

 

        rs.Url = "http://Localhost/reportserver/reportservice2005.asmx"

 

        Dim name As New [Property]

        name.Name = "Name"

 

        Dim description As New [Property]

        description.Name = "Description"

 

        Dim properties(1) As [Property]

        properties(0) = name

        properties(1) = description

        Try

            Dim returnProperties As [Property]() = rs.GetProperties("/AdventureWorks Sample Reports/Company Sales", properties)

            Dim p As [Property]

            For Each p In returnProperties

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

            Next p

 

        Catch e As Exception

            Console.WriteLine(e.Message)

        Finally

            Console.ReadLine()

        End Try

    End Sub

 

End Module

3.       Run the application

Comments

# re: Example of using SSRS SOAP API
Gravatar Thanks for sharing this coding with us.
Left by online psychology masters degree on 5/30/2009 9:54 AM
# re: Example of using SSRS SOAP API
Gravatar There are only 50 copies but i'm sure that not all of the 1st 50 will show up on time with a computer to do the installation.
Left by occupational safety training on 5/30/2009 9:55 AM
# re: Example of using SSRS SOAP API
Gravatar its great.
Left by biology degree on 5/30/2009 9:56 AM
# re: Example of using SSRS SOAP API
Gravatar i think this would be more helpful
<BeginStoryboard>
<Storyboard>
<PointAnimation
Storyboard.TargetName="MyEllipseGeometry"
Storyboard.TargetProperty="Center"
From="150,100" To="650,200" Duration="0:0:3"
RepeatBehavior="Forever" AutoReverse="True"/>
</Storyboard>
</BeginStoryboard>
Left by biology degree on 5/30/2009 9:56 AM
# re: Example of using SSRS SOAP API
Gravatar <TextBlock.Foreground>
<LinearGradientBrush>
<LinearGradientBrush.GradientStops>
<GradientStop Offset="0" Color="Yellow" />
<GradientStop Offset="1" Color="Red" />
</LinearGradientBrush.GradientStops>
</LinearGradientBrush>
</TextBlock.Foreground>

<TextBlock.Background>
<VisualBrush>
<VisualBrush.Visual>
<MediaElement Source="C:\\apollo11_launchclip04.mpg" />
</VisualBrush.Visual>
</VisualBrush>
</TextBlock.Background>

</TextBlock>
Left by online science degree programs on 5/30/2009 10:01 AM
# re: Example of using SSRS SOAP API
Gravatar <ControlTemplate.Triggers>
<Trigger Property="IsSelected" Value="True">
<Setter Property="Opacity" Value="1.0" />
</Trigger>
</ControlTemplate.Triggers>
</ControlTemplate>
</Setter.Value>
</Setter>
<Style.Triggers>
Left by law degree on 5/30/2009 10:01 AM
# using SSRS SOAP API
Gravatar Well well well, what do we have here?
Left by regcure on 6/14/2009 2:49 PM
# re: Example of using SSRS SOAP API
Gravatar i like asp.net and c# ,good
Left by darkfall gold on 6/22/2009 12:41 AM

Leave Your Comment

Title*
Name*
Email (never displayed)
 (will show your gravatar)
Url
Comment*

Preview Your Comment.