public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { crptprojects rpt = new crptprojects(); rpt.Site = this.Site; return(rpt); }
private void report_Load(object sender, EventArgs e) { SqlConnection sqlCon = new SqlConnection(@"Data Source=.;Initial Catalog=ProjectA;Integrated Security=True"); sqlCon.Open(); SqlDataAdapter sqlDa = new SqlDataAdapter("EntireReport", sqlCon); sqlDa.SelectCommand.CommandType = CommandType.StoredProcedure; DataSet dsAProject = new DataSet(); sqlDa.Fill(dsAProject); sqlCon.Close(); CrystalReport.crptprojects crptEntireReport = new CrystalReport.crptprojects(); crptEntireReport.Database.Tables["Person"].SetDataSource(dsAProject.Tables[0]); crviewer2.ReportSource = null; crviewer2.ReportSource = crptEntireReport; }
private void new_Load(object sender, EventArgs e) { SqlConnection sqlCon = new SqlConnection(@"Data Source=.;Initial Catalog=ProjectA;Integrated Security=True"); sqlCon.Open(); SqlDataAdapter sqlDa = new SqlDataAdapter("ProjectReport", sqlCon); sqlDa.SelectCommand.CommandType = CommandType.StoredProcedure; DataSet dsProject = new DataSet(); sqlDa.Fill(dsProject); sqlCon.Close(); CrystalReport.crptprojects crptProject = new CrystalReport.crptprojects(); crptProject.Database.Tables["Project"].SetDataSource(dsProject.Tables[0]); crptProject.Database.Tables["Advisor"].SetDataSource(dsProject.Tables[1]); crptProject.Database.Tables["Students"].SetDataSource(dsProject.Tables[2]); crvViewer.ReportSource = null; crvViewer.ReportSource = crptProject; }