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;
}