Reports are integral part of any business solution. To show reports in an ASP.NET web page we can follow the below steps.
| 1. | Develop the SSRS using BIDS (Business Intelligence Development Studio) or Report builde or VS-2012.
|
| 2. | Deploy the SSRS report to the report server. |
| 3. | Create a web site project in Visual Studio. Open an ASP.NET page in design mode. |
| 4. | Add a Script Manager component from the Toolbox -> Ajax Extensions to the page. |
| 5. | Add a Report Viewer component from the Toolbox -> Reporting
|
| 6. | Select the Reportviewer Tasks and set following properties a. Choose Report = Server Report b. Report Server url = http://localservername/ReportServer c. Report Path = /ReportFolderName/ReportName, for example if my reports are in Sales folder and report name is productSale then Report Path is /Sales/productSale. Note we do not add report extension (.rdlc) with the report name. |
That is all you have to set in Visual Studio. Run the web project solution and you will see the reports are loaded on the ASP.NET page.
