protected void btnPreview_Click(object sender, EventArgs e) { string fileName = ""; ReportDoc = new ReportDocument(); ReportPath = Server.MapPath("~/CrystalReports/Payroll/rptPFLoanLedger.rpt"); DataTable MyDataTable = objPayRptMgr.GetPFLoanLedgerData(ddlMonth.SelectedValue.ToString(), ddlFiscalYear.SelectedValue.ToString(), ""); ReportDoc.Load(ReportPath); ReportDoc.SetDataSource(MyDataTable); ReportDoc.SetParameterValue("pMonthName", Common.ReturnFullMonthName(ddlMonth.SelectedValue.ToString())); fileName = Session["USERID"].ToString() + "_" + "PF Loan Ledger" + ".pdf"; this.ExPortReport(ReportDoc, fileName); StringBuilder sb = new StringBuilder(); sb.Append("<script>"); sb.Append("window.open('~/CrystalReports/Payroll/VirtualReport/" + fileName + "', '', 'fullscreen=true,scrollbars=yes,resizable=yes');"); //sb.Append("window.open('PayrollReportViewer.aspx', '', 'fullscreen=true,scrollbars=yes,resizable=yes');");// sb.Append("</script>"); ScriptManager.RegisterStartupScript(this, this.GetType(), "ConfirmSubmit", sb.ToString(), false); ClientScript.RegisterStartupScript(this.GetType(), "ConfirmSubmit", sb.ToString()); //StringBuilder sb = new StringBuilder(); //string strURL = "../../CrystalReports/Payroll/PFLoanLedgerViewer.aspx?params=" + ddlMonth.SelectedValue.ToString() + "," + DateTime.Today.Year.ToString() + "," + ddlFiscalYear.SelectedValue.ToString(); //sb.Append("<script>"); ////sb.Append("window.open('" + strURL + "', '', 'fullscreen=true,scrollbars=yes,resizable=yes');");// //sb.Append("window.open('" + strURL + "', '', '');"); //sb.Append("</script>"); //ScriptManager.RegisterStartupScript(this, this.GetType(), "ConfirmSubmit", // sb.ToString(), false); //ClientScript.RegisterStartupScript(this.GetType(), "ConfirmSubmit", sb.ToString()); }
protected void GenerateReport(string strMonth, string strYear, string strFinYear) { ReportDoc = new ReportDocument(); ReportPath = Server.MapPath("~/CrystalReports/Payroll/rptPFLoanLedger.rpt"); this.PassParameter(Common.ReturnFullMonthName(strMonth)); ReportDoc.Load(ReportPath); ReportDoc.SetDataSource(objPayRptMgr.GetPFLoanLedgerData(strMonth, strFinYear, "M")); CRV.ReportSource = ReportDoc; }