public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
        {
            CrossPropertyLiabilityTransferSummaryReport rpt = new CrossPropertyLiabilityTransferSummaryReport();

            rpt.Site = this.Site;
            return(rpt);
        }
        internal void ShowCrossPropertyLiabilityTransferSummaryReport(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 vCrossPropertyLiabilityTransferSummaryReport = new CrossPropertyLiabilityTransferSummaryReport();

                vCrossPropertyLiabilityTransferSummaryReport.SetDataSource(dtDataset);

                vCrossPropertyLiabilityTransferSummaryReport.SetParameterValue("@STARTDATE", StartDate);
                vCrossPropertyLiabilityTransferSummaryReport.SetParameterValue("@ENDDATE", EndDate);

                GetVersion_SiteName(out  sVersion, out  sSiteName);
                vCrossPropertyLiabilityTransferSummaryReport.SetParameterValue("SiteCode", Settings.SiteCode);
                vCrossPropertyLiabilityTransferSummaryReport.SetParameterValue("siteName", sSiteName);
                vCrossPropertyLiabilityTransferSummaryReport.SetParameterValue("BMCVersion", sVersion);
                vCrossPropertyLiabilityTransferSummaryReport.SetParameterValue("CurrencyCulture", ExtensionMethods.CurrentCurrenyCulture);
                vCrossPropertyLiabilityTransferSummaryReport.SetParameterValue("CurrencySymbol", ExtensionMethods.CurrentCurrenyCulture.GetCurrencySymbol());
                vCrossPropertyLiabilityTransferSummaryReport.SetParameterValue("DateCulture", ExtensionMethods.CurrentDateCulture);


                crDatabase = vCrossPropertyLiabilityTransferSummaryReport.Database;
                crTables = crDatabase.Tables;

                foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables)
                {
                    tableLogonInfo = crTable.LogOnInfo;
                    tableLogonInfo.ConnectionInfo = connectionInfo;
                    crTable.ApplyLogOnInfo(tableLogonInfo);
                }


                crystalReportViewer.ReportSource = vCrossPropertyLiabilityTransferSummaryReport;

                AuditReports();

                strReportName = "Cross Property Liability Transfer Summary Report";
            }
            catch (Exception ex)
            {
                ExceptionManager.Publish(ex);
            }
        }
 public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() {
     CrossPropertyLiabilityTransferSummaryReport rpt = new CrossPropertyLiabilityTransferSummaryReport();
     rpt.Site = this.Site;
     return rpt;
 }