public void SetDatabase(ReportDocument Rpt) { CrystalDecisions.CrystalReports.Engine.Database crDatabase; CrystalDecisions.CrystalReports.Engine.Tables crTables; CrystalDecisions.Shared.TableLogOnInfos MyTableLogOnInfos = new CrystalDecisions.Shared.TableLogOnInfos(); CrystalDecisions.Shared.TableLogOnInfo MyTableLogOnInfo = new CrystalDecisions.Shared.TableLogOnInfo(); CrystalDecisions.Shared.ConnectionInfo MyConnectionInfo = new CrystalDecisions.Shared.ConnectionInfo(); //conStr = Session["Connectionstring"].ToString(); MyTableLogOnInfo.ConnectionInfo = SetConnectionString(MyConnectionInfo, ConnectionString); MyTableLogOnInfos.Add(MyTableLogOnInfo); AdminActivityCRViewer.LogOnInfo = MyTableLogOnInfos; crDatabase = Rpt.Database; crTables = crDatabase.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables) { MyTableLogOnInfo = crTable.LogOnInfo; MyTableLogOnInfo.ConnectionInfo = MyConnectionInfo; crTable.ApplyLogOnInfo(MyTableLogOnInfo); } setParameters(Rpt); }
void previewID() { try { CrystalDecisions.CrystalReports.Engine.ReportDocument objReport = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); CrystalDecisions.Shared.TableLogOnInfos crtableLogoninfos = new CrystalDecisions.Shared.TableLogOnInfos(); CrystalDecisions.Shared.TableLogOnInfo ConInfo = new CrystalDecisions.Shared.TableLogOnInfo(); CrystalDecisions.Shared.ConnectionInfo crConnectionInfo = new CrystalDecisions.Shared.ConnectionInfo(); CrystalDecisions.CrystalReports.Engine.Tables CrTables; CrystalDecisions.Shared.ParameterValues crParameterValues = new CrystalDecisions.Shared.ParameterValues(); CrystalDecisions.Shared.ParameterDiscreteValue crParameterDiscreteValue = new CrystalDecisions.Shared.ParameterDiscreteValue(); //objReport.Load(LoadReport()); objReport.Load(_path + _reportName_Outside); string sUserID = "sa"; string sPassword = "******"; string sServerName = "192.168.1.42"; string sDatabaseName = "HRIS"; crConnectionInfo.ServerName = sServerName; crConnectionInfo.DatabaseName = sDatabaseName; crConnectionInfo.UserID = sUserID; crConnectionInfo.Password = sPassword; CrTables = objReport.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { ConInfo = CrTable.LogOnInfo; ConInfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(ConInfo); } reportViewer.ViewerCore.ReportSource = objReport; //rekta print //objReport.PrintToPrinter(1, true, 0, 0); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }