public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { PartCollectionReport rpt = new PartCollectionReport(); rpt.Site = this.Site; return(rpt); }
public void ShowPartCollection(int NoofRecords,string ExchangeConn, String TicketingConn) { string sVersion = string.Empty; string sSiteName = string.Empty; try { LogManager.WriteLog("Inside ShowPartCollection method", LogManager.enumLogLevel.Info); GetVersion_SiteName(out sVersion, out sSiteName); CrystalDecisions.CrystalReports.Engine.Database crDatabase; CrystalDecisions.CrystalReports.Engine.Tables crTables; TableLogOnInfo tableLogonInfo = new TableLogOnInfo(); PartCollectionReport Partcol = new PartCollectionReport(); Partcol.SetParameterValue("@NumberofRecords", NoofRecords); Partcol.SetParameterValue("SiteName", sSiteName); Partcol.SetParameterValue("Version", sVersion); Partcol.SetParameterValue("Region", Settings.Region); Partcol.SetParameterValue("CurrencySymbol", ExtensionMethods.CurrentSiteCulture.GetCurrencySymbol()); IReports objReports = ReportsBusinessObject.CreateInstance(ExchangeConn, TicketingConn); List<ServerDetails> DbConnectionInfo = objReports.GetDataBaseConnectionString(ExchangeConn); ConnectionInfo myConnectionInfo = new ConnectionInfo(); myConnectionInfo.ServerName = DbConnectionInfo[0].ServerName; // read this information from config file. myConnectionInfo.DatabaseName = DbConnectionInfo[0].DataBase; // read this information from config file. myConnectionInfo.UserID = DbConnectionInfo[0].Username; // read this information from config file. myConnectionInfo.Password = DbConnectionInfo[0].Password; // read this information from config file. crDatabase = Partcol.Database; crTables = crDatabase.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables) { tableLogonInfo = crTable.LogOnInfo; tableLogonInfo.ConnectionInfo = myConnectionInfo; crTable.ApplyLogOnInfo(tableLogonInfo); } crystalReportViewer.ReportSource = Partcol; AuditReports(); strReportName = "Part Collection Report"; } catch (Exception ex) { throw ex; } }
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { PartCollectionReport rpt = new PartCollectionReport(); rpt.Site = this.Site; return rpt; }