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

Last Updated on Tuesday, 11 December 2012 08:53 Written by David Bauernschmidt Tuesday, 11 December 2012 12:00

If you have been following along in Part 1 you know that by now you will have a web service ready to be consumed in your project. Let’s continue on with this example and create a report that is hosted at Arvixe. (Concepts apply to most vendors). One thing to keep in mind with Arvixe this that testing your code report link is different than when you deploy it. I will get to that in a minute but let’s continue on.

Right click on your project and select ..”Add New Item” (figure 1)

Figure 1

Select Generic Handler and name the file something like ….”SSRS.ashx

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

Last Updated on Wednesday, 5 December 2012 07:42 Written by David Bauernschmidt Friday, 7 December 2012 12:00

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.)