Regarding Crystal Reports in Asp.net 2.0

[sravanthi29]

Hi,

I have a .aspx page and a crystal report named prernaweb.rpt.

.aspx page
Page_Load
{
CrystalDecisions.CrystalReports.Engine.ReportDocum ent crReportDocument = new CrystalDecisions.CrystalReports.Engine.ReportDocum ent();

crReportDocument.Load("d:\\webrptprerna\\prernaweb .rpt");
SqlConnection conn = new SqlConnection("Data Source=AS4;Initial Catalog=Prerna;User Id=sa");
DataSet ds = new DataSet();
SqlCommand cmd = new SqlCommand();
SqlDataAdapter da = new SqlDataAdapter();
conn.Open();
cmd.Connection = conn;
cmd.CommandText = "select * from view1";
da.SelectCommand = cmd;
da.Fill(ds, "view1");

crReportDocument.SetDataSource("view1");
Crystalreportviewer.ReportSource = crReportDocument;
Crystalreportviewer.DataBind();

}

I have called crystal report in .aspx page load. But I am unable to see the data when I run the web page.
I need sample code and help regarding this.

Thanks
Sravanthi

[dip_developer]

Hi,

I have a .aspx page and a crystal report named prernaweb.rpt.

.aspx page
Page_Load
{
CrystalDecisions.CrystalReports.Engine.ReportDocum ent crReportDocument = new CrystalDecisions.CrystalReports.Engine.ReportDocum ent();

crReportDocument.Load("d:\\webrptprerna\\prernaweb .rpt");
SqlConnection conn = new SqlConnection("Data Source=AS4;Initial Catalog=Prerna;User Id=sa");
DataSet ds = new DataSet();
SqlCommand cmd = new SqlCommand();
SqlDataAdapter da = new SqlDataAdapter();
conn.Open();
cmd.Connection = conn;
cmd.CommandText = "select * from view1";
da.SelectCommand = cmd;
da.Fill(ds, "view1");

crReportDocument.SetDataSource("view1");
Crystalreportviewer.ReportSource = crReportDocument;
Crystalreportviewer.DataBind();

}

I have called crystal report in .aspx page load. But I am unable to see the data when I run the web page.
I need sample code and help regarding this.

Thanks
Sravanthi

I recommend you to change only one line
crReportDocument.SetDataSource("ds");

lets see what happens....