This article is a part 7 of series of article on SQL Server Reporting Services. This will help you to get started with SQL Server Reporting Services (SSRS).
- Getting Started with SSRS – Part 1 – SQL Server Reporting Services Overview and Installing in Windows Server 2008
- Getting Started with SSRS – Part 2 – Designing a report using Report Wizard
- Getting Started with SSRS – Part 3 – Designing a report using Report Designer [more]
- Getting Started with SSRS – Part 4 – Configuring SQL Server Reporting Services in Windows Server 2008
- Getting Started with SSRS – Part 5 – Deploying a report to the Server
- Getting Started with SSRS - Part 6 – Creating Deleting and Moving a folder in SSRS Server
- Getting Started with SSRS - Part 7 – User Roles and Permissions in SSRS Server
- Getting Started with SSRS - Part 8 – Show SSRS Report in ASP.NET Web Page
- Getting Started with SSRS - Part 9 – Creating Matrix Report with inbuilt styles in SSRS
- Getting Started with SSRS – Part 10 – Creating a Report with Charts and Gauges
In this article, we will cover how to use the deployed SSRS Report on to the ASP.NET Web application. In our earlier articles we have seen the steps to create and deploy the report to the Reporting Server and administer the deployed reports. In real time, we have seen requirements on accessing the reports from different clients. Let us now move ahead for the step-by-step process on accessing the SSRS report in ASP.NET web pages dynamically.
Before starting the steps to show the SSRS Report in ASP.NET Page, we should just have a look around on the previous articles to get some fair idea on how to design the report and deploy it to the Report Server.
First, open visual studio 2010 IDE and create a new ASP.NET Project as shown in the screen below. In this example we are going to use the report which we deployed in the Part 2 of this series of articles on SSRS.