SSRS Report in ASP.NET Example

Following steps are given to create a SSRS(RDLC) Report in ASP.NET

1)      Create table "UserList" in Database

2)      Create Connection String in Web.Config

<connectionStrings>

    <add name="constr" connectionString="<Databaseconnection>" ProviderName="System.Data.SqlClient"/>

</connectionStrings>

3)      Add httphandler to web.config.

<system.web>

    <httpHandlers>

      <add path="Reserved.ReportViewerWebControl.axd" verb="*"

      type="Microsoft.Reporting.WebForms.HttpHandler,

      Microsoft.ReportViewer.WebForms, Version=10.0.0.0,

      Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" validate="false"

      />

    </httpHandlers>

</system.web>

<system.webServer>

    <handlers>

      <add name="ReportViewerWebControlHandler"

      preCondition="integratedMode"

      verb="*" path="Reserved.ReportViewerWebControl.axd"

      type="Microsoft.Reporting.WebForms.HttpHandler,

      Microsoft.ReportViewer.WebForms, Version=10.0.0.0,

      Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"

      />

    </handlers>

  </system.webServer>

4)      Create empty ASP.NET Application.

5)      Crate Report Folder, Named it “Reports”

6)      Add SSRS Report(.rdlc) in report folder, Named it “MyReport”.

7)      Add Dataset (.xsd) in report folder, Named it “MyReportUser”.

8)      Design Dataset (add Datatable and add column in datatable as same in SQL Table.

9)      Open Myreport.rdlc file and add DataSet “MyReportUser” in Report Data Section.

10)   Design report as per your requirement.

11)   Add script manager and report viewer to aspx page as shown below:

<form id="form1" runat="server">

    <asp:ScriptManager runat="server">

    </asp:ScriptManager>

    <div>

    <rsweb:ReportViewer Width="100%" ShowToolBar="false" ID="rptvMyReport" runat="server">

    </rsweb:ReportViewer>

    </div>

    </form>

12) Add following namespaces

using System.Configuration;

using System.Data;

using System.Data.SqlClient;

using Microsoft.Reporting.WebForms;

using SSRSReportExample.Reports; //To Access Reports folder Dataset

13) Add to Code Behind

string str = ConfigurationManager.ConnectionStrings["constr"].ToString();

        DataSet ds;

        protected void Page_Load(object sender, EventArgs e)

        {

            if (!IsPostBack)

            {

                getUserList();//Call report at page load

            }

        }

        private void getUserList()

        {

            SqlConnection con = new SqlConnection();//Create SQL Connection Object

            MyReportUser dsUserList = new MyReportUser();//Create DataSet Object

            try

            {

                con.ConnectionString = str;

                SqlDataAdapter sda = new SqlDataAdapter("select * from UserList", con);

                con.Open();

               

                sda.Fill(dsUserList, "UserList");//bind data to DataSet

                if (dsUserList.Tables[0].Rows.Count > 0)//if bind is successfull then execute

                {

                    rptvMyReport.ProcessingMode = ProcessingMode.Local;

                    rptvMyReport.LocalReport.ReportPath = Server.MapPath("~/Reports/MyReport.rdlc");

                    rptvMyReport.LocalReport.DataSources.Clear();//Clear previous applied Datasource

                    ReportDataSource rptDataSource = new ReportDataSource("UserList", dsUserList.Tables[0]);//Create Report Datasource and add Dataset in it.

                    rptvMyReport.LocalReport.DataSources.Add(rptDataSource);

                }

            }

            catch { }

            finally { con.Close(); }

        }

14) Build your application and check the result.