Creating PDF (or any other file type) from SQL Reporting Services using .WSDL (VS2012) Part 1

Over the years I have built several SSRS (SQL Server Reporting Services) reports. Many of them have been designed, created, and deployed inside the standard SSRS folders structure. However; a couple of years ago I had a client wanting to access the report while inside a web application. They didn’t want to leave the application to run the report and they wanted it to look and feel as part of the application.

At first the request did not seem that difficult, after all Arvixe has all of this technology and it seemed to be straight forward. Just start a new project, add a new reference, and start coding, Right? However; I should have known that when things seem simple there is always a fly in the ointment. The next couple of articles will take you from beginning to end in using a reporting services .wsdl to generate reports from within a web application. (I will not go over the actual creation of the report.)

In preparation of this tutorial I started to use Visual Studio 2012 and once again thought that everything was the same as Visual Studio 2005/2008. Guess what? Not so fast. I had a problem creating a .wsdl from adding a reference inside VS2012. Some of these “catchas” might be related to OE (Operator Error) but I figured I cannot be the only one with challenges (or maybe I am).

I don’t know exactly how many articles to this tutorial there will be, but I can tell you that it will be more than one article. Let’s roll up our sleeves, dive into this lesson and remove all flies. One other quick note, I will also go down a few rabbit trails where I had problems just in case you end up the same place. If you find a step too confusing or in need of better clarification let me know.

Step 1: Launch Visual Studio 2012

Step 2: Click on ‘File’ and select New Blank Web Site (Figure 1)

Step 3: Enter Web Site Name -> ‘SSRS Sample’ (Figure 1)


Figure 1

Step 4: Right Click on Web Site

Step 5: Select “Add Service Reference” (Figure 2)


Figure 2

Step 6: Select Advanced (Bottom Left button) (Figure 3)


Figure 3

Step 7: Select Add Web Reference (Bottom Left button) (Figure 4)


Figure 4

Step 8: Enter the Web Service Reference for Reporting Service location. (Figure 5)


 

Step 9: Enter the Web Service Reference for Reporting Service location. (Figure 6)


Figure 6
It may prompt for a login and password.
After entering it, and waiting for 60 seconds
you might get an error.(See Figure 7)
Figure 7
Value cannot be null
Parameter name:realm
 Note:
After spending hours looking for a solution and not finding it I then tried to
go to a browser and enter the same URL in.
It prompted me for my security credentials
and then it produced a screen like Figure 8. I then saved it as
ReportExecution2005.XML file and repeated steps 5-7.
 
Figure 8

Step 10: I Entered the location of my saved file and clicked process.(Figure 9)


Figure 9
Note:
If everything goes well it should allow you to
enter in the web reference name.

Step 11: If you host with Arvixe then it should be something like XXX.arvixe.com(Figure 10)



Figure 10

Step 12: Click Add Reference(Figure 10)


Finished!!!!

You should see the web reference added in your web site folder tree.
You can check your web.config and see that it added an entry under the appsettings xml tag. It is important that you see this because you will change this when you deploy to Arvixe.
Looking for quality ASP.NET Hosting? Look no further than Arvixe Web Hosting!
Tags: , , , , , , | Posted under ASP .NET 3.5 | RSS 2.0

Author Spotlight

David Bauernschmidt

David Bauernschmidt

I live in the historical triangle of Virginia where I am married with two daughters. I have spent over 13 years working for a Fortune 500 company in the computer area. I started in VB 6.0 and by the time I ended my employment I was supervising a development team where we built many web applications. When my first daughter was born I wanted to spend more time with her so I left and became a programmer analyst for local government as well as launch my own company. Since then I have grown James River Webs into a profitable web design and application company helping small businesses create a big presence on the internet. As an employee I have created web application used by citizens and other companies. I enjoy fly fishing, and spending time with my family. I also enjoy learning new approaches and development tools when it comes to developing applications.

Leave a Reply

Your email address will not be published. Required fields are marked *


9 + 8 =

You may use these HTML tags and attributes: <a href="" title="" rel=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>