private void annual() { ReportDocument cryRpt = new ReportDocument(); cryRpt.Load(AppDomain.CurrentDomain.BaseDirectory + @"\rptDTRAnnual.rpt"); TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); ParameterFieldDefinitions crParameterFieldDefinitions; ParameterFieldDefinition crParameterFieldDefinition; ParameterValues crParameterValues = new ParameterValues(); ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue(); crParameterDiscreteValue.Value = cbAnnualYear.Text; crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions["year"]; crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Clear(); crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); SqlConnectionStringBuilder SqlConnectionStringBuilder = new SqlConnectionStringBuilder(LoginNew.conn.ConnectionString); string ServerName = SqlConnectionStringBuilder.DataSource; string DatabaseName = SqlConnectionStringBuilder.InitialCatalog; Boolean IntegratedSecurity = SqlConnectionStringBuilder.IntegratedSecurity; string UserID = SqlConnectionStringBuilder.UserID; string Password = SqlConnectionStringBuilder.Password; foreach (CrystalDecisions.CrystalReports.Engine.Table Table in cryRpt.Database.Tables) { TableLogOnInfo TableLogOnInfo = Table.LogOnInfo; TableLogOnInfo.ConnectionInfo.ServerName = ServerName; TableLogOnInfo.ConnectionInfo.DatabaseName = DatabaseName; TableLogOnInfo.ConnectionInfo.IntegratedSecurity = IntegratedSecurity; if (IntegratedSecurity != true) { TableLogOnInfo.ConnectionInfo.UserID = UserID; TableLogOnInfo.ConnectionInfo.Password = Password; } Table.ApplyLogOnInfo(TableLogOnInfo); } crystalReportViewer3.ReportSource = cryRpt; crystalReportViewer3.Refresh(); }
private void frmRProveedor_Load(object sender, EventArgs e) { try { ReportDocument repdoc = new ReportDocument(); TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); Tables CrTables; //D:/credicon/jmsacrcc/jmsacrcc/Mostrar_Cuotas.rpt //D:/credcon/Imp_Cuotas.rpt //repdoc.Load(@"D:/credcon/Imp_Cuotas.rpt"); //repdoc.Load(@"D:/credcon/Imp_Cuotas.rpt"); //repdoc.Load(@"D:/credicon/jmsacrcc/jmsacrcc/Reportes/Imprimir_Cuotas.rpt"); //repdoc.Load(@"D:/credicon/jmsacrcc/jmsacrcc/Imp_Cuotas.rpt"); //repdoc.Load(@"D:/credicon/jmsacrcc/jmsacrcc/Reportes/Imprimir_Cuotas.rpt"); //repdoc.Load(@"D:/Reportes/RCliente.rpt"); repdoc.Load(@"D:\Reportes\RProveedor.rpt"); crConnectionInfo.ServerName = @"EQUIPO\SQLEXPRESS"; crConnectionInfo.DatabaseName = "SIS_AVICOLA"; crConnectionInfo.UserID = "admin"; crConnectionInfo.Password = "******"; /* * repdoc.Load(@"C:\Users\vioma\OneDrive\Documentos\Visual Studio 2017\Projects\SisVentas_ResAlm\CapaPresentacion\Reportes/RProveedor.rpt"); * * crConnectionInfo.ServerName = @"EQUIPO\SQLEXPRESS"; * crConnectionInfo.DatabaseName = "db_restauranteAlmacen"; * crConnectionInfo.UserID = "martin"; * crConnectionInfo.Password = "******"; */ CrTables = repdoc.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } cvProveedor.ReportSource = repdoc; cvProveedor.Refresh(); } catch (Exception) { MessageBox.Show("ERROR"); } }
private void frmRImprimirDetalleCompra_Load(object sender, EventArgs e) { try { ExcelFormatOptions objExcel = new ExcelFormatOptions(); int idProducto = Convert.ToInt32(frmMostrarCompras.f1.lblIdCompra.Text); ReportDocument repdoc = new ReportDocument(); // repdoc.Load(@"C:\Users\vioma\OneDrive\Documentos\Visual Studio 2017\Projects\SisVentas_ResAlm\CapaPresentacion\Reportes/RVentaProducto.rpt"); repdoc.Load(@"D:\Reportes\RImprimirDetalleCompra.rpt"); ParameterFieldDefinitions pfds; ParameterFieldDefinition pfd; ParameterValues pvs = new ParameterValues(); ParameterDiscreteValue pdv = new ParameterDiscreteValue(); pdv.Value = idProducto; pfds = repdoc.DataDefinition.ParameterFields; pfd = pfds["@idCompra"]; pvs.Add(pdv); pfd.ApplyCurrentValues(pvs); TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); Tables CrTables; crConnectionInfo.ServerName = @"EQUIPO\SQLEXPRESS"; crConnectionInfo.DatabaseName = "SIS_AVICOLA"; crConnectionInfo.UserID = "admin"; crConnectionInfo.Password = "******"; CrTables = repdoc.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } cvVentas.ReportSource = repdoc; cvVentas.Refresh(); objExcel.ExcelUseConstantColumnWidth = false; } catch (Exception ex) { MessageBox.Show("ERROR" + ex); } }
private void Report() { ParameterField paramField1 = new ParameterField(); //creating an object of ParameterFields class ParameterFields paramFields1 = new ParameterFields(); //creating an object of ParameterDiscreteValue class ParameterDiscreteValue paramDiscreteValue1 = new ParameterDiscreteValue(); //set the parameter field name paramField1.Name = "ShipmentId"; //set the parameter value paramDiscreteValue1.Value = _shId; //add the parameter value in the ParameterField object paramField1.CurrentValues.Add(paramDiscreteValue1); //add the parameter in the ParameterFields object paramFields1.Add(paramField1); ReportViewer f2 = new ReportViewer(); TableLogOnInfos reportLogonInfos = new TableLogOnInfos(); TableLogOnInfo reportLogonInfo = new TableLogOnInfo(); ConnectionInfo reportConInfo = new ConnectionInfo(); Tables tables = default(Tables); // Table table = default(Table); var with1 = reportConInfo; with1.ServerName = "tcp:KyotoServer,49172"; with1.DatabaseName = "ProductNRelatedDB_newforSpecialPrice"; with1.UserID = "sa"; with1.Password = "******"; ShipmentAcknowledgement cr = new ShipmentAcknowledgement(); tables = cr.Database.Tables; foreach (Table table in tables) { reportLogonInfo = table.LogOnInfo; reportLogonInfo.ConnectionInfo = reportConInfo; table.ApplyLogOnInfo(reportLogonInfo); } f2.crystalReportViewer1.ParameterFieldInfo = paramFields1; f2.crystalReportViewer1.ReportSource = cr; this.Visible = false; f2.ShowDialog(); this.Visible = true; }
private void frmRConsultaCierre_Load(object sender, EventArgs e) { try { ReportDocument repdoc = new ReportDocument(); // repdoc.Load(@"C:\Users\vioma\OneDrive\Documentos\Visual Studio 2017\Projects\SisVentas_ResAlm\CapaPresentacion\Reportes/RVentas.rpt"); repdoc.Load(@"D:\Reportes\RMostrarCierres.rpt"); ParameterFieldDefinitions pfds; ParameterFieldDefinition pfd; ParameterValues pvs = new ParameterValues(); ParameterDiscreteValue pdv = new ParameterDiscreteValue(); pdv.Value = Convert.ToInt32(1); pfds = repdoc.DataDefinition.ParameterFields; pfd = pfds["@nro"]; pvs.Add(pdv); pfd.ApplyCurrentValues(pvs); TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); Tables CrTables; crConnectionInfo.ServerName = @"EQUIPO\SQLEXPRESS"; crConnectionInfo.DatabaseName = "SISVENTAS_CA"; crConnectionInfo.UserID = "admin"; crConnectionInfo.Password = "******"; /* * crConnectionInfo.ServerName = @"EQUIPO\SQLEXPRESS"; * crConnectionInfo.DatabaseName = "db_restauranteAlmacen"; * crConnectionInfo.UserID = "martin"; * crConnectionInfo.Password = "******"; */ CrTables = repdoc.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } cvVentas.ReportSource = repdoc; cvVentas.Refresh(); } catch (Exception ex) { MessageBox.Show("ERROR" + ex); } }
private void FORMULARIO_ALMACEN_Load(object sender, EventArgs e) { try { ConnectionInfo myConnectionInfo = new ConnectionInfo(); myConnectionInfo.ServerName = "SVR-SQL"; myConnectionInfo.DatabaseName = "ALMACEN"; myConnectionInfo.UserID = "SA"; myConnectionInfo.Password = "******"; myConnectionInfo.Type = ConnectionInfoType.Query; myConnectionInfo.IntegratedSecurity = false; TableLogOnInfos mytableloginfos = new TableLogOnInfos(); mytableloginfos = crystalReportViewer1.LogOnInfo; foreach (TableLogOnInfo myTableLogOnInfo in mytableloginfos) { myTableLogOnInfo.ConnectionInfo = myConnectionInfo; } } catch (Exception ex) { MessageBox.Show("ERROR:" + ex, "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Information); } DataTable datacombo = new DataTable(); TRAERDATOS datos = new TRAERDATOS(); // TODO: This line of code loads data into the 'ALMACENDataSet.EXTRACION_EQUIPO' table. You can move, or remove it, as needed. ///llenar combo begin SqlDataAdapter llenar_combo = datos.llenarcombobodega(); llenar_combo.Fill(datacombo); COMBOBODEGA.DataSource = datacombo; COMBOBODEGA.DisplayMember = "BODEGA"; //llenar como finished // TXTNUMKIT.Text = "0"; TXTCONTADOR.Text = "0"; TXTCANTIDAD.Text = "0"; SqlDataAdapter data = datos.llenargrid(); data.Fill(table); this.DataGrid.DataSource = table; //DataGridViewImageColumn img = new DataGridViewImageColumn(); //Image image = Extraciones.Properties.Resources.delete; //img.Image = image; //DataGrid.Columns.Add(img); //img.HeaderText = ""; //img.Name = "img"; //DataGrid.Columns[3].Width = 18; }
private void Report() { ParameterField parameterFieldPN = new ParameterField(); ParameterFields parameterFieldsPN = new ParameterFields(); ParameterDiscreteValue parameterDiscreteValuePN = new ParameterDiscreteValue(); parameterFieldPN.Name = "id"; parameterDiscreteValuePN.Value = _pid; parameterFieldPN.CurrentValues.Add(parameterDiscreteValuePN); parameterFieldsPN.Add(parameterFieldPN); ReportViewer rv = new ReportViewer(); // TableLogOnInfos reprtLogOnInfos = new TableLogOnInfos(); TableLogOnInfos reportLogonInfos = new TableLogOnInfos(); TableLogOnInfo reportLogonInfo = new TableLogOnInfo(); ConnectionInfo reportConInfo = new ConnectionInfo(); Tables tables = default(Tables); var with1 = reportConInfo; with1.ServerName = "tcp:KyotoServer,49172"; with1.DatabaseName = "AccountDb_new"; with1.UserID = "sa"; with1.Password = "******"; PNLTotalX cr = new PNLTotalX(); tables = cr.Database.Tables; foreach (Table table in tables) { reportLogonInfo = table.LogOnInfo; reportLogonInfo.ConnectionInfo = reportConInfo; table.ApplyLogOnInfo(reportLogonInfo); } rv.crystalReportViewer1.ParameterFieldInfo = parameterFieldsPN; rv.crystalReportViewer1.ReportSource = cr; this.Visible = false; rv.ShowDialog(); this.Visible = true; }
private void GetPortrait() { ParameterField paramField1 = new ParameterField(); //creating an object of ParameterFields class ParameterFields paramFields1 = new ParameterFields(); //creating an object of ParameterDiscreteValue class ParameterDiscreteValue paramDiscreteValue1 = new ParameterDiscreteValue(); //set the parameter field name paramField1.Name = "BatchId"; //set the parameter value paramDiscreteValue1.Value = batchIdCombobox.Text; //add the parameter value in the ParameterField object paramField1.CurrentValues.Add(paramDiscreteValue1); //add the parameter in the ParameterFields object paramFields1.Add(paramField1); ReportViewer f2 = new ReportViewer(); TableLogOnInfos reportLogonInfos = new TableLogOnInfos(); TableLogOnInfo reportLogonInfo = new TableLogOnInfo(); ConnectionInfo reportConInfo = new ConnectionInfo(); Tables tables = default(Tables); // Table table = default(Table); var with1 = reportConInfo; with1.ServerName = "tcp:KyotoServer,49172"; with1.DatabaseName = "PhoneBookDBKD22"; with1.UserID = "sa"; with1.Password = "******"; BatchReportLSort cr = new BatchReportLSort(); tables = cr.Database.Tables; foreach (Table table in tables) { reportLogonInfo = table.LogOnInfo; reportLogonInfo.ConnectionInfo = reportConInfo; table.ApplyLogOnInfo(reportLogonInfo); } f2.crystalReportViewer1.ParameterFieldInfo = paramFields1; f2.crystalReportViewer1.ReportSource = cr; this.Visible = false; f2.ShowDialog(); this.Visible = true; }
private void button1_Click(object sender, EventArgs e) { ReportViewer f2 = new ReportViewer(); ParameterField paramField = new ParameterField(); //creating an object of ParameterFields class ParameterFields paramFields = new ParameterFields(); //creating an object of ParameterDiscreteValue class ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue(); //set the parameter field name paramField.Name = "Benificiary Name"; //set the parameter value paramDiscreteValue.Value = comboBox1.Text; //add the parameter value in the ParameterField object paramField.CurrentValues.Add(paramDiscreteValue); //add the parameter in the ParameterFields object paramFields.Add(paramField); //set the parameterfield information in the crystal report TableLogOnInfos reportLogonInfos = new TableLogOnInfos(); TableLogOnInfo reportLogonInfo = new TableLogOnInfo(); ConnectionInfo reportConInfo = new ConnectionInfo(); Tables tables = default(Tables); // Table table = default(Table); var with1 = reportConInfo; with1.ServerName = "tcp:KyotoServer,49172"; with1.DatabaseName = "BankReconciliationDBProNovember"; with1.UserID = "sa"; with1.Password = "******"; BenificiaryPaymentStatementCrystalReport cr = new BenificiaryPaymentStatementCrystalReport(); tables = cr.Database.Tables; foreach (Table table in tables) { reportLogonInfo = table.LogOnInfo; reportLogonInfo.ConnectionInfo = reportConInfo; table.ApplyLogOnInfo(reportLogonInfo); } f2.crystalReportViewer1.ParameterFieldInfo = paramFields; f2.crystalReportViewer1.ReportSource = cr; this.Visible = false; f2.ShowDialog(); this.Visible = true; }
private void LoadReport() { string foldername = MapPath("~/CS_REPORT/rpt/MTODPexemptionletter.rpt"); CrystalDecisions.Web.Parameter myparamss2 = new CrystalDecisions.Web.Parameter(); string tmp_acctcode = ""; string cardname = StringHelper.ReCodeCharacters(DropDownList1.Text); DataTable user_counterid = SqlDbHelper.getDataDT("SELECT cardcode FROM SAPSERVER.MATIMCO.dbo.OCRD WHERE cardname='" + cardname + "' GROUP BY cardcode"); foreach (DataRow acctCode in user_counterid.Rows) { tmp_acctcode = acctCode["cardcode"].ToString(); } myparamss2.DefaultValue = tmp_acctcode; myparamss2.Name = "Customer Code"; ReportDocument rpt1 = new ReportDocument(); // CrystalReportSource1.ReportDocument.SetDatabaseLogon("sa", "p@ssw0rd", "192.168.10.15", "MATIMCO"); rpt1.Load(foldername); CrystalDecisions.Web.Report rpt_web = new CrystalDecisions.Web.Report(); rpt_web.FileName = foldername; rpt_web.Parameters.Add(myparamss2); CrystalReportSource1.Report = rpt_web; CrystalReportSource1.Report.FileName = foldername; CrystalReportViewer1.ReportSource = CrystalReportSource1; TableLogOnInfos tblinfos = new TableLogOnInfos(); TableLogOnInfo tblinfo = new TableLogOnInfo(); tblinfo.ConnectionInfo.DatabaseName = "MATIMCO"; tblinfo.ConnectionInfo.UserID = "sa"; tblinfo.ConnectionInfo.Password = "******"; tblinfo.ConnectionInfo.ServerName = "192.168.10.15"; tblinfo.ConnectionInfo.IntegratedSecurity = false; tblinfo.ConnectionInfo.AllowCustomConnection = true; CrystalReportSource1.Report.Parameters.Add(myparamss2); CrystalReportViewer1.LogOnInfo.Add(tblinfo); CrystalReportViewer1.RefreshReport(); Label2.Visible = false; }
private void button7_Click(object sender, EventArgs e) { ParameterField paramField1 = new ParameterField(); //creating an object of ParameterFields class ParameterFields paramFields1 = new ParameterFields(); //creating an object of ParameterDiscreteValue class ParameterDiscreteValue paramDiscreteValue1 = new ParameterDiscreteValue(); //set the parameter field name paramField1.Name = "id"; //set the parameter value paramDiscreteValue1.Value = x; //add the parameter value in the ParameterField object paramField1.CurrentValues.Add(paramDiscreteValue1); //add the parameter in the ParameterFields object paramFields1.Add(paramField1); ReportViewer f2 = new ReportViewer(); TableLogOnInfos reportLogonInfos = new TableLogOnInfos(); TableLogOnInfo reportLogonInfo = new TableLogOnInfo(); ConnectionInfo reportConInfo = new ConnectionInfo(); Tables tables = default(Tables); // Table table = default(Table); var with1 = reportConInfo; with1.ServerName = "LAPTOP-19NF5E9"; with1.DatabaseName = "BankReconciliationDBProNovember"; with1.UserID = "sa"; with1.Password = "******"; NewSummrybalance cr = new NewSummrybalance(); tables = cr.Database.Tables; foreach (Table table in tables) { reportLogonInfo = table.LogOnInfo; reportLogonInfo.ConnectionInfo = reportConInfo; table.ApplyLogOnInfo(reportLogonInfo); } f2.crystalReportViewer1.ParameterFieldInfo = paramFields1; f2.crystalReportViewer1.ReportSource = cr; this.Visible = false; f2.ShowDialog(); this.Visible = true; }
protected void Page_Load(object sender, EventArgs e) { string foldername = Server.MapPath("~/CS_REPORT/rpt/Credit Investigation Tab Info.rpt"); try { CrystalDecisions.Web.Parameter acctcode = new CrystalDecisions.Web.Parameter(); string tmp_acctcode = ""; string cardcode = StringHelper.ReCodeCharacters(DropDownList1.Text); DataTable user_counterid = SqlDbHelper.getDataDT("SELECT acctcode FROM customerheader WHERE acctcode='" + cardcode + "' GROUP BY acctcode"); foreach (DataRow acctCode in user_counterid.Rows) { tmp_acctcode = acctCode["acctcode"].ToString(); } acctcode.Name = "Account Code"; acctcode.DefaultValue = tmp_acctcode; ReportDocument rpt1 = new ReportDocument(); rpt1.Load(foldername); CrystalDecisions.Web.Report rpt_web = new CrystalDecisions.Web.Report(); rpt_web.FileName = foldername; rpt_web.Parameters.Add(acctcode); CrystalReportSource1.Report = rpt_web; CrystalReportViewer1.ReportSource = CrystalReportSource1; TableLogOnInfos tblinfos = new TableLogOnInfos(); TableLogOnInfo tblinfo = new TableLogOnInfo(); tblinfo.ConnectionInfo.DatabaseName = "ARMS"; tblinfo.ConnectionInfo.UserID = "sa"; tblinfo.ConnectionInfo.Password = "******"; tblinfo.ConnectionInfo.ServerName = "192.168.10.13"; tblinfo.ConnectionInfo.IntegratedSecurity = false; tblinfo.ConnectionInfo.AllowCustomConnection = true; CrystalReportSource1.Report.Parameters.Add(acctcode); CrystalReportViewer1.LogOnInfo.Add(tblinfo); CrystalReportViewer1.RefreshReport(); Label2.Visible = false; } catch (Exception ex) { Label2.Visible = true; Label2.Text = "Error: " + ex.Message; } }
public static TableLogOnInfos ConectaCrystal() { TableLogOnInfos Infos = new TableLogOnInfos(); TableLogOnInfo Info = new TableLogOnInfo(); ConnectionInfo cn = new ConnectionInfo(); cn.ServerName = "CCLSQL"; cn.DatabaseName = "materia_prima"; cn.UserID = "matprima"; cn.Password = "******"; cn.Type = ConnectionInfoType.SQL; cn.IntegratedSecurity = false; Info.ConnectionInfo = cn; Infos.Add(Info); return Infos; }
public static CrystalDecisions.Windows.Forms.CrystalReportViewer ViewReport(string reportName, List <KeyValuePair <string, object> > Param_Values) { ReportDocument _reportDocument = new ReportDocument(); CrystalDecisions.Windows.Forms.CrystalReportViewer crystalReportViewer1 = new CrystalDecisions.Windows.Forms.CrystalReportViewer(); crystalReportViewer1.ToolPanelView = CrystalDecisions.Windows.Forms.ToolPanelViewType.None; TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); Tables crTables; // load report _reportDocument.Load(AppDomain.CurrentDomain.BaseDirectory.ToString() + "\\Reports\\" + reportName); // set report Connection info string[] LoginData = ConfigurationManager.ConnectionStrings["Local"].ConnectionString.ToString().Split(';'); if (!string.IsNullOrEmpty(LoginData[3].ToString()) && LoginData[3].ToString() != "") { crConnectionInfo.Password = LoginData[3].Split('=')[1].ToString(); } crConnectionInfo.UserID = LoginData[2].Split('=')[1].ToString(); crConnectionInfo.DatabaseName = LoginData[1].Split('=')[1]; crConnectionInfo.ServerName = LoginData[0].Split('=')[1]; crTables = _reportDocument.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in crTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } _reportDocument.Refresh(); // set report Parameter if (Param_Values != null) { foreach (KeyValuePair <string, object> Param_Value in Param_Values) { // _reportDocument.SetParameterValue("SalesHeaderID",Param_Value.Value); _reportDocument.SetParameterValue((string)Param_Value.Key, (object)Param_Value.Value); } } crystalReportViewer1.ReportSource = _reportDocument; crystalReportViewer1.Refresh(); crystalReportViewer1.Name = "crystalReportViewer1"; return(crystalReportViewer1); }
private void Generate_Reports1(string _rpt) { TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); Tables CrTables; BLL_Dml _objbll = new BLL_Dml(); _database _objdb = new _database(); _objdb.DBName = "DBCML"; _clsproject _objcls1 = new _clsproject(); _objcls1.prjcode = lblprj.Text; _objbll.Update_RPTLogo(_objcls1, _objdb); if (_rpt == "msr") { mydiv.Visible = false; //if (lblprj.Text == "12761") // cryRpt.Load(Server.MapPath("ms_schedule_summary1.rpt")); //else cryRpt.Load(Server.MapPath("ms_schedule_summary2.rpt")); cryRpt.SetParameterValue("project", (string)Session["projectname"]); cryRpt.SetParameterValue("srv", (string)Session["srv"]); cryRpt.SetParameterValue("sys", (string)Session["sys"]); cryRpt.SetParameterValue("sts", (string)Session["sts"]); } crConnectionInfo.ServerName = "37.61.235.103"; crConnectionInfo.DatabaseName = "DB_" + lblprj.Text; crConnectionInfo.UserID = "sa"; crConnectionInfo.Password = "******"; CrTables = cryRpt.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } //CrystalReportViewer1.ParameterFieldInfo = paramFields; CrystalReportViewer1.ReportSource = cryRpt; CrystalReportViewer1.DataBind(); //CrystalReportViewer1.RefreshReport(); //CrystalReportViewer1.PageZoomFactor = 200; Session["Report"] = cryRpt; }
private void button1_Click(object sender, EventArgs e) { ReportDoc = new ReportDocument(); ReportDoc.Load("G:\\Dinesh Demo Project\\CrytalReport\\CrytalReport\\Reports\\CrystalReport1.rpt"); //ParameterFieldDefinitions prmdefs; //ParameterFieldDefinition prmdef; //ParameterValues prmVal = new ParameterValues(); //ParameterDiscreteValue prmDisVal = new ParameterDiscreteValue(); //prmDisVal.Value = textBox1.Text; //prmdefs = ReportDoc.DataDefinition.ParameterFields; //prmdef = prmdefs["currentdate"]; //prmVal = prmdef.CurrentValues; //prmVal.Clear(); //prmVal.Add(prmDisVal); //prmdef.ApplyCurrentValues(prmVal); TableLogOnInfos logInfoss = new TableLogOnInfos(); TableLogOnInfo logonInfo = new TableLogOnInfo(); ConnectionInfo conInfo = new ConnectionInfo(); Tables tabls; //conInfo.ServerName = "DINESH-PC"; //conInfo.DatabaseName = "TestDB"; //conInfo.UserID = "sa"; //conInfo.Password = "******"; conInfo.UserID = "Admin"; conInfo.Password = "******"; tabls = ReportDoc.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table crTab in tabls) { logonInfo = crTab.LogOnInfo; logonInfo.ConnectionInfo = conInfo; crTab.ApplyLogOnInfo(logonInfo); } crystalReportViewer1.ReportSource = ReportDoc; crystalReportViewer1.Refresh(); }
/// <summary> /// Actualiza la conexión a la base de datos /// </summary> /// <param name="rpt"> /// Objeto del reporte /// </param> /// <param name="loginfo"> /// Datos de conexión /// </param> private void Actualiza(ref ReportDocument rpt, ConnectionInfo loginfo) { try { CrystalDecisions.Shared.TableLogOnInfo TableLogOnInfo = new TableLogOnInfo(); CrystalDecisions.Shared.TableLogOnInfos tableLogOnInfos = new TableLogOnInfos(); TableLogOnInfo.ConnectionInfo = loginfo; tableLogOnInfos.Add(TableLogOnInfo); ActualizarConexionReporte(rpt, TableLogOnInfo); } catch (Exception ex) { throw new Exception("Error al actualizar reporte: " + ex.Message); } }
public static TableLogOnInfos ConectaCrystal() { TableLogOnInfos Infos = new TableLogOnInfos(); TableLogOnInfo Info = new TableLogOnInfo(); ConnectionInfo cn = new ConnectionInfo(); cn.ServerName = "CCLSQL"; cn.DatabaseName = "materia_prima"; cn.UserID = "matprima"; cn.Password = "******"; cn.Type = ConnectionInfoType.SQL; cn.IntegratedSecurity = false; Info.ConnectionInfo = cn; Infos.Add(Info); return(Infos); }
private void ConnectReporter() { ConnectionInfo myConnectionInfo = new ConnectionInfo(); myConnectionInfo.ServerName = @"localhost"; myConnectionInfo.DatabaseName = "BeanScene"; myConnectionInfo.UserID = "sa_tafe"; myConnectionInfo.Password = "******"; TableLogOnInfos mytableloginfos = new TableLogOnInfos(); mytableloginfos = crystalReportViewer1.LogOnInfo; foreach (TableLogOnInfo myTableLogOnInfo in mytableloginfos) { myTableLogOnInfo.ConnectionInfo = myConnectionInfo; } }
private void Form1_Load(object sender, EventArgs e) { try { if (!textBox1.Visible) { this.Icon = ClasesSGUV.Propiedades.IconHalcoNET; if (er == false) { ReportDocument doc = new ReportDocument(); doc.Load(Ruta); doc.SetDataSource(Ds); crystalReportViewer1.ReportSource = doc; } else { ReportDocument docFacturasI; Tables CrTables; TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); docFacturasI = new ReportDocument(); docFacturasI.Load(@"\\192.168.2.100\HalcoNET\Crystal\PJ_ReciboCobro.rpt"); crConnectionInfo.ServerName = "192.168.2.100"; crConnectionInfo.DatabaseName = "SBO-DistPJ"; crConnectionInfo.UserID = "sa"; crConnectionInfo.Password = "******"; CrTables = docFacturasI.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } docFacturasI.SetParameterValue("Folio", Folio); crystalReportViewer1.ReportSource = docFacturasI; } } } catch (Exception ex) { MessageBox.Show("Error: " + ex.Message, "HalcoNET", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void Report1() { ParameterField parameterField1 = new ParameterField(); ParameterFields parameterFields1 = new ParameterFields(); ParameterDiscreteValue parameterDiscreteValue1 = new ParameterDiscreteValue(); parameterField1.Name = "id"; parameterDiscreteValue1.Value = _bId; parameterField1.CurrentValues.Add(parameterDiscreteValue1); parameterFields1.Add(parameterField1); ReportViewer f1 = new ReportViewer(); TableLogOnInfos reportLogonInfos = new TableLogOnInfos(); TableLogOnInfo reportLogonInfo = new TableLogOnInfo(); ConnectionInfo reportConInfo = new ConnectionInfo(); Tables tables = default(Tables); var with1 = reportConInfo; with1.ServerName = "tcp:KyotoServer,49172"; with1.DatabaseName = "AccountDb_new"; with1.UserID = "sa"; with1.Password = "******"; Equity cr = new Equity(); tables = cr.Database.Tables; foreach (Table table in tables) { reportLogonInfo = table.LogOnInfo; reportLogonInfo.ConnectionInfo = reportConInfo; table.ApplyLogOnInfo(reportLogonInfo); } f1.crystalReportViewer1.ParameterFieldInfo = parameterFields1; f1.crystalReportViewer1.ReportSource = cr; this.Visible = false; f1.ShowDialog(); this.Visible = true; }
private void Generate_Reports() { TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); Tables CrTables; if (lblprj.Text == "HMIM" || lblprj.Text == "ABS") { cryRpt.Load(Server.MapPath("ms_summary1.rpt")); cryRpt.SetParameterValue("bldng", "BUILDING : " + (string)Session["building"]); } else { cryRpt.Load(Server.MapPath("ms_summary.rpt")); } //crConnectionInfo.ServerName = "213.171.197.149,49296"; //crConnectionInfo.DatabaseName = "DBCML"; //crConnectionInfo.UserID = "CMLT"; //crConnectionInfo.Password = "******"; crConnectionInfo.ServerName = Constants.CMLTConstants.serverName; crConnectionInfo.DatabaseName = Constants.CMLTConstants.dbName; crConnectionInfo.UserID = Constants.CMLTConstants.dbUserName; crConnectionInfo.Password = Constants.CMLTConstants.dbPassword; CrTables = cryRpt.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } //string _parm = Request.QueryString[0].ToString(); //string _nos = _parm.Substring(3); //string _type = _parm.Substring(0,2); cryRpt.SetParameterValue("srv", (string)Session["srv"]); cryRpt.SetParameterValue("project", (string)Session["projectname"]); cryRpt.SetParameterValue("total", lbltotal.Text); cryRpt.SetParameterValue("type", lbltype.Text); CrystalReportViewer1.ReportSource = cryRpt; CrystalReportViewer1.DataBind(); Session["Report"] = cryRpt; }
public static void ShowRpOnePara(ReportClass rc, object objDataSource, string mau, Window parentWindow, string database, string server, string use, string pass) { try { rc.SetDataSource(objDataSource); ReportViewUI Viewer = new ReportViewUI(); //---------------------------------------------------------------------------- ParameterFieldDefinitions crParameterFieldDefinitions; ParameterFieldDefinition crParameterFieldDefinition; ParameterValues crParameterValues = new ParameterValues(); ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue(); crParameterDiscreteValue.Value = mau; crParameterFieldDefinitions = rc.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions["in"]; crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Clear(); crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); //------------------------------------------------------------------------------ //log on TableLogOnInfos logonInfos = new TableLogOnInfos(); TableLogOnInfo logonInfo = new TableLogOnInfo(); ConnectionInfo connectioninfo = new ConnectionInfo(); Tables CrTables; // tham so server connectioninfo.DatabaseName = database; connectioninfo.ServerName = server; connectioninfo.Password = pass; connectioninfo.UserID = use; CrTables = rc.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { logonInfo = CrTable.LogOnInfo; logonInfo.ConnectionInfo = connectioninfo; CrTable.ApplyLogOnInfo(logonInfo); } // Viewer.setReportSource(rc); Viewer.ShowDialog(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Thông báo", MessageBoxButton.OK, MessageBoxImage.Error); } }
private void button1_Click(object sender, EventArgs e) { ConnectionInfo crconnectioninfo = new ConnectionInfo(); ReportDocument cryrpt = new ReportDocument(); TableLogOnInfos crtablelogoninfos = new TableLogOnInfos(); TableLogOnInfo crtablelogoninfo = new TableLogOnInfo(); Tables CrTables; crconnectioninfo.ServerName = "AIBSIT"; crconnectioninfo.DatabaseName = "AIBSIT"; crconnectioninfo.UserID = "db2inst4"; crconnectioninfo.Password = "******"; string startupPath = System.IO.Directory.GetCurrentDirectory(); ReportDocument cryRpt = new ReportDocument(); cryRpt.Load(startupPath + "\\ACCOUNT_STATEMENT_PRODUCTION.rpt"); ParameterFields paremeters = cryRpt.ParameterFields; foreach (ParameterField parameter in paremeters) { MessageBox.Show(parameter.Name); } CrTables = cryRpt.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtablelogoninfo = CrTable.LogOnInfo; crtablelogoninfo.ConnectionInfo = crconnectioninfo; CrTable.ApplyLogOnInfo(crtablelogoninfo); } cryRpt.SetParameterValue("startDate", "2016-01-01"); cryRpt.SetParameterValue("endDate", Convert.ToDateTime("2018-04-04")); cryRpt.SetParameterValue("accountNumber", "01320360047701"); crystalReportViewer1.ReportSource = cryRpt; crystalReportViewer1.Refresh(); //cryRpt.SetDatabaseLogon("db2inst4", "db2inst4", "192.168.12.116", "AIBSIT"); // //cryRpt.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, "D:\\myfile.pdf"); }
private void ShowReport(DataTable dtReportData) { ConnectionInfo crConnectionInfo = new ConnectionInfo(); // crConnectionInfo.ServerName = ConfigurationManager.ConnectionStrings["cryServer"].ToString(); // crConnectionInfo.DatabaseName = ConfigurationManager.ConnectionStrings["cryDatabase"].ToString(); // crConnectionInfo.UserID = ConfigurationManager.ConnectionStrings["cryUserID"].ToString(); // crConnectionInfo.Password = ConfigurationManager.ConnectionStrings["cryPass"].ToString(); // ReportDocument rdoc = new ReportDocument(); // // rdoc.SetDatabaseLogon("sa", "123"); // rdoc.Load(ReportPaths + "rpt_SalesReport.rpt"); // rdoc.SetDatabaseLogon(crConnectionInfo.UserID, crConnectionInfo.Password, crConnectionInfo.ServerName, crConnectionInfo.DatabaseName, false); // rdoc.SetDataSource(dtReportData); //// rdoc.SetDatabaseLogon("sa", "123", servername, "WAREHOUSE"); // crystalReportViewer1.ReportSource = rdoc; // crystalReportViewer1.RefreshReport(); ReportDocument cryRpt = new ReportDocument(); TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); // ConnectionInfo crConnectionInfo = new ConnectionInfo(); Tables CrTables; cryRpt.Load(ReportPaths + "rpt_SalesReport.rpt"); crConnectionInfo.ServerName = ConfigurationManager.ConnectionStrings["cryServer"].ToString(); crConnectionInfo.DatabaseName = ConfigurationManager.ConnectionStrings["cryDatabase"].ToString(); crConnectionInfo.UserID = ConfigurationManager.ConnectionStrings["cryUserID"].ToString(); crConnectionInfo.Password = ConfigurationManager.ConnectionStrings["cryPass"].ToString(); CrTables = cryRpt.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } cryRpt.SetDataSource(dtReportData); crystalReportViewer1.ReportSource = cryRpt; crystalReportViewer1.Refresh(); }
public static bool Print(string reportName, int copies, List <KeyValuePair <string, object> > Param_Values) { ReportDocument _reportDocument = new ReportDocument(); TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); Tables CrTables; bool status = false; _reportDocument.Load(AppDomain.CurrentDomain.BaseDirectory.ToString() + "\\Reports\\" + reportName); string[] LoginData = ConfigurationManager.ConnectionStrings["Production"].ConnectionString.ToString().Split(';'); if (!string.IsNullOrEmpty(LoginData[3].ToString()) && LoginData[3].ToString() != "") { crConnectionInfo.Password = LoginData[3].Split('=')[1].ToString(); } crConnectionInfo.UserID = LoginData[2].Split('=')[1].ToString(); crConnectionInfo.DatabaseName = LoginData[1].Split('=')[1]; crConnectionInfo.ServerName = LoginData[0].Split('=')[1]; CrTables = _reportDocument.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } _reportDocument.Refresh(); // set report Parameter if (Param_Values != null) { foreach (KeyValuePair <string, object> Param_Value in Param_Values) { // _reportDocument.SetParameterValue("SalesHeaderID",Param_Value.Value); _reportDocument.SetParameterValue((string)Param_Value.Key, (object)Param_Value.Value); } } for (int i = 0; i < copies; i++) { _reportDocument.PrintToPrinter(1, true, 0, 0); status = true; } return(status); }
private void Generate_Reports() { TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); Tables CrTables; var todaysDate = DateTime.Today; if (!string.IsNullOrEmpty(hdnpcdfrom.Value)) { todaysDate = DateTime.ParseExact(hdnpcdfrom.Value, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture); } var todaysDate1 = DateTime.Today; if (!string.IsNullOrEmpty(hdnpcdto.Value)) { todaysDate1 = DateTime.ParseExact(hdnpcdto.Value, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture); } cryRpt.Load(Server.MapPath("Executive_Sumary_PCD.rpt")); //C:\Users\Joseph\Documents\Visual Studio 2008\Projects\TestCML\Techniques\TestTechniques\ProjectSummary_testing.rpt crConnectionInfo.ServerName = Constants.CMLTConstants.serverName; crConnectionInfo.DatabaseName = Constants.CMLTConstants.dbName; crConnectionInfo.UserID = Constants.CMLTConstants.dbUserName; crConnectionInfo.Password = Constants.CMLTConstants.dbPassword; cryRpt.SetDatabaseLogon(crConnectionInfo.UserID, crConnectionInfo.Password, crConnectionInfo.ServerName, crConnectionInfo.DatabaseName); cryRpt.VerifyDatabase(); CrTables = cryRpt.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } CrystalReportViewer2.ReportSource = null; cryRpt.SetParameterValue("project", (string)Session["projectname"]); cryRpt.SetParameterValue("DateFrom", todaysDate); cryRpt.SetParameterValue("DateTo", todaysDate1); cryRpt.SetParameterValue("ServiceType", ddlService.SelectedValue); CrystalReportViewer2.ReportSource = cryRpt; CrystalReportViewer2.DataBind(); Session["Report"] = cryRpt; }
private void button2_Click(object sender, EventArgs e) { //{ // DateWiseTransaction f2 = new DateWiseTransaction(); // this.Visible = false; // f2.ShowDialog(); // this.Visible = true; //} //AccountWiseTransaction f2 = new AccountWiseTransaction(); //this.Visible = false; //f2.ShowDialog(); //this.Visible = true; //Step1BankReconciliationAllTran f2 = new Step1BankReconciliationAllTran(); //this.Visible = false; //f2.ShowDialog(); //this.Visible = true; ReportViewer f2 = new ReportViewer(); TableLogOnInfos reportLogonInfos = new TableLogOnInfos(); TableLogOnInfo reportLogonInfo = new TableLogOnInfo(); ConnectionInfo reportConInfo = new ConnectionInfo(); Tables tables = default(Tables); // Table table = default(Table); var with1 = reportConInfo; with1.ServerName = "LAPTOP-19NF5E9"; with1.DatabaseName = "BankReconciliationDBProNovember"; with1.UserID = "sa"; with1.Password = "******"; Step1ReconciliationBank1Account1DateRange cr = new Step1ReconciliationBank1Account1DateRange(); tables = cr.Database.Tables; foreach (Table table in tables) { reportLogonInfo = table.LogOnInfo; reportLogonInfo.ConnectionInfo = reportConInfo; table.ApplyLogOnInfo(reportLogonInfo); } //f2.crystalReportViewer1.ParameterFieldInfo = paramFields; //set the parameterfield information in the crystal report f2.crystalReportViewer1.ReportSource = cr; this.Visible = false; f2.ShowDialog(); this.Visible = true; }
private void CrystalReportForm_Load(object sender, EventArgs e) { Comanda comanda = new Comanda(); String query = "SELECT Agencies.CodeAgency, Planets.DescPlanet, OperationalAreas.CodeOperationalArea, Factories.codeFactory, Factories.DescFactory, Orders.codeOrder, Orders.dateOrder, Priority.DescPriority, OrdersDetail.Quantity, OrdersDetail.DeliveryDate, \"References\".codeReference, \"References\".descReference FROM ((((SecureCore.dbo.OrdersDetail OrdersDetail INNER JOIN (((SecureCore.dbo.OrderInfo OrderInfo INNER JOIN SecureCore.dbo.Agencies Agencies ON OrderInfo.idAgency=Agencies.idAgency) INNER JOIN SecureCore.dbo.OperationalAreas OperationalAreas ON OrderInfo.idOperationalArea=OperationalAreas.idOperationalArea) INNER JOIN SecureCore.dbo.Orders Orders ON OrderInfo.idOrder=Orders.idOrder) ON OrdersDetail.idOrder=Orders.idOrder) INNER JOIN SecureCore.dbo.Planets Planets ON OrdersDetail.idPlanet=Planets.idPlanet) INNER JOIN SecureCore.dbo.\"References\" \"References\" ON OrdersDetail.idReference=\"References\".idReference) INNER JOIN SecureCore.dbo.Factories Factories ON Orders.IdFactory=Factories.idFactory) INNER JOIN SecureCore.dbo.Priority Priority ON Orders.IdPriority=Priority.idPriority"; query += " WHERE Orders.idOrder = " + OrderModel.OrderCode + ""; ParameterFields parameterFields = new ParameterFields(); ParameterField OrderCodeParameter = new ParameterField(); OrderCodeParameter.Name = "codeOrder"; ParameterDiscreteValue val = new ParameterDiscreteValue(); val.Value = OrderModel.OrderCode; OrderCodeParameter.CurrentValues.Add(val); parameterFields.Add(OrderCodeParameter); crvComanda.ParameterFieldInfo = parameterFields; // TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); Tables CrTables; crConnectionInfo.ServerName = "DESKTOP-8FAQTCN\\SQLEXPRESS"; crConnectionInfo.DatabaseName = "SecureCore"; crConnectionInfo.UserID = "sa"; crConnectionInfo.Password = "******"; CrTables = comanda.Database.Tables; foreach (Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } dts = bd.PortarPerConsulta(query); comanda.SetDataSource(dts.Tables[0]); crvComanda.ReportSource = comanda; crvComanda.Refresh(); }
public static CrystalDecisions.Windows.Forms.CrystalReportViewer ViewReport(string reportName, List<KeyValuePair<string, object>> Param_Values) { ReportDocument _reportDocument = new ReportDocument(); CrystalDecisions.Windows.Forms.CrystalReportViewer crystalReportViewer1 = new CrystalDecisions.Windows.Forms.CrystalReportViewer(); crystalReportViewer1.ToolPanelView = CrystalDecisions.Windows.Forms.ToolPanelViewType.None; TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); Tables crTables; // load report _reportDocument.Load(AppDomain.CurrentDomain.BaseDirectory.ToString() + "\\Reports\\" + reportName); // set report Connection info string[] LoginData = ConfigurationManager.ConnectionStrings["Local"].ConnectionString.ToString().Split(';'); if (!string.IsNullOrEmpty(LoginData[3].ToString()) && LoginData[3].ToString() != "") crConnectionInfo.Password = LoginData[3].Split('=')[1].ToString(); crConnectionInfo.UserID = LoginData[2].Split('=')[1].ToString(); crConnectionInfo.DatabaseName = LoginData[1].Split('=')[1]; crConnectionInfo.ServerName = LoginData[0].Split('=')[1]; crTables = _reportDocument.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in crTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } _reportDocument.Refresh(); // set report Parameter if (Param_Values != null) { foreach (KeyValuePair<string, object> Param_Value in Param_Values) { // _reportDocument.SetParameterValue("SalesHeaderID",Param_Value.Value); _reportDocument.SetParameterValue((string)Param_Value.Key, (object)Param_Value.Value); } } crystalReportViewer1.ReportSource = _reportDocument; crystalReportViewer1.Refresh(); crystalReportViewer1.Name = "crystalReportViewer1"; return crystalReportViewer1; }
ReportDocument ReportSourceSetup(string crFileInfo, ConnectionInfo crConnectionInfo) { ReportDocument crDoc = new ReportDocument(); TableLogOnInfos crTableLogonInfos = new TableLogOnInfos(); TableLogOnInfo crTableLogonInfo = new TableLogOnInfo(); Tables crTables; crDoc.Load(crFileInfo); crDoc.SetParameterValue("id", id); crTables = crDoc.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables) { crTableLogonInfo = crTable.LogOnInfo; crTableLogonInfo.ConnectionInfo = crConnectionInfo; crTable.ApplyLogOnInfo(crTableLogonInfo); } return(crDoc); }
private void btnShowReport_Click(object sender, EventArgs e) { ReportDocument cryRpt = new ReportDocument(); cryRpt.Load(AppDomain.CurrentDomain.BaseDirectory + @"\RptPatHist.rpt"); //pangalan nung report mo TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); ParameterFieldDefinitions crParameterFieldDefinitions; ParameterFieldDefinition crParameterFieldDefinition; ParameterValues crParameterValues = new ParameterValues(); ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue(); /*crParameterDiscreteValue.Value = dateTimePicker1.Text; //pangalan nung datetime picker mo tas .Text * crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields; * crParameterFieldDefinition = crParameterFieldDefinitions["FROM"]; //pangalan nung parameter mo * crParameterValues = crParameterFieldDefinition.CurrentValues; * * crParameterValues.Clear(); * crParameterValues.Add(crParameterDiscreteValue); * crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); */ //MessageBox.Show(comboBox1.GetItemText(comboBox1.SelectedItem)); crParameterDiscreteValue.Value = comboBox1.GetItemText(comboBox1.SelectedItem); //pangalan nung datetime picker mo tas .Text crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions["PatID"]; //pangalan nung parameter mo crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Clear(); crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); crConnectionInfo.ServerName = FormLogIn.ServerName; crConnectionInfo.DatabaseName = FormLogIn.DatabaseName; crConnectionInfo.UserID = FormLogIn.UserID; crConnectionInfo.Password = FormLogIn.Password; crystalReportViewer1.ReportSource = cryRpt; //yung crystalreportviewer4 yan yung pangalan nung reportviewer mo crystalReportViewer1.Refresh(); }
public static bool Print(string reportName, int copies, List<KeyValuePair<string, object>> Param_Values) { ReportDocument _reportDocument = new ReportDocument(); TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); Tables CrTables; bool status = false; _reportDocument.Load(AppDomain.CurrentDomain.BaseDirectory.ToString() + "\\Reports\\" + reportName); string[] LoginData = ConfigurationManager.ConnectionStrings["Production"].ConnectionString.ToString().Split(';'); if (!string.IsNullOrEmpty(LoginData[3].ToString()) && LoginData[3].ToString() != "") crConnectionInfo.Password = LoginData[3].Split('=')[1].ToString(); crConnectionInfo.UserID = LoginData[2].Split('=')[1].ToString(); crConnectionInfo.DatabaseName = LoginData[1].Split('=')[1]; crConnectionInfo.ServerName = LoginData[0].Split('=')[1]; CrTables = _reportDocument.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } _reportDocument.Refresh(); // set report Parameter if (Param_Values != null) { foreach (KeyValuePair<string, object> Param_Value in Param_Values) { // _reportDocument.SetParameterValue("SalesHeaderID",Param_Value.Value); _reportDocument.SetParameterValue((string)Param_Value.Key, (object)Param_Value.Value); } } for (int i = 0; i < copies; i++) { _reportDocument.PrintToPrinter(1, true, 0, 0); status = true; } return status; }
private static void DataBaseLogIn(ReportDocument rpt) { ConnectionInfo con_info = new ConnectionInfo(); TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); Tables crTables; con_info.ServerName = Connection().DataSource; con_info.DatabaseName = Connection().InitialCatalog; con_info.UserID = Connection().UserID; con_info.Password = Connection().Password; crTables = rpt.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables) { crtableLogoninfo = crTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = con_info; crTable.ApplyLogOnInfo(crtableLogoninfo); } }
protected void Page_Load(object sender, EventArgs e) { ConnectionInfo connRPT = new ConnectionInfo(); TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); connRPT.DatabaseName = System.Configuration.ConfigurationManager.ConnectionStrings["databasename"].ConnectionString; connRPT.UserID =System.Configuration.ConfigurationManager.ConnectionStrings["userID"].ConnectionString; connRPT.Password = System.Configuration.ConfigurationManager.ConnectionStrings["userPassword"].ConnectionString; connRPT.ServerName = System.Configuration.ConfigurationManager.ConnectionStrings["serverName"].ConnectionString; this.CrystalReportViewer1.ReportSource = Server.MapPath("Cr1.rpt"); crtableLogoninfos = this.CrystalReportViewer1.LogOnInfo; foreach (TableLogOnInfo crtableLogoninfo in crtableLogoninfos) { //( myTableLogOnInfo As TableLogOnInfo In myTableLogOnInfos) crtableLogoninfo.ConnectionInfo = connRPT; } //CrystalReportViewer1.SelectionFormula = "{DOCTOR_REQ.routine_type} = 'CHEMISTRY' and {DOCTOR_REQ.admission_no} = " + admissionNo + // " and {DOCTOR_REQ.date_req} =" + sqlQ(formatMonth(dateToday.Month) + "/" + formatMonth(dateToday.Day) + "/" + dateToday.Year); //CrystalReportViewer1.ParameterFieldInfo["REPORTTITLE"].ReportName = "LABORATORY"; }
protected void Page_Load(object sender, EventArgs e) { CrystalReportViewer_DownloadFiles.ToolPanelView = CrystalDecisions.Web.ToolPanelViewType.None; ReportDocument rptDoc = new ReportDocument(); TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); // Tables CrTables; crConnectionInfo.ServerName = objDbAccess.strServer; crConnectionInfo.DatabaseName = objDbAccess.strDbName; crConnectionInfo.UserID = objDbAccess.strUser; crConnectionInfo.Password = objDbAccess.strPassword; UserList ds = new UserList(); // .xsd file name DataTable dt = new DataTable(); // Just set the name of data table dt.TableName = "DownloadHistory"; dt = objReports.GetDownloadReports(); //This function is located below this function ds.Tables[0].Merge(dt); // Your .rpt file path will be below rptDoc.Load(Server.MapPath("~/Reports/ListDownload.rpt")); foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in rptDoc.Database.Tables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } // crtableLogoninfo.ConnectionInfo = crConnectionInfo; //set dataset to the report viewer. rptDoc.SetDataSource(ds); CrystalReportViewer_DownloadFiles.ReportSource = rptDoc; }
protected void Page_Load(object sender, EventArgs e) { string cs = ConfigurationManager.ConnectionStrings["BarsslsConnection"].ConnectionString; using (SqlConnection con = new SqlConnection(cs)) { SqlDataAdapter da = new SqlDataAdapter(@" SELECT customers.customer_name, customers.sales_rep, customers.customer_type, customers.RW_rep_ID, customers.date_opened, customers.broker_ID, customers.cust_region " + "FROM BARSSLS.dbo.customers customers ", con); DataSet ds = new DataSet(); ReportDocument rd = new ReportDocument(); rd.Load(Server.MapPath("~/Reports/CrystalReps.rpt")); rd.Refresh(); rd.SetDataSource(ds);// if you have any data source CrystalReportViewer1.ReportSource = rd; CrystalReportViewer1.DataBind(); ConnectionInfo myConnectionInfo = new ConnectionInfo(); myConnectionInfo.ServerName = "corp-bi-dev01"; myConnectionInfo.DatabaseName = "BARSSLS"; myConnectionInfo.UserID = "weboe"; myConnectionInfo.Password = "******"; TableLogOnInfos mytableloginfos = new TableLogOnInfos(); mytableloginfos = CrystalReportViewer1.LogOnInfo; foreach (TableLogOnInfo myTableLogOnInfo in mytableloginfos) { myTableLogOnInfo.ConnectionInfo = myConnectionInfo; } //setDBLOGONforREPORT(myConnectionInfo); } }
private void btnExecute_Click(object sender, EventArgs e) { ReportDocument report = new ReportDocument(); report.Load(this.filePath); report.SetDatabaseLogon(userName, password, server, db); ParameterFieldDefinitions crParameterFieldDefinitions; ParameterFieldDefinition crParameterFieldDefinition; ParameterValues crParameterValues = new ParameterValues(); ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue(); //order no crParameterDiscreteValue.Value = txtFilter.Text; crParameterFieldDefinitions = report.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions["orderNo"]; crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Clear(); crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); //start date crParameterDiscreteValue.Value = dtpStartDate.Value; crParameterFieldDefinitions = report.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions["startDate"]; crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Clear(); crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); //end date crParameterDiscreteValue.Value = dtpEndDate.Value; crParameterFieldDefinitions = report.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions["endDate"]; crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Clear(); crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); ConnectionInfo crConnectionInfo = new ConnectionInfo(); crConnectionInfo.ServerName = server; crConnectionInfo.DatabaseName = db; crConnectionInfo.UserID = userName; crConnectionInfo.Password = password; TableLogOnInfo logOnInfo = new TableLogOnInfo(); logOnInfo.ConnectionInfo = crConnectionInfo; TableLogOnInfos logOnInfos = new TableLogOnInfos(); logOnInfos.Add(logOnInfo); crystalReportViewer.LogOnInfo = logOnInfos; crystalReportViewer.ReportSource = report; crystalReportViewer.Refresh(); }
private string exportCrystalReports(string crUserID, string crPassword) { //Instanciation des classes permettant l'exportation des données ReportDocument cryRpt = new ReportDocument(); TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); Tables CrTables; //Enregistre le chemin du répertoire de sortie du projet --> répertoire de sortie veut dire Debug ou Release var outPutDirectory = Path.GetDirectoryName(Assembly.GetExecutingAssembly().CodeBase); //Répertoire où se trouve le fichier .rpt var rptPath = Path.Combine(outPutDirectory, "Reports\\Serveur mail - OT quotidiens.rpt"); //Cast en chaine de caractere de rptPath string rpt_path = new Uri(rptPath).LocalPath; //Répertoire où se trouve le PDF envoyé par mail var pdfPath = Path.Combine(outPutDirectory, "Reports\\Serveur mail - OT quotidiens.pdf"); //Cast en chaine de caractere de pdfPath string pdf_path = new Uri(pdfPath).LocalPath; try { //Chargement du rapport dans cette instance cryRpt.Load(rpt_path); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } //Paramétres de la base de données crConnectionInfo.UserID = crUserID; crConnectionInfo.Password = crPassword; CrTables = cryRpt.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } try { crystalReportViewer4.ReportSource = cryRpt; crystalReportViewer4.Refresh(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } try { //Paramètres d'exportation du fichier .rpt ExportOptions CrExportOptions; DiskFileDestinationOptions CrDiskFileDestinationOptions = new DiskFileDestinationOptions(); PdfRtfWordFormatOptions CrFormatTypeOptions = new PdfRtfWordFormatOptions(); CrDiskFileDestinationOptions.DiskFileName = pdf_path; CrExportOptions = cryRpt.ExportOptions; { CrExportOptions.ExportDestinationType = ExportDestinationType.DiskFile; CrExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat; CrExportOptions.DestinationOptions = CrDiskFileDestinationOptions; CrExportOptions.FormatOptions = CrFormatTypeOptions; } cryRpt.Export(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } return pdf_path; }
private void Form1_Load(object sender, EventArgs e) { DateTime today = DateTime.Today; //Initialisation du Timer TBSeco.Enabled = false; TBMinu.Enabled = false; TBHour.Enabled = false; //_____________________________ //Initialisation des TextBoxes FromEmail = "*****@*****.**"; FromName = "Coswin"; ToList = "*****@*****.**"; Subject = "Rapport journalier du " + today.ToString("dd/MM/yyyy"); Body = String.Format ( "Please, do not reply to this message." ); SMTPserver = "139.128.51.129"; IDstr = ""; Port = 25; bSSL = false; Password = ""; crUserID = "cossechar"; crPassword = "******"; TBSMTP.Text = SMTPserver; TBID.Text = IDstr; TBPORT.Text = Port.ToString(); MBTPASS.Text = Password; TBOID.Text = crUserID; MTBPASS.Text = crPassword; TBFROM.Text = FromEmail; TBTO.Text = ToList; TBAKA.Text = FromName; TBSUBJECT.Text = Subject; RTBBODY.Text = Body; //____________________________ //Initialisation des CheckBoxes CBSSL.CheckState = CheckState.Unchecked; CBLSC.CheckState = CheckState.Unchecked; //____________________________ MailSent = false; //Instanciation des classes permettant l'exportation des données ReportDocument cryRpt = new ReportDocument(); TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); Tables CrTables; //Enregistre le chemin du répertoire de sortie du projet --> répertoire de sortie veut dire Debug ou Release var outPutDirectory = Path.GetDirectoryName(Assembly.GetExecutingAssembly().CodeBase); //Répertoire où se trouve le fichier .rpt var rptPath = Path.Combine(outPutDirectory, "Reports\\Serveur mail - OT quotidiens.rpt"); //Cast en chaine de caractere de rptPath string rpt_path = new Uri(rptPath).LocalPath; cryRpt.Load(rpt_path); //Paramétres de la base de données crConnectionInfo.UserID = "cossechar"; crConnectionInfo.Password = "******"; CrTables = cryRpt.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } crystalReportViewer4.ReportSource = cryRpt; crystalReportViewer4.Zoom(75); crystalReportViewer4.Refresh(); }
public void ShowReport(CrystalReportViewer rptView, DataSet ds, int tblIndex, string path, string sSelectionFormula, ArrayList lstParam = null, ArrayList paramName = null) { //CrystalDecisions.CrystalReports.Engine.ReportDocument obj = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); int pCount; ParameterFields paramFields = new ParameterFields(); try { objReport = new ReportDocument(); objReport.Load(Application.StartupPath + "\\Report\\RptBom.Rpt"); TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); Tables CrTables; crConnectionInfo.ServerName = path; crConnectionInfo.DatabaseName = path; crConnectionInfo.UserID = ""; crConnectionInfo.Password = ""; CrTables = objReport.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } if (lstParam != null) { pCount = lstParam.Count; for (int i = 0; i < pCount; i++) { ParameterField paramField = new ParameterField(); ParameterDiscreteValue discreteVal = new ParameterDiscreteValue(); paramField.ParameterFieldName = paramName[i].ToString(); // Set the discrete value and pass it to the parameter discreteVal.Value = lstParam[i].ToString(); paramField.CurrentValues.Add(discreteVal); // Add parameter to the parameter fields collection. paramFields.Add(paramField); } } if (sSelectionFormula.Length > 0) { objReport.RecordSelectionFormula = sSelectionFormula; } rptView.ReportSource = null; rptView.ParameterFieldInfo = paramFields; rptView.ReuseParameterValuesOnRefresh = true; rptView.ReportSource = objReport; for (int i = 0; i < rptView.LogOnInfo.Count; i++) { rptView.LogOnInfo[i].ConnectionInfo = crConnectionInfo; } rptView.Refresh(); rptView.Show(); //objReport.Database.Dispose(); //objReport.Dispose(); //objReport.Close(); } catch (Exception ex) { throw new Exception(ex.Message.ToString()); } finally { //objReport.Database.Dispose(); //objReport.Dispose(); //objReport.Close(); //paramFields = null; } }
ReportDocument ReportSourceSetup(string sPath, ConnectionInfo crConnectionInfo) { ReportDocument crDoc = new ReportDocument(); TableLogOnInfos crTableLogonInfos = new TableLogOnInfos(); TableLogOnInfo crTableLogonInfo = new TableLogOnInfo(); Tables crTables; crDoc.Load(sPath); // Each table in report needs to have logoninfo setup: crTables = crDoc.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables) { crTableLogonInfo = crTable.LogOnInfo; crTableLogonInfo.ConnectionInfo = crConnectionInfo; crTable.ApplyLogOnInfo(crTableLogonInfo); } return crDoc; }