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

  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati

Print | posted on Wednesday, June 20, 2007 9:39 PM

Comments on this post

# wow gold

Requesting Gravatar...
A localwow gold museum closed its doors eleven months ago for a renovation.
Left by rain1000 on Nov 19, 2008 10:33 PM

# re: Example of using SSRS SOAP API

Requesting Gravatar...
It was a very nice idea! Just wanna say thank you for the information you have shared. Just continue writing this kind of

post. I will be your loyal reader. Thanks again.


:)
Left by tiffany on Jul 12, 2009 8:04 PM

# re: Example of using SSRS SOAP API

Left by car insurance on Dec 17, 2009 12:20 AM

# re: Example of using SSRS SOAP API

Requesting Gravatar...
Where would you recommend online as the best resource for setup instructions, or would purchasing a book be better.
Left by Beadalon on Jan 11, 2010 5:16 AM

# re: Example of using SSRS SOAP API

Requesting Gravatar...
After reading your post.., I remember a song entitled "The way we were" Great post..
Left by Aaron on Jan 12, 2010 2:06 AM

# re: Example of using SSRS SOAP API

Requesting Gravatar...
The successful implementation of the above requires installation of IBM DB2 development client version 8 and above with the same version of gateway.This driver must be added using the Visual Studio Addins. After this is done the driver appears in the list of drivers in .Net and SSRS.
Left by meilleurs casinos on Feb 18, 2010 4:19 AM

# re: Example of using SSRS SOAP API

Requesting Gravatar...
if you any more applications please share here
Left by los angeles attorneys on Apr 30, 2010 2:07 AM

# Mrs

Requesting Gravatar...
i have never seen people using the api.what operation does it hold?
Left by Miami Lawyers on May 01, 2010 9:40 PM

# re: Example of using SSRS SOAP API

Requesting Gravatar...
I've looked around quite a bit, but I can't seem find a guide on how to get access to the API. The "using SoapAPI.ReportService2005;" doesn't work for me. I tried import both using ReportExecution2005.asmx?wsdl and ReportService2005.asmx?wsdl as both Web Reference and Service Reference, but I keep on getting error messages on not finding the references in the code.
Got any hints?
Left by Rickard on Jun 10, 2010 6:20 AM

# re: Example of using SSRS SOAP API

Requesting Gravatar...
Though I would've loved it much more if you added a relevant video or at least pictures to back up the explanation, I still thought that your write-up quite helpful.
It's usually hard to make a complicated matter seem very easy.
I enjoy your weblog and will sign up to your feed so I will not miss anything. Fantastic content.
Left by raft wars on Jul 28, 2010 12:01 AM

# re: Example of using SSRS SOAP API

Requesting Gravatar...
Very good information, thank you very much by the article and the quality of your Web site.
Left by Used Cars for Sale on Jul 28, 2010 12:03 AM

# re: Example of using SSRS SOAP API

Requesting Gravatar...
It looks good,I have learn a recruit!Recently,I found an excellent online store, the XX are completely various, good quality and cheap price,it’s worth buying!
Left by Infertility Doctors in New Jerse on Jul 30, 2010 3:18 AM

# re: Example of using SSRS SOAP API

Requesting Gravatar...
I have been reading up on this topic and this is one of the more informative articles. Do you have other information I can refer to?
Left by buy nexium online on Dec 28, 2010 12:51 PM

# re: Example of using SSRS SOAP API

Requesting Gravatar...
Interesting post and thanks for sharing. Some things in here I have not thought about before.Thanks for making such a cool post which is really very well written.will be referring a lot of friends about this.Keep blogging
Left by fake university degrees on Jan 27, 2011 8:37 AM

# re: Example of using SSRS SOAP API

Requesting Gravatar...
Cool! Author the best! Thank you!
Left by uk essay writing on Mar 26, 2011 11:36 AM

# re: Example of using SSRS SOAP API

Requesting Gravatar...
This is first time i am visiting on this post and this post is very nice thanks for sharing such a wonderful post with us...
Left by cascos motos on Apr 16, 2011 8:13 AM

# re: Example of using SSRS SOAP API

Requesting Gravatar...
Great Post. Thank you for your explanation!!!!
Left by cirugia estetica barcelona on Apr 20, 2011 5:45 AM

# re: Example of using SSRS SOAP API

Requesting Gravatar...
I dont want to go back
Left by Research Paper Help on Apr 26, 2011 8:36 PM

# re: Example of using SSRS SOAP API

Requesting Gravatar...
Wow i like this site very much thanks for sharing such a wonderful site with us..This was actually what i was looking for..
Left by Naranjas on May 13, 2011 1:49 AM

# cuteamisha ;)

Requesting Gravatar...
Thanks for everything you do on this blog.
Left by flowers delivery switzerland on May 25, 2011 4:45 AM

# re: Example of using SSRS SOAP API

Requesting Gravatar...
Very interesting article is a very modern, I loved your blog.
Left by Venta de Muebles on Jun 09, 2011 1:10 PM

# re: Example of using SSRS SOAP API

Requesting Gravatar...
you can maximize, restore or dock the active window simply by dragging it to the top or sides, or just grab any window by its title bar shake it a bit and it automatically will minimize all the other mobile live chat windows, call me a geek but I think this is really cool.
Left by dolores on Jun 12, 2011 10:04 AM

# re: Example of using SSRS SOAP API

Requesting Gravatar...
Thanks for your blog, you are very interesting topics and modern, I love your blog.
Left by Hoteles en Valencia on Jul 05, 2011 10:27 AM

# re: Example of using SSRS SOAP API

Requesting Gravatar...
The information in your blog is very interesting and modern, I love your blog.
Left by Hostel Valencia on Jul 15, 2011 6:26 PM

# re: Example of using SSRS SOAP API

Requesting Gravatar...
Your blog has very good information, I think you have very good songs.
Left by Dormitorios Infantiles on Jul 19, 2011 8:35 AM

# re: Example of using SSRS SOAP API

Requesting Gravatar...
I love life so much, and people who can be so amazing, passion, love, greatness, and wonderful people Projekty Domów
we will love each other mutually
Left by Kolektory Sloneczne on Sep 21, 2011 11:11 AM

# re: Example of using SSRS SOAP A

Requesting Gravatar...
Awesome blog, some very nice code here :-)

Assignment writing services
Left by Assignment writing service on Sep 29, 2011 4:25 AM

# re: Example of using SSRS SOAP API

Requesting Gravatar...
amazing things are that we nowadays do not need to really understand everything, or even become the world authority at everything to achieve breakthrough success. But we need top quality people around us. Ryszard
Thanks chap
Left by Projekty Domów on Oct 03, 2011 2:07 PM

# re: Example of using SSRS SOAP API

Requesting Gravatar...
Where do you come up with this stuff? Amazing!
Left by cerebral palsy history on Nov 17, 2011 2:17 PM

Your comment:

 (will show your gravatar)