protected void loadReport(string cachedReports)
{
//int rptCacheTimeout = Convert.ToInt32(ConfigurationManager.AppSettings.Get("rptCacheTimeout").ToString());
rptMonthlyApprovedCostSheet rpt = new rptMonthlyApprovedCostSheet();
string connectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
SqlConnectionStringBuilder connStringBuilder = new SqlConnectionStringBuilder(connectionString);
rpt.SetDatabaseLogon(connStringBuilder.UserID, connStringBuilder.Password, connStringBuilder.DataSource, connStringBuilder.InitialCatalog);
string startdate = Request.QueryString["st"].ToString();
string enddate = Request.QueryString["ed"].ToString();
ParameterValues parameters = new ParameterValues();
ParameterDiscreteValue sdate = new ParameterDiscreteValue();
ParameterDiscreteValue edate = new ParameterDiscreteValue();
sdate.Value = startdate;
edate.Value = enddate;
parameters.Add(sdate);
rpt.DataDefinition.ParameterFields["Startdate"].ApplyCurrentValues(parameters);
parameters.Add(edate);
rpt.DataDefinition.ParameterFields["Enddate"].ApplyCurrentValues(parameters);
//Cache.Insert(cachedReports, rpt, null, DateTime.MaxValue, TimeSpan.FromMinutes(rptCacheTimeout));
Session[cachedReports] = rpt;
MonthlyApprovedCostSheetReport.ReportSource = rpt;
}
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
rptMonthlyApprovedCostSheet rpt = new rptMonthlyApprovedCostSheet();
rpt.Site = this.Site;
return(rpt);
}