Dynamic Crystal report

See more:

C#

ASP.NET

CrystalReports

HI everybody...

I need your help..

I'm new to crystal report. I'm doing a project in ASP.Net with c#.net as code behind. I want to create a report based on the dataset i created.

here the code i created.

SqlConnection cnn;
       string connectionString = null;
       string sql = null;
       connectionString = "Data Source=localhost\\sqlexpress;Initial Catalog=HRMDB; Integrated Security=True";
       cnn = new SqlConnection(connectionString);
       cnn.Open();
       sql = "select * from SettingsUsers";
       SqlDataAdapter dscmd = new SqlDataAdapter(sql, cnn);
       DataSet ds = new DataSet();
       dscmd.Fill(ds, "SettingsUsers");

     objRpt.Load(Server.MapPath(@"CrystalReport1.rpt"));
     objRpt.SetDataSource(ds.Tables[0]);
     CrystalReportViewer1.ReportSource = objRpt;
     CrystalReportViewer1.DataBind();

In the design ..i created CrystalReportViewer1 and added a CrystalReport1.rpt in the project.

But I'm not getting the output...please help...