public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
rptLoanRepaymentSummary rpt = new rptLoanRepaymentSummary();
rpt.Site = this.Site;
return(rpt);
}
protected void loadReport(string cachedReports)
{
//int rptCacheTimeout = Convert.ToInt32(ConfigurationManager.AppSettings.Get("rptCacheTimeout").ToString());
rptLoanRepaymentSummary rpt = new rptLoanRepaymentSummary();
string connectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
SqlConnection connection = new SqlConnection(connectionString);
SqlDataAdapter adapter = new SqlDataAdapter();
DataSet ds = new DataSet();
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;
adapter = new SqlDataAdapter("select LoanScheme, sum(LoanRepayAmt) as TotalRepaidAmt from vwLoanRepayments where (ApprovedDate between @startdate and @enddate) and Approved = 1 group by LoanScheme", connection);
adapter.SelectCommand.Parameters.Add("@startdate", SqlDbType.DateTime).Value = startdate;
adapter.SelectCommand.Parameters.Add("@enddate", SqlDbType.DateTime).Value = enddate;
if (connection.State == ConnectionState.Closed)
{
connection.Open();
}
adapter.Fill(ds, "Command");
rpt.SetDataSource(ds);
parameters.Add(sdate);
rpt.DataDefinition.ParameterFields["sdate"].ApplyCurrentValues(parameters);
parameters.Add(edate);
rpt.DataDefinition.ParameterFields["edate"].ApplyCurrentValues(parameters);
adapter.Dispose();
connection.Dispose();
//Cache.Insert(cachedReports, rpt, null, DateTime.MaxValue, TimeSpan.FromMinutes(rptCacheTimeout));
Session[cachedReports] = rpt;
LoanRepaymentSummaryReport.ReportSource = rpt;
}
