protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { ReportViewer1.ProcessingMode = ProcessingMode.Local; ReportViewer1.LocalReport.ReportPath = "D:\\Projects\\Sofwena\\Sofwena-ERP\\ERP1\\ERP.Web\\RDLC\\TicketingManagement\\SalesSummaryReport.rdlc"; ReportService service = new ReportService(); OrganisationService companyInfo = new OrganisationService(); string from = Request.QueryString.Get("from"); string to = Request.QueryString.Get("to"); string operatorId = Request.QueryString.Get("operator"); DateTime?tDate = null; DateTime?fDate = null; NPDate date = new NPDate(); string f_DateBS = ""; string t_DateBS = ""; if (!string.IsNullOrEmpty(from)) { fDate = Convert.ToDateTime(from); } if (!string.IsNullOrEmpty(to)) { tDate = Convert.ToDateTime(to); } DataTable dt = service.SalesSummaryReport(fDate, tDate, operatorId); DataTable dt1 = service.ComplementarySummaryReport(fDate, tDate, operatorId); DataTable dt2 = service.DiscountSummaryReport(fDate, tDate, operatorId); object maxDate = DateTime.Now; //dt.Compute("MAX(CreatedDate)", null); object minDate = DateTime.Now; //dt.Compute("MIN(CreatedDate)", null); if (string.IsNullOrEmpty(from)) { f_DateBS = minDate.ToString(); fDate = Convert.ToDateTime(f_DateBS); f_DateBS = date.GetNepaliDate(Convert.ToDateTime(f_DateBS)).npDate; } else { f_DateBS = date.GetNepaliDate(Convert.ToDateTime(fDate)).npDate; } if (string.IsNullOrEmpty(to)) { t_DateBS = maxDate.ToString(); tDate = Convert.ToDateTime(t_DateBS); t_DateBS = date.GetNepaliDate(Convert.ToDateTime(t_DateBS)).npDate; } else { t_DateBS = date.GetNepaliDate(Convert.ToDateTime(tDate)).npDate; } List <Organisation> company = companyInfo.List().ToList(); if (company.Count > 0) { ReportParameter companyName = new ReportParameter("companyName", company[0].Name); ReportViewer1.LocalReport.SetParameters(companyName); ReportParameter address = new ReportParameter("address", company[0].Address); ReportViewer1.LocalReport.SetParameters(address); } string fromAD = GlobalHelper.ToShortDate(fDate.ToString()); string toAD = GlobalHelper.ToShortDate(tDate.ToString()); ReportParameter fDateAD = new ReportParameter("fDateAD", fromAD); ReportViewer1.LocalReport.SetParameters(fDateAD); ReportParameter tDateAD = new ReportParameter("tDateAD", toAD); ReportViewer1.LocalReport.SetParameters(tDateAD); ReportParameter fDateBS = new ReportParameter("fDateBS", f_DateBS.ToString()); ReportViewer1.LocalReport.SetParameters(fDateBS); ReportParameter tDateBS = new ReportParameter("tDateBS", t_DateBS.ToString()); ReportViewer1.LocalReport.SetParameters(tDateBS); string userName = Session["userName"].ToString(); string fyCode = Session["fiscalCode"].ToString(); ReportParameter User = new ReportParameter("User", userName); ReportViewer1.LocalReport.SetParameters(User); ReportParameter fy = new ReportParameter("fy", fyCode); ReportViewer1.LocalReport.SetParameters(fy); //ReportViewer1.AsyncRendering = false; //ReportViewer1.SizeToReportContent = true; //ReportViewer1.ZoomMode = ZoomMode.FullPage; ReportViewer1.LocalReport.DataSources.Clear(); ReportDataSource datasource = new ReportDataSource("SalesCount", dt); ReportDataSource complementary = new ReportDataSource("Complementary", dt1); ReportDataSource discount = new ReportDataSource("DiscountSummary", dt2); ReportViewer1.LocalReport.DataSources.Add(datasource); ReportViewer1.LocalReport.DataSources.Add(complementary); ReportViewer1.LocalReport.DataSources.Add(discount); ReportViewer1.LocalReport.Refresh(); } }