Example #1
0
        public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
        {
            PurchaseReport rpt = new PurchaseReport();

            rpt.Site = this.Site;
            return(rpt);
        }
Example #2
0
        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;
            }
        }