public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
PurchaseAnnualReport rpt = new PurchaseAnnualReport();
rpt.Site = this.Site;
return(rpt);
}
private void GetReport()
{
DBC a = new DBC();
if (Request.QueryString["year"] != null)
{
PurchaseAnnualReport objRpt = new PurchaseAnnualReport();
crystalReport = objRpt;
a.ExcecuteQuery("Select * from PurchaseInvoiceTable where year(P_Date)='" + Request.QueryString["year"].ToString() + "'");
crystalReport.SetDataSource(a.DT);
crystalReport.SetParameterValue("year", Request.QueryString["year"].ToString());
CrystalReportViewer1.ReportSource = crystalReport;
}
}
