Quote: objRep.cry_rp1.ReportSource = Application.StartupPath + @"\Reports\Crt_Purchase_Order.rpt"; objRep.cry_rp1.SelectionFormula = "{OT_PURCHASE_ORDER.PO_Tran_Code} = '" + txtrancode.Text+"/"+txtdocno.Text + "' ";
Quote: private void ConfigureCrystalReports() { string Crystaluser = Convert.ToString(System.Configuration.ConfigurationSettings.AppSettings["Crystaluser"]); string CrystalPasword = Convert.ToString(System.Configuration.ConfigurationSettings.AppSettings["CrystalPassword"]); string CrystalDatasource = Convert.ToString(System.Configuration.ConfigurationSettings.AppSettings["CrystalDatasource"]); string CrystalHostname = Convert.ToString(System.Configuration.ConfigurationSettings.AppSettings["CrystalHostname"]); ConnectionInfo connectionInfo = new ConnectionInfo(); connectionInfo.ServerName = CrystalHostname; connectionInfo.DatabaseName = CrystalDatasource; connectionInfo.UserID = Crystaluser; connectionInfo.Password = CrystalPasword; connectionInfo.IntegratedSecurity = false; SetDBLogonForReport(connectionInfo); } private void SetDBLogonForReport(ConnectionInfo connectionInfo) { TableLogOnInfos tableLogOnInfos = cry_rp1.LogOnInfo; foreach (TableLogOnInfo tableLogOnInfo in tableLogOnInfos) { tableLogOnInfo.ConnectionInfo = connectionInfo; } }
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)