HOW TO VIEW REPORTS IN C# USING MICROSOFT REPORT VIEWER??

mohan kumar

Total Post:10

Points:70
Posted by  mohan kumar
C# 
C#
 5218  View(s)
Ratings:
Rate this:
This is my code. I cant able to load the reports in my page.

 public void loadReports()
    {
        conn.open( );
        string strQry="SELECT Empid,Empname,location,Mobile,Pincode,Salary FROM Employee";
        DataTable dt = new DataTable();
        ReportViewer1.ShowBackButton = true;
        ReportViewer1.ShowPrintButton = true;
        ReportViewer1.ShowRefreshButton = true;
        //string strConn = System.Configuration.ConfigurationManager.AppSettings["ConnectionString"];
        SqlDataAdapter adp = new SqlDataAdapter(strQry,conn);
        adp.Fill(dt);
        this.ReportViewer1.Visible = true;
        this.ReportViewer1.LocalReport.ReportPath = "Report1.rdlc";
        ReportDataSource RDS = new ReportDataSource();
        RDS.Value = SqlData;
        this.ReportViewer1.LocalReport.DataSources.Add(RDS);
        ReportViewer1.DataBind();
        conn.close( );
               
    }

and my Default.aspx code is

<div>
        <rsweb:ReportViewer ID="ReportViewer1" runat="server" ProcessingMode="Remote">
        <LocalReport ReportPath="Report1.rdlc">
            <DataSources>
                <rsweb:ReportDataSource DataSourceId="SqlData" />
            </DataSources>
        </LocalReport>
        </rsweb:ReportViewer>
        <asp:SqlDataSource ID="SqlData" runat="server"
            ConnectionString="<%$ ConnectionStrings:masterConnectionString2 %>"
            SelectCommand="SELECT [Empid], [Empname], [location], [Mobile], [Pincode], [Salary] FROM [Employee]">
       
        </asp:SqlDataSource>
    </div>

Please try to find errors why i can't able to load reports using the above code. When the above code is run,only white page appears.

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!