public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
RptCDISummaryVisayas29 rpt = new RptCDISummaryVisayas29();
rpt.Site = this.Site;
return rpt;
}
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 reportCacheKey = string.Concat("VISAYASCDISummary", 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[reportCacheKey] != null)
{
REPORT_DOC = (RptCDISummaryVisayas30)Cache[reportCacheKey];
}
else
{
REPORT_DOC = new RptCDISummaryVisayas30();
Cache.Insert(reportCacheKey, REPORT_DOC);
}
break;
case 31:
if (Cache[reportCacheKey] != null)
{
REPORT_DOC = (RptCDISummaryVisayas31)Cache[reportCacheKey];
}
else
{
REPORT_DOC = new RptCDISummaryVisayas31();
Cache.Insert(reportCacheKey, REPORT_DOC);
}
break;
case 28:
if (Cache[reportCacheKey] != null)
{
REPORT_DOC = (RptCDISummaryVisayas28)Cache[reportCacheKey];
}
else
{
REPORT_DOC = new RptCDISummaryVisayas28();
Cache.Insert(reportCacheKey, REPORT_DOC);
}
break;
case 29:
if (Cache[reportCacheKey] != null)
{
REPORT_DOC = (RptCDISummaryVisayas29)Cache[reportCacheKey];
}
else
{
REPORT_DOC = new RptCDISummaryVisayas29();
Cache.Insert(reportCacheKey, REPORT_DOC);
}
break;
default:
break;
}
DataBaseLogIn(REPORT_DOC);
this.VISAYASDRSummaryReport.ParameterFieldInfo = prmList;
VISAYASDRSummaryReport.ReportSource = REPORT_DOC;
}