SQL Server 2008 Reporting Services Configuration Step By Step Image

Image 00

Image 01

Image 02

Image 03

Image 04

Image 05

Image 06

Image 07

Image 08

Image 09


SQL Server Reporting Services 2008

SQL Server Reporting Services 2008

To Understand SQL Server Reporting Service check  below link


Above Link Gives Conceptual Information about SQL Reporting Services 2008.


To Develop SQL server Report Please Download Following Tool


Tool is only use for simplification to develop an application otherwise we can also use inbuilt repot

Visual Studio 2008

Business intelligence Projects

-> Report Project

After Developing report we need to attach report in Asp.net .

For that we need Report Viewer Control.


To Download Microsoft Report Viewer


And Add After Installing this Report Viewer Control Add reference  in web application and then Drag and Drop that Control on  Webpage,


Above all steps needed to Develop and attach report in Application, but the main thing is ti Configure reporting service in SQL Server.

To configure SQL Server Report Server follow below Link


Once the Report is Developed and Uploaded in Server we need to attached that Report in Application From Code

Sample Code to load RDL File From server

Import Namespace

using Microsoft.Reporting.WebForms;

ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;

ReportViewer1.ServerReport.ReportServerUrl =

new Uri(“”);

ReportViewer1.ServerReport.ReportPath = “/Employee”;

ReportParameter[] Params = new ReportParameter[1];

Params[0] = new ReportParameter(“EmpId”, txtEmpId.Text.ToString());


ReportViewer1.ShowParameterPrompts = false;




Demo Video From Microsoft Site Can be seen from link