Other Report updates

Item for Update (If applicable)

Expression

Update WhereClause Parameter to use new report GetReportDateRange code

=Code.WhereCondition(Parameters!CampaignIDPattern.Value,

"Campaign_ID",

Parameters!CampaignID.Value) &

Code.WhereCondition(Parameters!LotIDPattern.Value,

"Lot_ID",

Parameters!LotID.Value) &

Code.WhereCondition(Parameters!BatchIDPattern.Value,

"Batch_ID",

Parameters!BatchID.Value) &

Code.WhereCondition(Parameters!BatchServerNamePattern.Value,

"Batch_Server_Name",

Parameters!BatchServerName.Value) &

Code.WhereCondition(Parameters!ConnectionNamePattern.Value, "UnitOrConnection", Parameters!ConnectionName.Value) &

Code.WhereCondition(Parameters!ProcedureIDPattern.Value, "UnitProcedure_ID", Parameters!ProcedureID.Value) &

Code.WhereCondition(Parameters!OperationIDPattern.Value, "Operation_ID", Parameters!OperationID.Value) &

Code.WhereCondition(Parameters!PhaseIDPattern.Value, "Phase_ID", Parameters!PhaseID.Value) &

Code.WhereCondition(Parameters!PhaseLabelPattern.Value, "DoneBy_User_ID", Parameters!PhaseLabel.Value) &

Code.WhereCondition(Parameters!DoneByUserIDPattern.Value, "Phase_Label", Parameters!DoneByUserID.Value) &

Code.WhereCondition(Parameters!CheckedByUserIDPattern.Value, "CheckBy_User_ID", Parameters!CheckedByUserID.Value) &

Code.WhereCondition(Parameters!DescriptionPattern.Value, "Description", Parameters!Description.Value) &

Code.GetReportDateRange(Parameters!ReportingTimeZone.Value, Parameters!ReportingTimeZone.Label, Parameters!StartDateTime.Value, Parameters!EndDateTime.Value)

Update Time Period display to include Time zone suffix

=FORMAT(First(Fields!StartDateTimeLocal.Value, "TimeZone"),"G") &" - "& FORMAT(First(Fields!EndDateTimeLocal.Value, "TimeZone"),"G")

Change to:

=Parameters!StartDateTime.Value & " - " & Parameters!EndDateTime.Value & Code.GetTimeZoneSuffix(Parameters!ReportingTimeZone.Value)

Any Detail Report Heading that display date time. Example IBBatchReport DateTime

="Date/Time" & Code.GetTimeZoneSuffix(Parameters!ReportingTimeZone.Value)

For Report Detail column that display date time.

=Code.GetTimeZoneDateTime(Parameters!ReportingTimeZone.Label, Fields!DateTime.Value, Fields!DateTimeUTC.Value) & " " & Code.GetTimeZoneOffset(Parameters!ReportingTimeZone.Label, Fields!DateTime.Value, Fields!DateTimeUTC.Value)

Remove Deprecated WIS Report Items

Deprecated Datasets

• LayoutDurationChoices, LayoutTimeZoneInfo, TimeZone (If applicable)

  Deprecated Parameters

• Duration, TimeZoneId (If applicable)

Update references to LayoutTimeZoneInfo:

StartDateTimeLocal.Value

=FORMAT(First(Fields!StartDateTimeLocal.Value, "LayoutTimeZoneInfo"),"yyyy'-'MM'-'dd'T'HH':'mm':'ss.fffffffK")

Change to:

=FORMAT(Parameters! StartDateTime.Value,"yyyy'-'MM'-'dd'T'HH':'mm':'ss.fffffffK")

Update references to LayoutTimeZoneInfo:

EndDateTimeUTC.Value

=FORMAT(First(Fields!EndDateTimeUTC.Value, "LayoutTimeZoneInfo"),"yyyy'-'MM'-'dd'T'HH':'mm':'ss.fffffffK")

Change to:

=FORMAT(Parameters!EndDateTime.Value,"yyyy'-'MM'-'dd'T'HH':'mm':'ss.fffffffK")

=FORMAT(First(Fields!StartDateTimeUTC.Value, "LayoutTimeZoneInfo"),"yyyy'-'MM'-'dd'T'HH':'mm':'ss.fffffffK")

Change to:

=FORMAT(Parameters! StartDateTime.Value,"yyyy'-'MM'-'dd'T'HH':'mm':'ss.fffffffK")

=FORMAT(First(Fields!EndDateTimeUTC.Value, "LayoutTimeZoneInfo"),"yyyy'-'MM'-'dd'T'HH':'mm':'ss.fffffffK")

Change to:

=FORMAT(Parameters!EndDateTime.Value,"yyyy'-'MM'-'dd'T'HH':'mm':'ss.fffffffK")

Remove unused datasets

Remove unused datasets that use aaReport Data source

Remove unused report data source

Delete aaReports from Report

Add Time zone suffix to "Generated On" Date time

Change:

="Report Generated On " + FormatDateTime(Globals!ExecutionTime)

To:

="Report Generated On " + FormatDateTime(Globals!ExecutionTime) + Code.GetServerTimeZoneSuffix()