Problem with Sap Crystal Report in VS 2012

Question

Hi everyone!

when i fetch records from database and bind dataset....

dataset contain records but not showing in sap crystal report on vs 2012

not arise any error........... but not showing cry rpt.
can anyone help me ?

Sanjay Kumar · Answer

Hi try this ReportDocument rpt = new ReportDocument(); rpt.Load(Server.MapPath(~/CrystalReport.rpt)); rpt.SetDataSource(dt); CrystalReportViewer1.ReportSource = rpt; CrystalReportViewer1.DataBind(); CrystalReportViewer1.RefreshReport();

Ravi Kumar · Answer

try the fallowing con.open(); da = new SqlDataAdapter(select top 20 [DIST_NM][YEAR_NM][SCM_NM][HEAD_NM][ARG_AREA] from VIEW_LANDUSES_DTLS con); ds = new DataSet(); da.Fill(dt); CrystalReport rd = new CrystalReport (); rd.Load(@\Reports\CrystalReport.rpt)); rd.SetDataSource( dt ); CrystalReportViewer1.ReportSource = rd; con.Close();

Niranjan Poddar · Answer

records comming but not display crystal report...............

Ravi Kumar · Answer

change the fallowing rd.SetDataSource(dsl.Tables[0]); replace rd.SetDataSource(dsl.Tables[0].DefaultView);

Niranjan Poddar · Answer

add dataset and create table and add column to dataset . after create a crystal report and add columns into crystal report. then create report page and take a reportviewer... Page load() page codding here...................... protected void Page_Load(object sender EventArgs e) { GetLandUses(); } public void GetLandUses() { if (con.State == ConnectionState.Open) { con.Close(); } con.Open(); da = new SqlDataAdapter(select top 20 [DIST_NM][YEAR_NM][SCM_NM][HEAD_NM][ARG_AREA] from VIEW_LANDUSES_DTLS con); ds = new DataSet(); da.Fill(ds); dt = new DataTable(); dt = ds.Tables[0]; ReportDocument rd = new ReportDocument(); DsLandUse dsl = new DsLandUse(); DataTable dt1 = new DataTable(); dt1.TableName = Crystal Report Example; dsl.Tables[0].Merge(dt); rd.Load(Server.MapPath(~/Reports/CrystalReport.rpt)); rd.SetDataSource(dsl.Tables[0]); CrystalReportViewer1.ReportSource = rd; con.Close(); }

Ravi Kumar · Answer

share your code