public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
RptSummBrandInventory rpt = new RptSummBrandInventory();
rpt.Site = this.Site;
return(rpt);
}
private void Acc_SummaryofBrandInventoryandConsolidatedMonthlyInv()
{
ReportDocument rpt;
string rptDocCachedKey = null;
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["IRMSConnectionString"].ConnectionString);
conn.Open();
SqlCommand cmd = new SqlCommand();
if (Request.QueryString["rptnameSOI"] == "rptBrandInvSumm")
{
rptDocCachedKey = "rptBrandInvSumm";
if (Cache[rptDocCachedKey] != null)
{
rpt = (RptSummBrandInventory)Cache[rptDocCachedKey];
}
else
{
rpt = new RptSummBrandInventory();
Cache.Insert(rptDocCachedKey, rpt);
}
cmd.Connection = conn;
cmd.CommandTimeout = 3000;
cmd.CommandText = "GenRptBrandSummInventory '" + Request.QueryString["datefrom"] + "','" + Request.QueryString["dateto"] + "', '" + Session["USER_NAME"] + "'";
cmd.ExecuteNonQuery();
}
else
{
rptDocCachedKey = "GenRptConsoSummaryofMonthlyInvPerBrand";
if (Cache[rptDocCachedKey] != null)
{
rpt = (RptConsoSummaryofMonthlyInvPerBrand)Cache[rptDocCachedKey];
}
else
{
rpt = new RptConsoSummaryofMonthlyInvPerBrand();
Cache.Insert(rptDocCachedKey, rpt);
}
cmd.Connection = conn;
cmd.CommandTimeout = 3000;
cmd.CommandText = "GenRptSummConsoOfMonthlyInvPerBrand '" + Request.QueryString["datefrom"] + "','" + Request.QueryString["dateto"] + "','" + Session["USER_NAME"] + "'";
cmd.ExecuteNonQuery();
}
DataBaseLogIn(rpt);
ParameterField prmUserName = new ParameterField();
ParameterField prmDateFrom = new ParameterField();
ParameterField prmDateTo = new ParameterField();
ParameterFields prmList = new ParameterFields();
prmUserName.ParameterFieldName = "username";
prmDateFrom.ParameterFieldName = "datefrom";
prmDateTo.ParameterFieldName = "dateto";
ParameterDiscreteValue prmUserNameValue = new ParameterDiscreteValue();
ParameterDiscreteValue prmDateFromValue = new ParameterDiscreteValue();
ParameterDiscreteValue prmDateToValue = new ParameterDiscreteValue();
prmUserNameValue.Value = Session["USER_NAME"];
prmDateFromValue.Value = Request.QueryString["datefrom"];
prmDateToValue.Value = Request.QueryString["dateto"];
prmUserName.CurrentValues.Add(prmUserNameValue);
prmDateFrom.CurrentValues.Add(prmDateFromValue);
prmDateTo.CurrentValues.Add(prmDateToValue);
prmList.Add(prmUserName);
prmList.Add(prmDateFrom);
prmList.Add(prmDateTo);
crvDailyReport.ParameterFieldInfo = prmList;
crvDailyReport.ReportSource = rpt;
}
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
RptSummBrandInventory rpt = new RptSummBrandInventory();
rpt.Site = this.Site;
return rpt;
}