public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
rprSalesByProduct rpt = new rprSalesByProduct();
rpt.Site = this.Site;
return(rpt);
}
public static ReportDocument LoadSalesByProduct(DateTime date1, DateTime date2)
{
ReportDocument rpt = new Sales.rprSalesByProduct();
dsReports ds = new dsReports();
DenormalizedOrdersTableAdapter ta = new DenormalizedOrdersTableAdapter();
ta.ClearBeforeFill = true;
ta.Connection = AppHelper.GetDbConnection();
ta.FillByDate(ds.DenormalizedOrders, TransactionTypes.TX_SALES_ORDER, date1, date2);
if (ds.DenormalizedOrders.Rows.Count <= 0)
{
FillNoData(ds.DenormalizedOrders);
}
RetrieveDeveloper(ds.Developer);
RetrieveOwner(ds.Owner);
rpt.SetDataSource(ds);
rpt.ParameterFields["@Date1"].CurrentValues.AddValue(date1);
rpt.ParameterFields["@Date2"].CurrentValues.AddValue(date2);
return(rpt);
}
public static ReportDocument LoadSalesByProduct(DateTime date1, DateTime date2)
{
ReportDocument rpt = new Sales.rprSalesByProduct();
dsReports ds = new dsReports();
DenormalizedOrdersTableAdapter ta = new DenormalizedOrdersTableAdapter();
ta.ClearBeforeFill = true;
ta.Connection = AppHelper.GetDbConnection();
ta.FillByDate(ds.DenormalizedOrders, TransactionTypes.TX_SALES_ORDER, date1, date2);
if (ds.DenormalizedOrders.Rows.Count <= 0)
FillNoData(ds.DenormalizedOrders);
RetrieveDeveloper(ds.Developer);
RetrieveOwner(ds.Owner);
rpt.SetDataSource(ds);
rpt.ParameterFields["@Date1"].CurrentValues.AddValue(date1);
rpt.ParameterFields["@Date2"].CurrentValues.AddValue(date2);
return rpt;
}
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() {
rprSalesByProduct rpt = new rprSalesByProduct();
rpt.Site = this.Site;
return rpt;
}