Step By Step SSRS in 11 Hours: Hour 11

Introduction

In this article, we will see how to integrate an RDL file in ASP.Net using ReportViewer.

Contents

• Hour 1: What is SSRS and determine whether it is installed
• Hour 2: Report using wizard
• Hour 3: First SSRS report
• Hour 4: Report with parameter
• Hour 5: Custom template
• Hour 6: Drill down report
• Hour 7: Subreport
• Hour 8: Report with style
• Hour 9: Report with chart
• Hour 10: Report Deployment
• Hour 11: RDL file to ASP.Net

RDL file to ASP.Net

Step 1

• Click on the "Start" button
• Go to "All Programs"
• Expand "Visual Studio 2012"
• Click on "Visual Studio 2012"
  

Step 2. Click on "File", expand "New" and click on "Web Site…".

Step 3. Select "ASP.NET Empty Web Site" in Visual C#.

Provide a good name for the website.

Step 4. Right-click on "SSRSWeb", select Add >> Add ASP.NET Folder >> App_Code.

Step 5. Right-click on "SSRSWeb", and select Add >> Add ASP.NET Folder >> Bin.

Step 6. Right-click on "SSRSWeb", and select Add >> Add New Item.

Step 7. Select "Web Form" and provide a name for it.

Step 8. Now right-click on "Bin" and click on "Add Reference".

Step 9. In Extensions, select "Microsoft.ReportViewer.WebForms" and press the "OK" button.

Step 10. Add a class inside App_Code, right-click on "App_Code" and select "Add" >> "Add New Item…".

Step 11. Select "Class" and provide it the name "ReportCredentials".

Step 12. This class is used to get and set the report credentials.

Step 13. Inherit "IReportServerCredentials" using the namespace "Microsoft.Reporting.WebForms".

Step 14. Create a parameterized constructor to set the credentials and also create a method to get those details.

Step 15. Open "Default.aspx", and drag and drop a "ReportViewer" from the toolbox under "Reporting".

Step 16. It will add a ReportViewer control to the aspx page and also register an assembly on the top of the page.

Step 17. Jump to "Default.aspx.cs" and implement the following code snippet.

Here we set the credentials, ProcessingMode, ReportServerUrl, and ReportPath.

Step 18. Now run the website and it asks for the ScriptManager.

Step 19. Add the ScriptManager from the toolbox under "AJAX Extensions" inside the form element in Default.aspx.

Step 20. Now run the website again.

Step 21. It asks us to register the web control inside the web. config under HTTP Handler.

Step 22. Copy the details from the preceding error and paste them under HttpHandler inside the web. config.

Step 23. Now run the website and we can see the report in Default.aspx using the Report Viewer.