Integration of SSRS with ASP.Net Web Application

Views:
 
     
 

Presentation Description

SSRS comes bundled with Microsoft SQL Server services. It provides immense benefit in terms of reducing the complexity for the reports which are extremely customized as well as are dealing with a very large volume of data.With fast evolving technology it is time to implement latest Microsoft technologies for your business.

Comments

Presentation Transcript

slide 1:

SQL Server Reporting Services SSRS is a server based report generator software of Microsoft. It serves to make send and oversee reports utilizing programming language like C and Visual Basic. SSRS comes bundled with Microsoft SQL Server services. It provides immense benefit in terms of reducing the complexity for the reports which are extremely customized as well as are dealing with a very large volume of data. Following are the steps to integrate SSRS web service 2010 with the C web application by creating the web service proxy class using Web Services Description Language WSDL STEP 1: Create a Visual studio 2012 Web application say MySSRSWebPortal. STEP 2: Open “Developer command prompt for VS2012” https://msdn.microsoft.com/en-us/library/reportservice2010.reportingservice2010.aspx

slide 2:

Fig.2.0 Go to the project root. Let say: D MySSRSWebPortalMySSRSWebPortal Execute below command: wsdl /language:CS /n:”Microsoft.SqlServer.ReportingServices2010″ http://Server Name/ReportServer/reportservice2010.asmxwsdl Incase you receive the following Error : The request failed with HTTP status 401: Unauthorized. Now create the web proxy for report server 2010 use the wsdl command to create this proxy class https://msdn.microsoft.com/en-us/library/7h3ystb6VS.80.aspx

slide 3:

It means you are required to pass the authentication parameter with the command: wsdl /language:CS /n:”Microsoft.SqlServer.ReportingServices2010″ /U:”User name” /p:”PassWord” http://Server Name/ReportServer/reportservice2010.asmxwsdl After executing this command ReportingService2010.cs file is created on the root folder Microsoft R Web Services Description Language Utility Microsoft R .NET Framework Version 4.0.30319.17929 Copyright C Microsoft Corporation. All rights reserved. Writing file ‘ D MySSRSWebPortalMySSRSWebPortalReportingService2010.cs‘. STEP 3: Add this file to the application. You will be able to see all the properties and methods for reporting service 2010 in this generated file. For more information about the reporting service 2010 methods and properties visit following link: https://msdn.microsoft.com/en-us/library/reportservice2010.reportingservice2010.aspx

slide 4:

Fig.3.0 STEP 4 Now list all the reports on the server. Create one aspx page let say Index.aspx Now to get the list of reports from the server the ReportingService2010 have “ListChildren” method they give all the reports from the folder specified in the parameter. Now on page load create the reporting service object set the network Credentials and call the method it will return the collection of catalog items. Create one repeater and bind with the collection.

slide 5:

Fig.4.0

slide 6:

Fig.4.0.1 STEP 4.1 Now if reporting server required the authentication then you have some change in code. Create one class let say ReportServerCredentials that inherit IReportServerCredentials interface add Microsoft.Reporting.WebForms reference. Interface have two properties: 1 ImpersonationUser : We don’t require this property so Set Return NULL 2 NetworkCredentials : Set network credential for reporting service.

slide 7:

Fig.4.1 STEP 4.2: Also interface have one method: GetFormsCredentials: we didn’t use this method. Fig.4.2 In Fig 4.0.1 replace service.Credentials System.Net.CredentialCache.DefaultNetworkCredentials To ReportServerCredentials reportServerCredentials new ReportServerCredentials service.Credentials reportServerCredentials.NetworkCredentials

slide 8:

STEP 5 Run the index.aspx page. You can see the list of reports name. Success Microsoft supplements its social database engine SQL Server with a few extra administrations that oversee diverse parts of big business knowledge and data handling for example information coordination reporting and analysis. While SQL Server can work freely of these administrations they include esteem by improving SQL Server’s ability as a hearty data stage for creating far reaching business insight arrangements. In subsequent series we will be covering further customized advanced implementation of SSRS. With fast evolving technology it is time to implement latest Microsoft technologies for your business.

authorStream Live Help