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

            rpt.Site = this.Site;
            return(rpt);
        }
Beispiel #2
0
 private void GetReport()
 {
     if (Request.QueryString["InvoiceNo"] != null)
     {
         SalesRpt objRpt = new SalesRpt();
         crystalReport = objRpt;
         a.ExcecuteQuery("Select t1.P_name,t2.Cat_name,t1.P_qty,t3.P_price,t1.P_tot,t3.P_tax,t1.P_no,t4.Bill_dis from ProductTable t3 inner join SalesTable t1 on t1.P_name=t3.P_name inner join CategoryTable t2 on t1.P_cat=t2.Cat_id inner join InvoiceTable t4 on t1.Bill_no=t4.Bill_no where t1.Bill_no='" + Request.QueryString["InvoiceNo"].ToString() + "'");
         crystalReport.SetDataSource(a.DT);
         crystalReport.SetParameterValue("InvoiceNo", Request.QueryString["InvoiceNo"].ToString());
         crystalReport.SetParameterValue("Date", Request.QueryString["date"].ToString());
         CrystalReportViewer1.ReportSource = crystalReport;
     }
 }