public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
PurchaseReport rpt = new PurchaseReport();
rpt.Site = this.Site;
return(rpt);
}
private void GetReport()
{
DBC a = new DBC();
if (Request.QueryString["pino"] != null)
{
PurchaseReport objRpt = new PurchaseReport();
crystalReport = objRpt;
//a.ExcecuteQuery("select * from PurchaseTable t1 inner join ProductTable t2 on t1.Item=t2.P_name where t1.PurchaseNo='" + Request.QueryString["pno"].ToString() + "'");
a.ExcecuteQuery("select* from PurchaseTable t1 inner join ProductTable t2 on t1.Item = t2.P_name inner join PurchaseInvoiceTable t3 on t1.PurchaseNo = t3.P_No where t3.P_InvoiceNo ='" + Request.QueryString["pino"].ToString() + "' ");
crystalReport.SetDataSource(a.DT);
crystalReport.SetParameterValue("pino", Request.QueryString["pino"].ToString());
CrystalReportViewer1.ReportSource = crystalReport;
}
}