public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { rptWorkerList rpt = new rptWorkerList(); rpt.Site = this.Site; return(rpt); }
protected void loadReport(string cachedReports) { rptWorkerList rpt = new rptWorkerList(); string connectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; SqlConnection connection = new SqlConnection(connectionString); SqlDataAdapter adapter = new SqlDataAdapter(); DataSet ds = new DataSet(); adapter = new SqlDataAdapter("select * from vwWorkerList where WorkerType = 'W'", connection); if (connection.State == ConnectionState.Closed) { connection.Open(); } adapter.Fill(ds, "vwWorkerList"); rpt.SetDataSource(ds); adapter.Dispose(); connection.Dispose(); Session[cachedReports] = rpt; WorkerListReport.ReportSource = rpt; }