private void InitializeReport() { int year = int.Parse(Request.QueryString["Year"]); int month = int.Parse(Request.QueryString["Month"]); string DRStatus = Request.QueryString["Status"]; int days_count = GetMonthDayCount(year, month); DateTime DateTo = new DateTime(year, month, days_count); DateTime DateFrom = new DateTime(year, month, 1); ReportDocument REPORT_DOC = new ReportDocument(); string reportCacheKey30 = string.Concat("LUZONCDISummary30", year, month, Request.QueryString["Brand"],DRStatus); string reportCacheKey31 = string.Concat("LUZONCDISummary31", year, month, Request.QueryString["Brand"],DRStatus); string reportCacheKey28 = string.Concat("LUZONCDISummary28", year, month, Request.QueryString["Brand"],DRStatus); string reportCacheKey29 = string.Concat("LUZONCDISummary29", year, month, Request.QueryString["Brand"],DRStatus); ParameterField prmDateFrom = new ParameterField(); ParameterField prmDateTo = new ParameterField(); ParameterField prmBrand = new ParameterField(); ParameterField prmStatus = new ParameterField(); ParameterFields prmList = new ParameterFields(); prmDateFrom.ParameterFieldName = "@date_from_param"; prmDateTo.ParameterFieldName = "@date_to_param"; prmBrand.ParameterFieldName = "@brand_name"; prmStatus.ParameterFieldName = "@dr_status"; ParameterDiscreteValue prmDateFromValue = new ParameterDiscreteValue(); ParameterDiscreteValue prmDateToValue = new ParameterDiscreteValue(); ParameterDiscreteValue pramBrandValue = new ParameterDiscreteValue(); ParameterDiscreteValue prmStatusValue = new ParameterDiscreteValue(); prmDateFromValue.Value = DateFrom; prmDateToValue.Value = DateTo; pramBrandValue.Value = Request.QueryString["Brand"]; prmStatusValue.Value = DRStatus; prmDateFrom.CurrentValues.Add(prmDateFromValue); prmDateTo.CurrentValues.Add(prmDateToValue); prmBrand.CurrentValues.Add(pramBrandValue); prmStatus.CurrentValues.Add(prmStatusValue); prmList.Add(prmDateFrom); prmList.Add(prmDateTo); prmList.Add(prmBrand); prmList.Add(prmStatus); switch (days_count) { case 30: if (Cache[reportCacheKey30] != null) { REPORT_DOC = (RptCDISummaryLuzon30)Cache[reportCacheKey30]; } else { REPORT_DOC = new RptCDISummaryLuzon30(); Cache.Insert(reportCacheKey30, REPORT_DOC); } break; case 31: if (Cache[reportCacheKey31] != null) { REPORT_DOC = (RptCDISummaryLuzon31)Cache[reportCacheKey31]; } else { REPORT_DOC = new RptCDISummaryLuzon31(); Cache.Insert(reportCacheKey31, REPORT_DOC); } break; case 28: if (Cache[reportCacheKey28] != null) { REPORT_DOC = (RptCDISummaryLuzon28)Cache[reportCacheKey28]; } else { REPORT_DOC = new RptCDISummaryLuzon28(); Cache.Insert(reportCacheKey28, REPORT_DOC); } break; case 29: if (Cache[reportCacheKey29] != null) { REPORT_DOC = (RptCDISummaryLuzon29)Cache[reportCacheKey29]; } else { REPORT_DOC = new RptCDISummaryLuzon29(); Cache.Insert(reportCacheKey29, REPORT_DOC); } break; default: break; } DataBaseLogIn(REPORT_DOC); this.LUZONDRSummaryReport.ParameterFieldInfo = prmList; LUZONDRSummaryReport.ReportSource = REPORT_DOC; }
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { RptCDISummaryLuzon30 rpt = new RptCDISummaryLuzon30(); rpt.Site = this.Site; return rpt; }