Update Custom Report

Updating the Custom Report involves the following steps:

• Add new Data Source: ibReports to Report (connection string to BatchHistory database)

• Update Report Datasets to use the new ibReports Data Source; change the Data source from “aaReports” to “ibReports”

  • Update LayoutColorCodes dataset

  • Update SystemParameters dataset

  • Update Report Datasets to use the new ibReports Data Source

• Add new Data set ReportingTimeZones to report

• Add reference to BatchTimeExtension Assembly in Report

• Update Report

  • Update main dataset expression and dataset field list

  • Add DateTime UTC column (if applicable)

• Create new Parameter: ReportingTimeZone

  • Add new Parameter: ReportingTimeZone to report, under the StartDateTime and EndDateTime parameters

  • Use ReportingTimeZones dataset to get data

• Update all Report Datasets expression

• Add new Report Code to Report

  • TimeZoneToUtc, UtcToTimeZone, GetTimeZoneDateTime, GetTimeZoneOffset, GetReportDateRange, GetReportDateColumn, GetTimeZoneSuffix, GetServerTimeZoneSuffix, and GetFixedStringFormat

• Update Existing Report Code

  • Create ValidValues Dataset

• Other Report updates

  • Update Report WhereClause to use new GetReportDateRange Function

  • Remove Deprecated WIS Report Items

    • Datasets: LayoutDurationChoices, LayoutTimeZoneInfo, Timezone (If applicable)

    • Parameters: Duration, TimeZoneId (If applicable)