public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { rptDailyPresentReport rpt = new rptDailyPresentReport(); rpt.Site = this.Site; return(rpt); }
private void dailyPresentReportToolStripMenuItem_Click(object sender, EventArgs e) { frmReportOrderBy frm = new frmReportOrderBy("D"); frm.ShowDialog(); if (frm.orderby != "") { SqlConnection conn = new SqlConnection(RayedoxVariables.connectionstring); SqlCommand cmd; SqlDataAdapter da; DataSet1 ds = new DataSet1(); string stingadd1 = "select * from view_attendance where present='P'" + frm.orderby; conn.Open(); cmd = new SqlCommand(stingadd1, conn); da = new SqlDataAdapter(cmd); da.Fill(ds.tblAttendance); cmd.Dispose(); da.Dispose(); rptDailyPresentReport rpt = new rptDailyPresentReport(); rpt.SetDataSource(ds); crystalReportViewer1.ReportSource = rpt; crystalReportViewer1.RefreshReport(); cmd.Dispose(); da.Dispose(); conn.Close(); try { try { rpt.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.Text, "D:\\Rayedoxreport.txt" + ".txt"); } catch { rpt.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.Text, "E:\\Rayedoxreport.txt" + ".txt"); } } catch { rpt.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.Text, "F:\\Rayedoxreport.txt" + ".txt"); } } }