public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { CrossPropertyLiabilityTransferDetailsReport rpt = new CrossPropertyLiabilityTransferDetailsReport(); rpt.Site = this.Site; return(rpt); }
internal void ShowCrossPropertyLiabilityTransferDetailsReport(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 vCrossPropertyLiabilityTransferDetailsReport = new CrossPropertyLiabilityTransferDetailsReport(); vCrossPropertyLiabilityTransferDetailsReport.SetDataSource(dtDataset); vCrossPropertyLiabilityTransferDetailsReport.SetParameterValue("@STARTDATE", StartDate); vCrossPropertyLiabilityTransferDetailsReport.SetParameterValue("@ENDDATE", EndDate); GetVersion_SiteName(out sVersion, out sSiteName); vCrossPropertyLiabilityTransferDetailsReport.SetParameterValue("SiteCode", Settings.SiteCode); vCrossPropertyLiabilityTransferDetailsReport.SetParameterValue("siteName", sSiteName); vCrossPropertyLiabilityTransferDetailsReport.SetParameterValue("BMCVersion", sVersion); vCrossPropertyLiabilityTransferDetailsReport.SetParameterValue("CurrencyCulture", ExtensionMethods.CurrentCurrenyCulture); vCrossPropertyLiabilityTransferDetailsReport.SetParameterValue("CurrencySymbol", ExtensionMethods.CurrentCurrenyCulture.GetCurrencySymbol()); vCrossPropertyLiabilityTransferDetailsReport.SetParameterValue("DateCulture", ExtensionMethods.CurrentDateCulture); crDatabase = vCrossPropertyLiabilityTransferDetailsReport.Database; crTables = crDatabase.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables) { tableLogonInfo = crTable.LogOnInfo; tableLogonInfo.ConnectionInfo = connectionInfo; crTable.ApplyLogOnInfo(tableLogonInfo); } crystalReportViewer.ReportSource = vCrossPropertyLiabilityTransferDetailsReport; AuditReports(); strReportName = "Cross Property Liability Transfer Details Report"; } catch (Exception ex) { ExceptionManager.Publish(ex); } }
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { CrossPropertyLiabilityTransferDetailsReport rpt = new CrossPropertyLiabilityTransferDetailsReport(); rpt.Site = this.Site; return rpt; }