public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
PurchaseDetailReport rpt = new PurchaseDetailReport();
rpt.Site = this.Site;
return(rpt);
}
private void GetReport()
{
DBC a = new DBC();
if (Request.QueryString["month"] != null && Request.QueryString["year"] != null)
{
int month = Convert.ToInt32(Request.QueryString["Month"]);
string mnth = DateTimeFormatInfo.CurrentInfo.GetMonthName(month);
PurchaseDetailReport objRpt = new PurchaseDetailReport();
crystalReport = objRpt;
a.ExcecuteQuery("Select * from PurchaseInvoiceTable where month(P_Date)='" + Request.QueryString["month"].ToString() + "' and year(P_Date)='" + Request.QueryString["year"].ToString() + "'");
crystalReport.SetDataSource(a.DT);
crystalReport.SetParameterValue("year", Request.QueryString["year"].ToString());
crystalReport.SetParameterValue("month", mnth);
CrystalReportViewer1.ReportSource = crystalReport;
}
}
