public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { rptWeeklyStatistics rpt = new rptWeeklyStatistics(); rpt.Site = this.Site; return(rpt); }
protected void loadReport(string cachedReports) { //int rptCacheTimeout = Convert.ToInt32(ConfigurationManager.AppSettings.Get("rptCacheTimeout").ToString()); rptWeeklyStatistics rpt = new rptWeeklyStatistics(); string connectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; SqlConnection connection = new SqlConnection(connectionString); SqlDataAdapter adapter = new SqlDataAdapter(); DataSet ds = new DataSet(); string startdate = Request.QueryString["st"].ToString(); string enddate = Request.QueryString["ed"].ToString(); string companies = Request.QueryString["comps"].ToString(); ParameterValues parameters = new ParameterValues(); ParameterDiscreteValue sdate = new ParameterDiscreteValue(); ParameterDiscreteValue edate = new ParameterDiscreteValue(); sdate.Value = startdate; edate.Value = enddate; adapter = new SqlDataAdapter("spGetWeeklyStatisticsByCompany", connection); adapter.SelectCommand.CommandType = CommandType.StoredProcedure; adapter.SelectCommand.Parameters.Add("@companies", SqlDbType.VarChar).Value = companies; adapter.SelectCommand.Parameters.Add("@startdate", SqlDbType.DateTime).Value = startdate; adapter.SelectCommand.Parameters.Add("@enddate", SqlDbType.DateTime).Value = enddate; if (connection.State == ConnectionState.Closed) { connection.Open(); } adapter.Fill(ds, "vwWeeklyStatistics"); rpt.SetDataSource(ds); parameters.Add(sdate); rpt.DataDefinition.ParameterFields["Startdate"].ApplyCurrentValues(parameters); parameters.Add(edate); rpt.DataDefinition.ParameterFields["Enddate"].ApplyCurrentValues(parameters); adapter.Dispose(); connection.Dispose(); //Cache.Insert(cachedReports, rpt, null, DateTime.MaxValue, TimeSpan.FromMinutes(rptCacheTimeout)); Session[cachedReports] = rpt; WeeklyStatisticsReport_ByCompany.ReportSource = rpt; }