public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { RDRangeRpt rpt = new RDRangeRpt(); rpt.Site = this.Site; return(rpt); }
private void GetReport() { if (Request.QueryString["From"] != null && Request.QueryString["To"] != null) { RDRangeRpt objRpt = new RDRangeRpt(); crystalReport = objRpt; a.ExcecuteQuery("select Bill_no,Return_date,sum(0+P_sold) as price,Sum(0+P_tot) as total,Sum(0+P_tot)-sum(0+P_sold) as tax from SalesRTable where Return_date>='" + Convert.ToDateTime(Request.QueryString["From"]).Date.ToString("yyyy-MM-dd") + "' and Return_date<='" + Convert.ToDateTime(Request.QueryString["To"]).Date.ToString("yyyy-MM-dd") + "' group by Bill_no,Return_date "); crystalReport.SetDataSource(a.DT); crystalReport.SetParameterValue("from", Request.QueryString["From"].ToString()); crystalReport.SetParameterValue("to", Request.QueryString["To"].ToString()); CrystalReportViewer1.ReportSource = crystalReport; } }