public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { CrossPropertyTicketAnalysis rpt = new CrossPropertyTicketAnalysis(); rpt.Site = this.Site; return(rpt); }
internal void ShowCrossPropertyTicketAnalysisReport(string p, DataSet dtDataset, DateTime StartDate, DateTime EndDate) { try { CrystalDecisions.CrystalReports.Engine.Database crDatabase; CrystalDecisions.CrystalReports.Engine.Tables crTables; TableLogOnInfo tableLogonInfo = new TableLogOnInfo(); ConnectionInfo connectionInfo = new ConnectionInfo(); DbConnectionDetails.DatabaseName = "TICKETING"; connectionInfo.ServerName = DbConnectionDetails.ServerName; connectionInfo.UserID = DbConnectionDetails.UserName; connectionInfo.Password = DbConnectionDetails.Password; connectionInfo.DatabaseName = DbConnectionDetails.DatabaseName; string sVersion, sSiteName; var vCrossPropertyTicketAnalysis = new CrossPropertyTicketAnalysis(); vCrossPropertyTicketAnalysis.SetDataSource(dtDataset); vCrossPropertyTicketAnalysis.SetParameterValue("SiteCode", Settings.SiteCode); vCrossPropertyTicketAnalysis.SetParameterValue("fromDate", StartDate); vCrossPropertyTicketAnalysis.SetParameterValue("toDate", EndDate); vCrossPropertyTicketAnalysis.SetParameterValue("@STARTDATE", StartDate); vCrossPropertyTicketAnalysis.SetParameterValue("@ENDDATE", EndDate); GetVersion_SiteName(out sVersion, out sSiteName); vCrossPropertyTicketAnalysis.SetParameterValue("siteName", sSiteName); vCrossPropertyTicketAnalysis.SetParameterValue("BMCVersion", sVersion); vCrossPropertyTicketAnalysis.SetParameterValue("CurrencyCulture", ExtensionMethods.CurrentCurrenyCulture); vCrossPropertyTicketAnalysis.SetParameterValue("CurrencySymbol", ExtensionMethods.CurrentCurrenyCulture.GetCurrencySymbol()); vCrossPropertyTicketAnalysis.SetParameterValue("DateCulture", ExtensionMethods.CurrentDateCulture); crDatabase = vCrossPropertyTicketAnalysis.Database; crTables = crDatabase.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables) { tableLogonInfo = crTable.LogOnInfo; tableLogonInfo.ConnectionInfo = connectionInfo; crTable.ApplyLogOnInfo(tableLogonInfo); } crystalReportViewer.ReportSource = vCrossPropertyTicketAnalysis; AuditReports(); strReportName = "Voucher Listing Report"; } catch (Exception ex) { ExceptionManager.Publish(ex); } }
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { CrossPropertyTicketAnalysis rpt = new CrossPropertyTicketAnalysis(); rpt.Site = this.Site; return rpt; }