public Boolean printReport(CrystalDecisions.CrystalReports.Engine.ReportClass crReport, CrystalReportViewer CrystalReportViewer1, String param1, String ParamName1, String param2, String ParamName2) { if (PrinterName=="none") return false; paramField.ParameterFieldName = ParamName1; discreteVal.Value = param1; paramField.CurrentValues.Add (discreteVal); paramFields.Add (paramField); crReport.DataDefinition.ParameterFields[0].CurrentValues.Add (discreteVal); paramField2.ParameterFieldName = ParamName2; discreteVal2.Value = param2; paramField2.CurrentValues.Add (discreteVal2); paramFields.Add (paramField2); crReport.DataDefinition.ParameterFields[1].CurrentValues.Add (discreteVal2); CrystalReportViewer1.ReportSource = crReport; CrystalReportViewer1.ParameterFieldInfo = paramFields; CrystalReportViewer1.RefreshReport(); ParameterValues tmpParam = new ParameterValues(); ParameterValues tmpParam2 = new ParameterValues(); tmpParam.Add(discreteVal); tmpParam2.Add(discreteVal2); crReport.DataDefinition.ParameterFields[0].ApplyCurrentValues(tmpParam); crReport.DataDefinition.ParameterFields[1].ApplyCurrentValues(tmpParam2); crReport.PrintOptions.PrinterName = PrinterName; // crReport.PrintToPrinter(1,false,1,1); crReport.PrintToPrinter(1,false,1,99); //Response.write (PrinterName); return true; }
public static void loadReport(ReportDocument rd, CrystalReportViewer crv, Int16 status, string phone = null, int?tableID = null) { try { SqlCommand cmd = new SqlCommand("st_getOrderReport", MainClass.con); cmd.CommandType = CommandType.StoredProcedure; if (phone == null) { cmd.Parameters.AddWithValue("@tableID", tableID); cmd.Parameters.AddWithValue("@status", status); cmd.Parameters.AddWithValue("@phone", DBNull.Value); } else { cmd.Parameters.AddWithValue("@phone", phone); cmd.Parameters.AddWithValue("@status", status); cmd.Parameters.AddWithValue("@tableID", DBNull.Value); } SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); rd.Load(Application.StartupPath + "\\Reports\\billReport.rpt"); rd.SetDataSource(dt); crv.ReportSource = rd; crv.RefreshReport(); } catch (Exception ex) { if (rd != null) { rd.Close(); } MainClass.showMessage(ex.Message, "error"); } }
public static void loadBillReport(ReportDocument rd, CrystalReportViewer crv, Int16 status, Int64 orderid) { try { SqlCommand cmd = new SqlCommand("st_getOrderReport", MainClass.con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@orderID", orderid); cmd.Parameters.AddWithValue("@status", status); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); rd.Load(Application.StartupPath + "\\Reports\\billReport.rpt"); rd.SetDataSource(dt); crv.ReportSource = rd; crv.RefreshReport(); } catch (Exception ex) { if (rd != null) { rd.Close(); } MainClass.showMessage(ex.Message, "Error", "Error"); } }
public static void ShowReportSaleReturn(CrystalReportViewer crv, string proc, string param = null, object val1 = null) { try { ReportDocument rd; SqlConnection sql_con = new SqlConnection(MainClass.connection()); SqlCommand cmd = new SqlCommand(proc, sql_con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue(param, val1); SqlDataAdapter adapter = new SqlDataAdapter(cmd); DataTable dat = new DataTable(); adapter.Fill(dat); rd = new ReportDocument(); rd.Load(Application.StartupPath + "\\Reports\\SalesReturnReport.rpt"); rd.SetDataSource(dat); crv.ReportSource = rd; crv.RefreshReport(); } catch (Exception ex) { MainClass.ShowMsg(ex.Message, "Error"); } }
public void showReport(ReportDocument rd, CrystalReportViewer crv, string proc, string reportFile, string param = null, object val = null) { try { //DialogResult dr = MessageBox.Show(param, Convert.ToInt32(val).ToString(), MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation); SqlCommand cmd = new SqlCommand(proc, MainClass.con); cmd.CommandType = CommandType.StoredProcedure; if (param != null && val != null) { cmd.Parameters.AddWithValue(param, val); } SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); rd.Load(Application.StartupPath + "\\Reports\\" + reportFile); rd.SetDataSource(dt); crv.ReportSource = rd; crv.RefreshReport(); } catch (Exception ex) { MainClass.con.Close(); MainClass.ShowMSG(ex.Message, "Error ", "Error"); } }
public printpreview(string rptfilename, string recordselectionformula) { MessageBox.Show(rptfilename); StartPosition = FormStartPosition.CenterParent; Size = new Size(550, 400); ConnectionInfo cni = new ConnectionInfo(); if (gv.mdbfile == "") { cni.ServerName = gv.listfile; } else { cni.ServerName = gv.mdbfile; } doc = new ReportDocument(); doc.Load(rptfilename); doc.RecordSelectionFormula = recordselectionformula; foreach (Table crtb in doc.Database.Tables) { TableLogOnInfo li = crtb.LogOnInfo; li.ConnectionInfo = cni; crtb.ApplyLogOnInfo(li); } crv = new CrystalReportViewer(); crv.Dock = DockStyle.Fill; crv.Size = new Size(550, 350); crv.ToolPanelView = ToolPanelViewType.None; crv.ReportSource = doc; crv.RefreshReport(); crv.Parent = this; }
public void showReport(ReportDocument rep, object[] source) { frmReport frm = new frmReport(); CrystalReportViewer report = frm.getviewer(); rep.SetDataSource(source); report.ReportSource = rep; report.RefreshReport(); frm.ShowDialog(); }
public Boolean initReport(ReportClass crReport, CrystalReportViewer CrystalReportViewer1, String param, String ParamName) { if(param=="" || param==null ) return false; paramField.ParameterFieldName = ParamName; discreteVal.Value = param; paramField.CurrentValues.Add (discreteVal); paramFields.Add (paramField); CrystalReportViewer1.ReportSource = crReport; CrystalReportViewer1.ParameterFieldInfo = paramFields; CrystalReportViewer1.RefreshReport(); return true; }
public void DoRefresh() { if (opened) { if (!_offline) { if (RsViewEngine.ProfileManager.Profile.Settings.EmbeddedParamEdit.Enabled) { addRptToViewer(); } else { ctlViewer.RefreshReport(); } } else { DoOnline(); } } }
public void showPurchaseInvoiceRecipt(ReportDocument rd, CrystalReportViewer crv, string proc, string param1, object val1) { try { SqlCommand cmd = new SqlCommand(proc, MainClass.con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue(param1, val1); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); //it is a class for crystal report //it is a property jdr bi Application ki exe save hogi whan se path utha k le aya ga rd.Load(Application.StartupPath + "\\Reports\\PurchaseInvoiceRecipt.rpt"); rd.SetDataSource(dt); crv.ReportSource = rd; crv.RefreshReport(); } catch (Exception ex) { MainClass.ShowMSG(ex.Message, "Error", "Error"); } }
public void ShowonCrystalReportSalesInvoice(ReportDocument rdd, CrystalReportViewer crv, string proc, string param1, object val1) { try { SqlCommand cmd = new SqlCommand(proc, MainClass.con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue(param1, val1); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); rdd.Load(Application.StartupPath + "\\Reports\\CrystalReportSale.rpt"); rdd.SetDataSource(dt); crv.ReportSource = rdd; crv.RefreshReport(); } catch (Exception exp) { throw exp; } }
/// <summary> /// 显示报表一次 /// </summary> /// <param name="parentControl"></param> /// <param name="FileName"></param> /// <param name="ds"></param> /// <returns></returns> public int ShowReportOnce(System.Windows.Forms.Control parentControl, string FileName, object ds) { try { ReportDocument rpt = null; if (ReportViewer.ReportSource == null) { rpt = new ReportDocument(); rpt.Load(FileName); } else { rpt = ReportViewer.ReportSource as ReportDocument; } rpt.SetDataSource(ds); ReportViewer.ReportSource = rpt; ReportViewer.RefreshReport(); Show(parentControl); } catch (Exception ex) { MessageBox.Show(ex.Message); return(-1); } return(0); }
protected void Page_Load(object sender, EventArgs e) { var fileName = Request.QueryString["fileName"]; var filePath = String.Format("{0}\\{1}", Server.MapPath("~/Reports"), fileName); var fileInfo = new FileInfo(filePath); if (fileInfo.Exists == false) { ReturnErrorStatusAndShowMessage(fileName); return; } var connectionInfo = GetConnectionInfo(); CrystalDecisions.Web.Report webReport = new CrystalDecisions.Web.Report(); webReport.FileName = filePath; CrystalReportSource.Report = webReport; SetDBLogonForReport(connectionInfo, CrystalReportSource.ReportDocument); CrystalReportViewer.Error += new CrystalDecisions.Web.ErrorEventHandler(delegate(Object o, CrystalDecisions.Web.ErrorEventArgs errorArgs) { //ignore missing parameters error (not an error) if (!errorArgs.ErrorMessage.Contains("Missing parameter values")) { ShowFeaturedText(String.Format("Error {0}", errorArgs.ErrorMessage)); } }); CrystalReportViewer.DataBind(); CrystalReportViewer.RefreshReport(); }
public Boolean printReport(CrystalDecisions.CrystalReports.Engine.ReportClass crReport, CrystalReportViewer CrystalReportViewer1, String param, String ParamName) { bool success=false; if (PrinterName!="none") { try { paramField.ParameterFieldName = ParamName; discreteVal.Value = param; paramField.CurrentValues.Add (discreteVal); paramFields.Add (paramField); crReport.DataDefinition.ParameterFields[0].CurrentValues.Add (discreteVal); CrystalReportViewer1.ReportSource = crReport; CrystalReportViewer1.ParameterFieldInfo = paramFields; CrystalReportViewer1.RefreshReport(); ParameterValues tmpParam = new ParameterValues(); tmpParam.Add(discreteVal); crReport.DataDefinition.ParameterFields[0].ApplyCurrentValues(tmpParam); crReport.PrintOptions.PrinterName = PrinterName; //crReport.PrintToPrinter(1,false,1,1); crReport.PrintToPrinter(1,false,1,99); success=true; } catch{} } return success; }
public Boolean initReport(ReportClass crReport, CrystalReportViewer CrystalReportViewer1, String param1, String ParamName1, String param2, String ParamName2) { if(param1=="" || param1==null ) return false; if(param2=="" || param2==null ) return false; paramField.ParameterFieldName = ParamName1; discreteVal.Value = param1; paramField.CurrentValues.Add (discreteVal); paramFields.Add (paramField); crReport.DataDefinition.ParameterFields[0].CurrentValues.Add (discreteVal); paramField2.ParameterFieldName = ParamName2; discreteVal2.Value = param2; paramField2.CurrentValues.Add (discreteVal2); paramFields.Add (paramField2); crReport.DataDefinition.ParameterFields[1].CurrentValues.Add (discreteVal2); CrystalReportViewer1.ReportSource = crReport; CrystalReportViewer1.ParameterFieldInfo = paramFields; CrystalReportViewer1.RefreshReport(); return true; }