public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { PurchaseReport rpt = new PurchaseReport(); rpt.Site = this.Site; return(rpt); }
private void GetReport() { DBCON a = new DBCON(); 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; } }