Chapter-11 : Creating SSRS Report by consuming Web Service Data Source

SSRS Reports can be developed by consuming the data returned from Web Services. In this chapter we are going to see how it is done. The steps for the same is

Download Full Tutorial for Chapter-11-Creating-SSRS-Report-consuming-Web-Service-Data-Source



Download Source code for Chapter-11-Creating SSRS Report consuming Web Service Data Source

Step-1: Open the “BASICSSRS1” project of SSRS of Chapter-9 and create a new Shared Data source “WSDLDataSource” as shown in the image.

create a new Shared Data source “WSDLDataSource”
Create a new Shared Data source “WSDLDataSource”

Click on credential and set the credential to “Use Windows Authentication(Integrated security)” as shown in the image and click OK Button as Shared Data Source with name “WSDLDataSource” will be created.


set the credential to “Use Windows Authentication(Integrated security)”
Set the credential to “Use Windows Authentication(Integrated security)”

Step-2: Select the Data source “WSDLDataSource” for creating new report as shown in the image and click on next button

Select the Data source “WSDLDataSource”
Select the Data source “WSDLDataSource”

Paste the following query in the Query Box as shown in the image given below and click on next button

< Query >
< SoapAction >http://tempuri.org/GetCustomer< /SoapAction >
< Method Namespace=”http://tempuri.org/” Name=”GetCustomer” >< /Method >
< ElementPath IgnoreNamespaces=”true” >GetCustomerResponse{}/GetCustomerResult{}/diffgram{}/NewDataSet{}/CustomerData{CustomerID,CompanyName,ContactName,City,Country}< / ElementPath >
< /Query >

Paste the above code to Query Code Window
Paste the above code to Query Code Window

Choose Tabular Report as shown in the image and click next button


Select the Report Type
Select the Report Type

Now choose all the columns in the Details of the Report Wizard as show in the image

choose all the columns in the Details of the Report Wizard
Choose all the columns in the Details of the Report Wizard

And then choose the Layout design as shown and click on next

choose the Layout design
choose the Layout design

Write the name of Report as “WSDLReport” as shown in the Image and click finish button.

Write the name of Report as “WSDLReport”
Write the name of Report as “WSDLReport”

Desired Report will be Generated which will look like as screen given below. Change the Header as given and adjust the column width accordingly and preview the report to see the final output.

Change the Header as given and adjust the column width
Change the Header as given and adjust the column width

The Final Preview of the report using web services as data source in SSRS report

Final Preview of SSRS Report using WebService as data source
Final Preview of SSRS Report using WebService as data source

The final output will be as screen given below. This completes Chapter-11 : Creating SSRS Report by consuming Web Service Data Source”.



Chapter-1: Creating a basic Tabular SSRS Report using Report Wizard
Chapter-2 : Report Deployment on SQL Server 2012 Reporting Server
Chapter-3:Opening/Calling the deployed SQL Server Reporting Server report from Asp.net
Chapter-4 Creating SSRS Matrix Report / Cross Tab Report
Chapter-5 Creating a Sub Report in SSRS
Chapter-6: Creating a Drill Down Report in SSRS
Chapter-7: Working with expressions and custom code in SSRS
Chapter-8-SSRS (Reporting Services) Working with Calculated fields
Chapter-9-Sorting of Column and Custom Paging in SSRS
Chapter-10 : Creating and Deploying Web Services for SSRS

 

 

 

 

Leave a Reply

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

*

two × 2 =