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 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 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;
}
