ServiceManager.Report.ChangeManagement.ChangeManagementKPITrend.ReportRdl (ReportResource)

Element properties:

TypeReportResource
File NameServiceManager.Report.ChangeManagement.ChangeManagementKPITrend.rdl
AccessibilityPublic

Source Code:

<ReportResource ID="ServiceManager.Report.ChangeManagement.ChangeManagementKPITrend.ReportRdl" Accessibility="Public" FileName="ServiceManager.Report.ChangeManagement.ChangeManagementKPITrend.rdl" MIMEType="application/octet-stream"/>

File Content: ServiceManager.Report.ChangeManagement.ChangeManagementKPITrend.rdl

<?xml version="1.0" encoding="utf-8"?>

<Report xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition">
<DataSources>
<DataSource Name="DWDataMart">
<DataSourceReference>DWDataMart</DataSourceReference>
<rd:DataSourceID>f64dfd62-de7c-45ae-9ebe-2f03a22fb300</rd:DataSourceID>
<rd:SecurityType>None</rd:SecurityType>
</DataSource>
<DataSource Name="DWStagingAndConfig">
<DataSourceReference>DWStagingAndConfig</DataSourceReference>
<rd:DataSourceID>ec84d235-e1b4-43cc-8f23-8a42f05d2258</rd:DataSourceID>
<rd:SecurityType>None</rd:SecurityType>
</DataSource>
</DataSources>
<DataSets>
<DataSet Name="List_Status">
<Fields>
<Field Name="Label">
<DataField>Label</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="Value">
<DataField>Value</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>DWDataMart</DataSourceName>
<CommandText>
SELECT @AllLabel AS Label, -1 AS Value
UNION
SELECT DISTINCT
ISNULL(DS.DisplayName, C.ChangeStatusValue) AS Label, ChangeStatusId AS Value
FROM dbo.ChangeStatusvw C
LEFT OUTER JOIN dbo.DisplayStringDimvw DS
ON (C.EnumTypeId = DS.BaseManagedEntityId AND
DS.LanguageCode =@LanguageCode)
WHERE C.ParentId IS NOT NULL
ORDER BY Label

</CommandText>
<QueryParameters>
<QueryParameter Name="@AllLabel">
<Value>=Parameters!AllLabel.Value</Value>
<rd:UserDefined>true</rd:UserDefined>
</QueryParameter>
<QueryParameter Name="@LanguageCode">
<Value>=Code.GetReportLocLanguageCode()</Value>
</QueryParameter>
</QueryParameters>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
</DataSet>
<DataSet Name="List_Priority">
<Fields>
<Field Name="Label">
<DataField>Label</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="Value">
<DataField>Value</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>DWDataMart</DataSourceName>
<CommandText>
SELECT @AllLabel AS Label, -1 AS Value
UNION
SELECT DISTINCT
ISNULL(DS.DisplayName, C.ChangePriorityValue) AS Label,
ChangePriorityId AS Value
FROM dbo.ChangePriorityvw C
LEFT OUTER JOIN dbo.DisplayStringDimvw DS
ON (C.EnumTypeId = DS.BaseManagedEntityId AND
DS.LanguageCode =@LanguageCode)
WHERE C.ParentId IS NOT NULL
ORDER BY Label
</CommandText>
<QueryParameters>
<QueryParameter Name="@AllLabel">
<Value>=Parameters!AllLabel.Value</Value>
<rd:UserDefined>true</rd:UserDefined>
</QueryParameter>
<QueryParameter Name="@LanguageCode">
<Value>=Code.GetReportLocLanguageCode()</Value>
</QueryParameter>
</QueryParameters>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
</DataSet>
<DataSet Name="List_Risk">
<Fields>
<Field Name="Label">
<DataField>Label</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="Value">
<DataField>Value</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>DWDataMart</DataSourceName>
<CommandText>
SELECT @AllLabel AS Label, -1 AS Value
UNION
SELECT DISTINCT
ISNULL(DS.DisplayName, C.ChangeRiskValue ) AS Label,
ChangeRiskId AS Value
FROM dbo.ChangeRiskvw C
LEFT OUTER JOIN dbo.DisplayStringDimvw DS
ON (C.EnumTypeId = DS.BaseManagedEntityId AND
DS.LanguageCode =@LanguageCode)
WHERE C.ParentId IS NOT NULL
ORDER BY Label
</CommandText>
<QueryParameters>
<QueryParameter Name="@AllLabel">
<Value>=Parameters!AllLabel.Value</Value>
<rd:UserDefined>true</rd:UserDefined>
</QueryParameter>
<QueryParameter Name="@LanguageCode">
<Value>=Code.GetReportLocLanguageCode()</Value>
</QueryParameter>
</QueryParameters>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
</DataSet>
<DataSet Name="List_Impact">
<Fields>
<Field Name="Label">
<DataField>Label</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="Value">
<DataField>Value</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>DWDataMart</DataSourceName>
<CommandText>
SELECT @AllLabel AS Label, -1 AS Value
UNION
SELECT DISTINCT
ISNULL(DS.DisplayName, C.ChangeImpactValue) AS Label,
ChangeImpactId AS Value
FROM dbo.ChangeImpactvw C
LEFT OUTER JOIN dbo.DisplayStringDimvw DS
ON (C.EnumTypeId = DS.BaseManagedEntityId AND
DS.LanguageCode =@LanguageCode)
WHERE C.ParentId IS NOT NULL
ORDER BY Label
</CommandText>
<QueryParameters>
<QueryParameter Name="@AllLabel">
<Value>=Parameters!AllLabel.Value</Value>
<rd:UserDefined>true</rd:UserDefined>
</QueryParameter>
<QueryParameter Name="@LanguageCode">
<Value>=Code.GetReportLocLanguageCode()</Value>
</QueryParameter>
</QueryParameters>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
</DataSet>
<DataSet Name="Table_ChangeKPI">
<Fields>
<Field Name="CreatedDate">
<DataField>CreatedDate</DataField>
<rd:TypeName>System.DateTime</rd:TypeName>
</Field>
<Field Name="ActualStartDate">
<DataField>ActualStartDate</DataField>
<rd:TypeName>System.DateTime</rd:TypeName>
</Field>
<Field Name="ActualEndDate">
<DataField>ActualEndDate</DataField>
<rd:TypeName>System.DateTime</rd:TypeName>
</Field>
<Field Name="Status">
<DataField>Status</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="Category">
<DataField>Category</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="StatusValue">
<DataField>StatusValue</DataField>
<rd:UserDefined>true</rd:UserDefined>
</Field>
<Field Name="AggregatedTime">
<Value>=IIF(Fields!CreatedDate.Value is nothing,
nothing,
Code.AggregatedTimeValue(Fields!CreatedDate.Value, Parameters!Aggregation.Value)
)</Value>
</Field>
<Field Name="NumberOfActivities">
<DataField>NumberOfActivities</DataField>
<rd:TypeName>System.Int</rd:TypeName>
</Field>
<Field Name="NumberOfFailedActivities">
<DataField>NumberOfFailedActivities</DataField>
<rd:TypeName>System.Int</rd:TypeName>
</Field>
<Field Name="NumberOfCompletedActivities">
<DataField>NumberOfCompletedActivities</DataField>
<rd:TypeName>System.Int</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>DWDataMart</DataSourceName>
<CommandType>StoredProcedure</CommandType>
<CommandText>ServiceManager_Report_ChangeManagement_SP_GetChangeManagementKPITrendData_Install</CommandText>
<QueryParameters>
<QueryParameter Name="@StartDate">
<Value>=Code.ToDbDate(Code.GetReportStartDate())</Value>
</QueryParameter>
<QueryParameter Name="@EndDate">
<Value>=Code.ToDbDate(Code.GetReportEndDate())</Value>
</QueryParameter>
<QueryParameter Name="@DateFilter">
<Value>=Parameters!DateFilter.Value</Value>
</QueryParameter>
<QueryParameter Name="@ID">
<Value>=Parameters!ID.Value</Value>
</QueryParameter>
<QueryParameter Name="@AssignedTo">
<Value>=Parameters!AssignedTo.Value</Value>
</QueryParameter>
<QueryParameter Name="@CreatedBy">
<Value>=Parameters!CreatedBy.Value</Value>
</QueryParameter>
<QueryParameter Name="@Description">
<Value>=Parameters!Description.Value</Value>
</QueryParameter>
<QueryParameter Name="@Status">
<Value>=JOIN(Parameters!Status.Value, ",")</Value>
</QueryParameter>
<QueryParameter Name="@Priority">
<Value>=JOIN(Parameters!Priority.Value, ",")</Value>
</QueryParameter>
<QueryParameter Name="@Impact">
<Value>=JOIN(Parameters!Impact.Value,",")</Value>
</QueryParameter>
<QueryParameter Name="@Risk">
<Value>=JOIN(Parameters!Risk.Value,",")</Value>
</QueryParameter>
<QueryParameter Name="@Category">
<Value>=JOIN(Parameters!Category.Value,",")</Value>
</QueryParameter>
<QueryParameter Name="@ChangeResult">
<Value>=JOIN(Parameters!ChangeResult.Value, ",")</Value>
</QueryParameter>
<QueryParameter Name="@ActivityName">
<Value>=Parameters!ActivityName.Value</Value>
<rd:UserDefined>true</rd:UserDefined>
</QueryParameter>
<QueryParameter Name="@ActivityID">
<Value>=Parameters!ActivityID.Value</Value>
<rd:UserDefined>true</rd:UserDefined>
</QueryParameter>
<QueryParameter Name="@ActivityStatus">
<Value>=Parameters!ActivityStatus.Value</Value>
<rd:UserDefined>true</rd:UserDefined>
</QueryParameter>
<QueryParameter Name="@ActivityStage">
<Value>=Parameters!ActivityStage.Value</Value>
<rd:UserDefined>true</rd:UserDefined>
</QueryParameter>
<QueryParameter Name="@CIName">
<Value>=Parameters!CIName.Value</Value>
<rd:UserDefined>true</rd:UserDefined>
</QueryParameter>
<QueryParameter Name="@ActivityType">
<Value>=Parameters!ActivityType.Value</Value>
<rd:UserDefined>true</rd:UserDefined>
</QueryParameter>
<QueryParameter Name="@ScheduledStartFrom">
<Value>=Parameters!StartDate_ScheduledStart.Value</Value>
</QueryParameter>
<QueryParameter Name="@ScheduledStartTo">
<Value>=Parameters!EndDate_ScheduledStart.Value</Value>
</QueryParameter>
<QueryParameter Name="@ScheduledEndFrom">
<Value>=Parameters!StartDate_ScheduledEnd.Value</Value>
</QueryParameter>
<QueryParameter Name="@ScheduledEndTo">
<Value>=Parameters!EndDate_ScheduledEnd.Value</Value>
</QueryParameter>
<QueryParameter Name="@ActualStartFrom">
<Value>=Parameters!StartDate_ActualStart.Value</Value>
</QueryParameter>
<QueryParameter Name="@ActualStartTo">
<Value>=Parameters!EndDate_ActualStart.Value</Value>
</QueryParameter>
<QueryParameter Name="@ActualEndFrom">
<Value>=Parameters!StartDate_ActualEnd.Value</Value>
</QueryParameter>
<QueryParameter Name="@ActualEndTo">
<Value>=Parameters!EndDate_ActualEnd.Value</Value>
</QueryParameter>
<QueryParameter Name="@LanguageCode">
<Value>=Code.GetReportLocLanguageCode()</Value>
<rd:UserDefined>true</rd:UserDefined>
</QueryParameter>
</QueryParameters>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
</DataSet>
<DataSet Name="List_Category">
<Fields>
<Field Name="Label">
<DataField>Label</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="Value">
<DataField>Value</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>DWDataMart</DataSourceName>
<CommandText>
SELECT @AllLabel AS Label, -1 AS Value
UNION
SELECT
ISNULL(DS.DisplayName, C.ChangeCategoryValue) AS Label,
ChangeCategoryId AS Value
FROM
dbo.ChangeCategoryvw C
LEFT OUTER JOIN dbo.DisplayStringDimvw DS
ON (C.EnumTypeId = DS.BaseManagedEntityId AND
DS.LanguageCode =@LanguageCode)
WHERE C.ParentId IS NOT NULL
ORDER BY Label
</CommandText>
<QueryParameters>
<QueryParameter Name="@AllLabel">
<Value>=Parameters!AllLabel.Value</Value>
<rd:UserDefined>true</rd:UserDefined>
</QueryParameter>
<QueryParameter Name="@LanguageCode">
<Value>=Code.GetReportLocLanguageCode()</Value>
</QueryParameter>
</QueryParameters>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
</DataSet>
<DataSet Name="List_AssignedTo">
<Fields>
<Field Name="Label">
<DataField>Label</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="Value">
<DataField>Value</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>DWDataMart</DataSourceName>
<CommandText>
SELECT @AllLabel AS Label, -1 AS Value
UNION
SELECT DISTINCT
UserDimvw.UserName AS Label,
UserDimvw.UserDimKey AS Value
FROM dbo.WorkItemAssignedToUserFactvw WIATU INNER JOIN
dbo.UserDimvw ON WIATU.WorkItemAssignedToUser_UserDimKey = UserDimvw.UserDimKey
ORDER BY Label
</CommandText>
<QueryParameters>
<QueryParameter Name="@AllLabel">
<Value>=Parameters!AllLabel.Value</Value>
<rd:UserDefined>true</rd:UserDefined>
</QueryParameter>
</QueryParameters>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
</DataSet>
<DataSet Name="List_CreatedBy">
<Fields>
<Field Name="Label">
<DataField>Label</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="Value">
<DataField>Value</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>DWDataMart</DataSourceName>
<CommandText>
SELECT @AllLabel AS Label, -1 AS Value
UNION
SELECT DISTINCT
UserDimvw.UserName AS Label,
UserDimvw.UserDimKey AS Value
FROM WorkItemDimvw WI
INNER JOIN WorkItemCreatedByUserFactvw WIUFact
ON WI.WorkItemDimKey = WIUFact.WorkItemDimKey
INNER JOIN UserDimvw ON WIUFact.WorkItemCreatedByUser_UserDimKey = UserDimvw.UserDimKey
ORDER BY Label
</CommandText>
<QueryParameters>
<QueryParameter Name="@AllLabel">
<Value>=Parameters!AllLabel.Value</Value>
<rd:UserDefined>true</rd:UserDefined>
</QueryParameter>
</QueryParameters>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
</DataSet>
<DataSet Name="List_ChangeResult">
<Fields>
<Field Name="Value">
<DataField>Value</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="Label">
<DataField>Label</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>DWDataMart</DataSourceName>
<CommandText>
SELECT @AllLabel
AS Label, -1 AS Value
UNION
SELECT DISTINCT
ISNULL(DS.DisplayName, C.ChangeImplementationResultsValue) AS Label, ChangeImplementationResultsId AS Value
FROM dbo.ChangeImplementationResultsvw C
LEFT OUTER JOIN dbo.DisplayStringDimvw DS
ON (C.EnumTypeId = DS.BaseManagedEntityId AND
DS.LanguageCode =@LanguageCode)
WHERE C.ParentId IS NOT NULL
ORDER BY Label
</CommandText>
<QueryParameters>
<QueryParameter Name="@AllLabel">
<Value>=Parameters!AllLabel.Value</Value>
<rd:UserDefined>true</rd:UserDefined>
</QueryParameter>
<QueryParameter Name="@LanguageCode">
<Value>=Code.GetReportLocLanguageCode()</Value>
</QueryParameter>
</QueryParameters>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
</DataSet>
<DataSet Name="LT_Report">
<Fields>
<Field Name="XML_F52E2B61_18A1_11d1_B105_00805F49916B">
<DataField>XML_F52E2B61-18A1-11d1-B105-00805F49916B</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>DWDataMart</DataSourceName>
<CommandType>StoredProcedure</CommandType>
<CommandText>ReportDisplayStringGet</CommandText>
<QueryParameters>
<QueryParameter Name="@ManagementPackSystemName">
<Value>ServiceManager.ChangeManagement.Report.Library</Value>
</QueryParameter>
<QueryParameter Name="@ReportSystemName">
<Value>ServiceManager.Report.ChangeManagement.ChangeManagementKPITrend</Value>
</QueryParameter>
<QueryParameter Name="@LanguageCode">
<Value>=Code.GetReportLocLanguageCode()</Value>
</QueryParameter>
<QueryParameter Name="@Scope">
<Value>R.%</Value>
</QueryParameter>
</QueryParameters>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
</DataSet>
<DataSet Name="LT_Strings">
<Fields>
<Field Name="XML_F52E2B61_18A1_11d1_B105_00805F49916B">
<DataField>XML_F52E2B61-18A1-11d1-B105-00805F49916B</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>DWDataMart</DataSourceName>
<CommandType>StoredProcedure</CommandType>
<CommandText>ReportDisplayStringGet</CommandText>
<QueryParameters>
<QueryParameter Name="@ManagementPackSystemName">
<Value>ServiceManager.ChangeManagement.Report.Library</Value>
</QueryParameter>
<QueryParameter Name="@ReportSystemName">
<Value>ServiceManager.Report.ChangeManagement.ChangeManagementKPITrend</Value>
</QueryParameter>
<QueryParameter Name="@LanguageCode">
<Value>=Code.GetReportLocLanguageCode()</Value>
</QueryParameter>
<QueryParameter Name="@Scope">
<Value>S.%</Value>
</QueryParameter>
</QueryParameters>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
</DataSet>
<DataSet Name="LT_Table">
<Fields>
<Field Name="XML_F52E2B61_18A1_11d1_B105_00805F49916B">
<DataField>XML_F52E2B61-18A1-11d1-B105-00805F49916B</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>DWDataMart</DataSourceName>
<CommandType>StoredProcedure</CommandType>
<CommandText>ReportDisplayStringGet</CommandText>
<QueryParameters>
<QueryParameter Name="@ManagementPackSystemName">
<Value>ServiceManager.ChangeManagement.Report.Library</Value>
</QueryParameter>
<QueryParameter Name="@ReportSystemName">
<Value>ServiceManager.Report.ChangeManagement.ChangeManagementKPITrend</Value>
</QueryParameter>
<QueryParameter Name="@LanguageCode">
<Value>=Code.GetReportLocLanguageCode()</Value>
</QueryParameter>
<QueryParameter Name="@Scope">
<Value>T.%</Value>
</QueryParameter>
</QueryParameters>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
</DataSet>
<DataSet Name="LT_Parameters">
<Fields>
<Field Name="XML_F52E2B61_18A1_11d1_B105_00805F49916B">
<DataField>XML_F52E2B61-18A1-11d1-B105-00805F49916B</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>DWDataMart</DataSourceName>
<CommandType>StoredProcedure</CommandType>
<CommandText>ReportDisplayStringGet</CommandText>
<QueryParameters>
<QueryParameter Name="@ManagementPackSystemName">
<Value>ServiceManager.ChangeManagement.Report.Library</Value>
</QueryParameter>
<QueryParameter Name="@ReportSystemName">
<Value>ServiceManager.Report.ChangeManagement.ChangeManagementKPITrend</Value>
</QueryParameter>
<QueryParameter Name="@LanguageCode">
<Value>=Code.GetReportLocLanguageCode()</Value>
</QueryParameter>
<QueryParameter Name="@Scope">
<Value>P.%</Value>
</QueryParameter>
</QueryParameters>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
</DataSet>
<DataSet Name="List_ActivityStage">
<Fields>
<Field Name="Label">
<DataField>Label</DataField>
<rd:UserDefined>true</rd:UserDefined>
</Field>
<Field Name="Value">
<DataField>Value</DataField>
<rd:UserDefined>true</rd:UserDefined>
</Field>
</Fields>
<Query>
<DataSourceName>DWDataMart</DataSourceName>
<CommandText>
SELECT @AllLabel AS Label, -1 AS Value
UNION
SELECT DISTINCT
ISNULL(DS.DisplayName, A.ActivityStageValue) AS Label,
ActivityStageId AS Value
FROM dbo.ActivityStagevw A
LEFT OUTER JOIN dbo.DisplayStringDimvw DS
ON (A.EnumTypeId = DS.BaseManagedEntityId AND
DS.LanguageCode =@LanguageCode)
WHERE A.ParentId IS NOT NULL
ORDER BY Label
</CommandText>
<QueryParameters>
<QueryParameter Name="@AllLabel">
<Value>=Parameters!AllLabel.Value</Value>
<rd:UserDefined>true</rd:UserDefined>
</QueryParameter>
<QueryParameter Name="@LanguageCode">
<Value>=Code.GetReportLocLanguageCode()</Value>
</QueryParameter>
</QueryParameters>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
</DataSet>
<DataSet Name="List_ActivityStatus">
<Fields>
<Field Name="Label">
<DataField>Label</DataField>
<rd:UserDefined>true</rd:UserDefined>
</Field>
<Field Name="Value">
<DataField>Value</DataField>
<rd:UserDefined>true</rd:UserDefined>
</Field>
</Fields>
<Query>
<DataSourceName>DWDataMart</DataSourceName>
<CommandText>
SELECT @AllLabel AS Label, -1 AS Value
UNION
SELECT DISTINCT
ISNULL(DS.DisplayName, A.ActivityStatusValue) AS Label,
ActivityStatusId AS Value
FROM dbo.ActivityStatusvw A
LEFT OUTER JOIN dbo.DisplayStringDimvw DS
ON (A.EnumTypeId = DS.BaseManagedEntityId AND
DS.LanguageCode =@LanguageCode)
WHERE A.ParentId IS NOT NULL
ORDER BY Label
</CommandText>
<QueryParameters>
<QueryParameter Name="@AllLabel">
<Value>=Parameters!AllLabel.Value</Value>
<rd:UserDefined>true</rd:UserDefined>
</QueryParameter>
<QueryParameter Name="@LanguageCode">
<Value>=Code.GetReportLocLanguageCode()</Value>
</QueryParameter>
</QueryParameters>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
</DataSet>
</DataSets>
<Body><Script>
<ReportItems>
<Rectangle Name="rectangle4">
<ReportItems>
<Textbox Name="reportTitle">
<CanGrow>true</CanGrow>
<DataElementStyle>Element</DataElementStyle>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Code.GetLocTable("LT_Report").GetString("R.ReportName", "[ReportName]")</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>11pt</FontSize>
<FontWeight>Bold</FontWeight>
</Style>
</TextRun>
</TextRuns>
<Style /></Style>
</Paragraph>
</Paragraphs>
<Top>0.05in</Top>
<Left>0.2in</Left>
<Height>0.25in</Height>
<Width>10.2in</Width>
<DataElementName>Title</DataElementName>
<DataElementOutput>Output</DataElementOutput>
<Style></Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="reportDescriptionTitle">
<CanGrow>true</CanGrow>
<ToggleImage>
<InitialState>=Not(Parameters!Interactive.Value)</InitialState>
</ToggleImage>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Code.GetLocTable("LT_Report").GetString("R.ReportDescriptionLabel", "[ExpandThis]")</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<Color>DimGray</Color>
</Style>
</TextRun>
</TextRuns>
<Style /></Style>
</Paragraph>
</Paragraphs>
<Top>0.3in</Top>
<Height>0.2in</Height>
<Width>10.4in</Width>
<ZIndex>1</ZIndex>
<DataElementOutput>NoOutput</DataElementOutput>
<Style></Style>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</ReportItems>
<DataElementOutput>ContentsOnly</DataElementOutput>
<Top>0.93056in</Top>
<Left>0.14792in</Left>
<Height>0.55in</Height>
<Width>10.6in</Width>
<Style></Style>
<BackgroundColor>Gainsboro</BackgroundColor>
</Style>
</Rectangle>
<Rectangle Name="rectangle2">
<ReportItems>
<Textbox Name="textbox51">
<CanGrow>true</CanGrow>
<CanShrink>true</CanShrink>
<DataElementStyle>Element</DataElementStyle>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Code.GetLocTable("LT_Report").GetString("R.AssignedTo", "[AssignedTo]")</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style /></Style>
</Paragraph>
</Paragraphs>
<Top>1.45833in</Top>
<Left>0.21388in</Left>
<Height>0.2in</Height>
<Width>1.65in</Width>
<DataElementOutput>Output</DataElementOutput>
<Style></Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Image Name="horizontal_line">
<Source>External</Source>
<Value>horizontal_line_gradient.png</Value>
<Sizing>Fit</Sizing>
<Top>3in</Top>
<Height>0.05208in</Height>
<Width>10.6in</Width>
<ZIndex>1</ZIndex>
<Style /></Style>
</Image>
<Textbox Name="textbox26">
<CanGrow>true</CanGrow>
<CanShrink>true</CanShrink>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Code.GetLocTable("LT_Report").GetString("R.StartEndDateLabel", "[Start/End date time]")</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style /></Style>
</Paragraph>
</Paragraphs>
<Top>0.36111in</Top>
<Left>0.21388in</Left>
<Height>0.2in</Height>
<Width>1.65in</Width>
<ZIndex>2</ZIndex>
<DataElementOutput>NoOutput</DataElementOutput>
<Style></Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="textbox28">
<CanGrow>true</CanGrow>
<CanShrink>true</CanShrink>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Code.FormatString(Code.GetLocTable("LT_Strings").GetString("S.StartEndDateFormat", "[From {0} to {1}]") , Code.FormatDateTime("d", Code.GetReportStartDate()), Code.FormatDateTime("d", Code.GetReportEndDate()))</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style /></Style>
</Paragraph>
</Paragraphs>
<Top>0.36111in</Top>
<Left>1.95in</Left>
<Height>0.2in</Height>
<Width>8.45in</Width>
<ZIndex>3</ZIndex>
<DataElementName>ReportDuration</DataElementName>
<DataElementOutput>NoOutput</DataElementOutput>
<Style></Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="textbox101">
<CanGrow>true</CanGrow>
<CanShrink>true</CanShrink>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Code.GetLocTable("LT_Report").GetString("R.ReportGeneratedLabel", "[ReportGenerated]")</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style /></Style>
</Paragraph>
</Paragraphs>
<Top>0.175in</Top>
<Left>0.21388in</Left>
<Height>0.2in</Height>
<Width>1.65in</Width>
<ZIndex>4</ZIndex>
<DataElementOutput>NoOutput</DataElementOutput>
<Style></Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="textbox2">
<CanGrow>true</CanGrow>
<CanShrink>true</CanShrink>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>:</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style /></Style>
</Paragraph>
</Paragraphs>
<Top>0.175in</Top>
<Left>1.85in</Left>
<Height>0.2in</Height>
<Width>0.1in</Width>
<ZIndex>5</ZIndex>
<DataElementOutput>NoOutput</DataElementOutput>
<Style></Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="textbox7">
<CanGrow>true</CanGrow>
<CanShrink>true</CanShrink>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>:</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style /></Style>
</Paragraph>
</Paragraphs>
<Top>0.36111in</Top>
<Left>1.85in</Left>
<Height>0.2in</Height>
<Width>0.1in</Width>
<ZIndex>6</ZIndex>
<DataElementOutput>NoOutput</DataElementOutput>
<Style></Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="textbox9">
<CanGrow>true</CanGrow>
<CanShrink>true</CanShrink>
<DataElementStyle>Element</DataElementStyle>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Now()</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style></Style>
<TextAlign>Left</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<Top>0.175in</Top>
<Left>1.95in</Left>
<Height>0.2in</Height>
<Width>8.45in</Width>
<ZIndex>7</ZIndex>
<DataElementName>ReportGenerated</DataElementName>
<DataElementOutput>Output</DataElementOutput>
<Style></Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="textbox35">
<CanGrow>true</CanGrow>
<CanShrink>true</CanShrink>
<DataElementStyle>Element</DataElementStyle>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Code.GetLocTable("LT_Report").GetString("R.Impact", "[Impact]")</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style /></Style>
</Paragraph>
</Paragraphs>
<Top>1.01667in</Top>
<Left>0.21388in</Left>
<Height>0.2in</Height>
<Width>1.65in</Width>
<ZIndex>8</ZIndex>
<DataElementOutput>Output</DataElementOutput>
<Style></Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="textbox37">
<CanGrow>true</CanGrow>
<CanShrink>true</CanShrink>
<DataElementStyle>Element</DataElementStyle>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Join(Parameters!Impact.Label, ", ")</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style /></Style>
</Paragraph>
</Paragraphs>
<Top>1.01667in</Top>
<Left>1.95in</Left>
<Height>0.2in</Height>
<Width>8.45in</Width>
<ZIndex>9</ZIndex>
<DataElementName>Impact</DataElementName>
<DataElementOutput>Output</DataElementOutput>
<Style></Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="textbox39">
<CanGrow>true</CanGrow>
<CanShrink>true</CanShrink>
<DataElementStyle>Element</DataElementStyle>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Join(Parameters!Status.Label, ", ")</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style /></Style>
</Paragraph>
</Paragraphs>
<Top>0.78889in</Top>
<Left>1.95in</Left>
<Height>0.2in</Height>
<Width>8.45in</Width>
<ZIndex>10</ZIndex>
<DataElementName>Status</DataElementName>
<DataElementOutput>Output</DataElementOutput>
<Style></Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="textbox40">
<CanGrow>true</CanGrow>
<CanShrink>true</CanShrink>
<DataElementStyle>Element</DataElementStyle>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=IIF(Parameters!ID.Value = nothing, Parameters!AllLabel.Value, Parameters!ID.Value)</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style /></Style>
</Paragraph>
</Paragraphs>
<Top>0.575in</Top>
<Left>1.95in</Left>
<Height>0.2in</Height>
<Width>8.45in</Width>
<ZIndex>11</ZIndex>
<DataElementName>ID</DataElementName>
<DataElementOutput>Output</DataElementOutput>
<Style></Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="textbox43">
<CanGrow>true</CanGrow>
<CanShrink>true</CanShrink>
<DataElementStyle>Element</DataElementStyle>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Code.GetLocTable("LT_Report").GetString("R.Risk", "[Risk]")</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style /></Style>
</Paragraph>
</Paragraphs>
<Top>1.88611in</Top>
<Left>0.21388in</Left>
<Height>0.2in</Height>
<Width>1.65in</Width>
<ZIndex>12</ZIndex>
<DataElementOutput>Output</DataElementOutput>
<Style></Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="textbox46">
<CanGrow>true</CanGrow>
<CanShrink>true</CanShrink>
<DataElementStyle>Element</DataElementStyle>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Join(Parameters!Risk.Label,", ")</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style /></Style>
</Paragraph>
</Paragraphs>
<Top>1.88611in</Top>
<Left>1.95in</Left>
<Height>0.2in</Height>
<Width>8.45in</Width>
<ZIndex>13</ZIndex>
<DataElementName>Risk</DataElementName>
<DataElementOutput>Output</DataElementOutput>
<Style></Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="textbox49">
<CanGrow>true</CanGrow>
<CanShrink>true</CanShrink>
<DataElementStyle>Element</DataElementStyle>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Join(Parameters!Priority.Label,", ")</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style /></Style>
</Paragraph>
</Paragraphs>
<Top>1.67222in</Top>
<Left>1.95in</Left>
<Height>0.2in</Height>
<Width>8.45in</Width>
<ZIndex>14</ZIndex>
<DataElementName>Priority</DataElementName>
<DataElementOutput>Output</DataElementOutput>
<Style></Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="textbox52">
<CanGrow>true</CanGrow>
<CanShrink>true</CanShrink>
<DataElementStyle>Element</DataElementStyle>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Code.GetLocTable("LT_Report").GetString("R.Category", "[Category]")</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style /></Style>
</Paragraph>
</Paragraphs>
<Top>1.23056in</Top>
<Left>0.21388in</Left>
<Height>0.2in</Height>
<Width>1.65in</Width>
<ZIndex>15</ZIndex>
<DataElementOutput>Output</DataElementOutput>
<Style></Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="textbox53">
<CanGrow>true</CanGrow>
<CanShrink>true</CanShrink>
<DataElementStyle>Element</DataElementStyle>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Parameters!AssignedTo.Label</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style /></Style>
</Paragraph>
</Paragraphs>
<Top>1.45833in</Top>
<Left>1.95in</Left>
<Height>0.2in</Height>
<Width>8.45in</Width>
<ZIndex>16</ZIndex>
<DataElementName>AssignedTo</DataElementName>
<DataElementOutput>Output</DataElementOutput>
<Style></Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="textbox54">
<CanGrow>true</CanGrow>
<CanShrink>true</CanShrink>
<DataElementStyle>Element</DataElementStyle>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Join(Parameters!Category.Label, ", ")</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style /></Style>
</Paragraph>
</Paragraphs>
<Top>1.23056in</Top>
<Left>1.95in</Left>
<Height>0.2in</Height>
<Width>8.45in</Width>
<ZIndex>17</ZIndex>
<DataElementName>Category</DataElementName>
<DataElementOutput>Output</DataElementOutput>
<Style></Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="textbox55">
<CanGrow>true</CanGrow>
<CanShrink>true</CanShrink>
<DataElementStyle>Element</DataElementStyle>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Code.GetLocTable("LT_Report").GetString("R.CreatedBy", "[CreatedBy]")</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style /></Style>
</Paragraph>
</Paragraphs>
<Top>2.31389in</Top>
<Left>0.21388in</Left>
<Height>0.2in</Height>
<Width>1.65in</Width>
<ZIndex>18</ZIndex>
<DataElementOutput>Output</DataElementOutput>
<Style></Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="textbox57">
<CanGrow>true</CanGrow>
<CanShrink>true</CanShrink>
<DataElementStyle>Element</DataElementStyle>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Parameters!CreatedBy.Label</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style /></Style>
</Paragraph>
</Paragraphs>
<Top>2.31389in</Top>
<Left>1.95in</Left>
<Height>0.2in</Height>
<Width>8.45in</Width>
<ZIndex>19</ZIndex>
<DataElementName>CreatedBy</DataElementName>
<DataElementOutput>Output</DataElementOutput>
<Style></Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="textbox58">
<CanGrow>true</CanGrow>
<CanShrink>true</CanShrink>
<DataElementStyle>Element</DataElementStyle>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Join(Parameters!ChangeResult.Label, ", ")</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style /></Style>
</Paragraph>
</Paragraphs>
<Top>2.11389in</Top>
<Left>1.95in</Left>
<Height>0.2in</Height>
<Width>8.45in</Width>
<ZIndex>20</ZIndex>
<DataElementName>ChangeResult</DataElementName>
<DataElementOutput>Output</DataElementOutput>
<Style></Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="textbox6">
<CanGrow>true</CanGrow>
<CanShrink>true</CanShrink>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>:</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style /></Style>
</Paragraph>
</Paragraphs>
<Top>0.575in</Top>
<Left>1.85in</Left>
<Height>0.2in</Height>
<Width>0.1in</Width>
<ZIndex>21</ZIndex>
<DataElementOutput>NoOutput</DataElementOutput>
<Style></Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="textbox8">
<CanGrow>true</CanGrow>
<CanShrink>true</CanShrink>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>:</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style /></Style>
</Paragraph>
</Paragraphs>
<Top>0.78889in</Top>
<Left>1.85in</Left>
<Height>0.2in</Height>
<Width>0.1in</Width>
<ZIndex>22</ZIndex>
<DataElementOutput>NoOutput</DataElementOutput>
<Style></Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="textbox59">
<CanGrow>true</CanGrow>
<CanShrink>true</CanShrink>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>:</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style /></Style>
</Paragraph>
</Paragraphs>
<Top>1.01667in</Top>
<Left>1.85in</Left>
<Height>0.2in</Height>
<Width>0.1in</Width>
<ZIndex>23</ZIndex>
<DataElementOutput>NoOutput</DataElementOutput>
<Style></Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="textbox61">
<CanGrow>true</CanGrow>
<CanShrink>true</CanShrink>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>:</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style /></Style>
</Paragraph>
</Paragraphs>
<Top>1.4684in</Top>
<Left>1.85in</Left>
<Height>0.17986in</Height>
<Width>0.1in</Width>
<ZIndex>24</ZIndex>
<DataElementOutput>NoOutput</DataElementOutput>
<Style></Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="textbox60">
<CanGrow>true</CanGrow>
<CanShrink>true</CanShrink>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>:</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style /></Style>
</Paragraph>
</Paragraphs>
<Top>1.23056in</Top>
<Left>1.85in</Left>
<Height>0.2in</Height>
<Width>0.1in</Width>
<ZIndex>25</ZIndex>
<DataElementOutput>NoOutput</DataElementOutput>
<Style></Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="textbox11">
<CanGrow>true</CanGrow>
<CanShrink>true</CanShrink>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>:</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style /></Style>
</Paragraph>
</Paragraphs>
<Top>1.67222in</Top>
<Left>1.85in</Left>
<Height>0.2in</Height>
<Width>0.1in</Width>
<ZIndex>26</ZIndex>
<DataElementOutput>NoOutput</DataElementOutput>
<Style></Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="textbox62">
<CanGrow>true</CanGrow>
<CanShrink>true</CanShrink>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>:</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style /></Style>
</Paragraph>
</Paragraphs>
<Top>1.88611in</Top>
<Left>1.85in</Left>
<Height>0.2in</Height>
<Width>0.1in</Width>
<ZIndex>27</ZIndex>
<DataElementOutput>NoOutput</DataElementOutput>
<Style></Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="textbox63">
<CanGrow>true</CanGrow>
<CanShrink>true</CanShrink>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>:</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style /></Style>
</Paragraph>
</Paragraphs>
<Top>2.31389in</Top>
<Left>1.85in</Left>
<Height>0.2in</Height>
<Width>0.1in</Width>
<ZIndex>28</ZIndex>
<DataElementOutput>NoOutput</DataElementOutput>
<Style></Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="textbox64">
<CanGrow>true</CanGrow>
<CanShrink>true</CanShrink>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>:</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style /></Style>
</Paragraph>
</Paragraphs>
<Top>2.11389in</Top>
<Left>1.85in</Left>
<Height>0.2in</Height>
<Width>0.1in</Width>
<ZIndex>29</ZIndex>
<DataElementOutput>NoOutput</DataElementOutput>
<Style></Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="TimeZoneName1">
<CanGrow>true</CanGrow>
<DataElementStyle>Element</DataElementStyle>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Parameters!TimeZoneName.Value</Value>
<Style /></Style>
</TextRun>
</TextRuns>
<Style /></Style>
</Paragraph>
</Paragraphs>
<rd:DefaultName>TimeZoneName1</rd:DefaultName>
<Top>0.45055in</Top>
<Left>0.06458in</Left>
<Height>0.19945in</Height>
<Width>0.07986in</Width>
<ZIndex>30</ZIndex>
<Visibility>
<Hidden>true</Hidden>
</Visibility>
<DataElementName>TimeZone</DataElementName>
<DataElementOutput>Output</DataElementOutput>
<Style></Style>
<Border>
<Style></Style>None</Style>
</Border>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="textbox36">
<CanGrow>true</CanGrow>
<CanShrink>true</CanShrink>
<DataElementStyle>Element</DataElementStyle>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Code.GetLocTable("LT_Report").GetString("R.Status", "[Status]")</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style /></Style>
</Paragraph>
</Paragraphs>
<Top>0.78889in</Top>
<Left>0.21388in</Left>
<Height>0.2in</Height>
<Width>1.65in</Width>
<ZIndex>31</ZIndex>
<DataElementOutput>Output</DataElementOutput>
<Style></Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="textbox56">
<CanGrow>true</CanGrow>
<CanShrink>true</CanShrink>
<DataElementStyle>Element</DataElementStyle>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Code.GetLocTable("LT_Report").GetString("R.ChangeResult", "[ChangeResult]")</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style /></Style>
</Paragraph>
</Paragraphs>
<Top>2.11389in</Top>
<Left>0.21388in</Left>
<Height>0.2in</Height>
<Width>1.65in</Width>
<ZIndex>32</ZIndex>
<DataElementOutput>Output</DataElementOutput>
<Style></Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="textbox33">
<CanGrow>true</CanGrow>
<CanShrink>true</CanShrink>
<DataElementStyle>Element</DataElementStyle>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Code.GetLocTable("LT_Report").GetString("R.IDLabel", "[ID]")</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style /></Style>
</Paragraph>
</Paragraphs>
<Top>0.575in</Top>
<Left>0.21388in</Left>
<Height>0.2in</Height>
<Width>1.65in</Width>
<ZIndex>33</ZIndex>
<DataElementOutput>Output</DataElementOutput>
<Style></Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="textbox45">
<CanGrow>true</CanGrow>
<CanShrink>true</CanShrink>
<DataElementStyle>Element</DataElementStyle>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Code.GetLocTable("LT_Report").GetString("R.Priority", "[Priority]")</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style /></Style>
</Paragraph>
</Paragraphs>
<Top>1.67222in</Top>
<Left>0.21388in</Left>
<Height>0.2in</Height>
<Width>1.65in</Width>
<ZIndex>34</ZIndex>
<DataElementOutput>Output</DataElementOutput>
<Style></Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</ReportItems>
<DataElementOutput>ContentsOnly</DataElementOutput>
<Top>1.73056in</Top>
<Left>0.14792in</Left>
<Height>3.05208in</Height>
<Width>10.6in</Width>
<ZIndex>1</ZIndex>
<Visibility>
<Hidden>=Parameters!Interactive.Value</Hidden>
<ToggleItem>reportDescriptionTitle</ToggleItem>
</Visibility>
<Style /></Style>
</Rectangle>
<Rectangle Name="rectangle3">
<ReportItems>
<Textbox Name="reportDescription">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Code.GetLocTable("LT_Report").GetString("R.ReportDescription", "[ReportDescription]")</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style /></Style>
</Paragraph>
</Paragraphs>
<Left>0.2in</Left>
<Height>0.2in</Height>
<Width>10.2in</Width>
<DataElementOutput>NoOutput</DataElementOutput>
<Style></Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</ReportItems>
<DataElementOutput>ContentsOnly</DataElementOutput>
<Top>1.48056in</Top>
<Left>0.14792in</Left>
<Height>0.2in</Height>
<Width>10.6in</Width>
<ZIndex>2</ZIndex>
<Visibility>
<Hidden>=Parameters!Interactive.Value</Hidden>
<ToggleItem>reportDescriptionTitle</ToggleItem>
</Visibility>
<Style></Style>
<BackgroundColor>Gainsboro</BackgroundColor>
</Style>
</Rectangle>
<Rectangle Name="rectangle5">
<DataElementOutput>ContentsOnly</DataElementOutput>
<Top>1.68056in</Top>
<Left>0.14792in</Left>
<Height>0.05in</Height>
<Width>10.6in</Width>
<ZIndex>3</ZIndex>
<Style></Style>
<Border>
<Color>DarkGray</Color>
</Border>
<BottomBorder>
<Style></Style>Solid</Style>
</BottomBorder>
<BackgroundColor>Gainsboro</BackgroundColor>
</Style>
</Rectangle>
<Tablix Name="table_RFCs">
<TablixBody>
<TablixColumns>
<TablixColumn>
<Width>1.53902in</Width>
</TablixColumn>
<TablixColumn>
<Width>1.91818in</Width>
</TablixColumn>
<TablixColumn>
<Width>1.96194in</Width>
</TablixColumn>
<TablixColumn>
<Width>1.71402in</Width>
</TablixColumn>
<TablixColumn>
<Width>1.79816in</Width>
</TablixColumn>
<TablixColumn>
<Width>1.66246in</Width>
</TablixColumn>
</TablixColumns>
<TablixRows>
<TablixRow>
<Height>0.35in</Height>
<TablixCells>
<TablixCell>
<CellContents>
<Textbox Name="Textbox1">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Label>Aggregation</Label>
<Value>=Code.GetLocTable("LT_Table").GetString("T.Aggregation", "[Aggregation]")</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<Color>White</Color>
</Style>
</TextRun>
</TextRuns>
<Style /></Style>
</Paragraph>
</Paragraphs>
<rd:DefaultName>Textbox1</rd:DefaultName>
<Style></Style>
<Border>
<Color>Gray</Color>
<Style></Style>Solid</Style>
</Border>
<RightBorder>
<Style></Style>None</Style>
</RightBorder>
<BackgroundColor>DimGray</BackgroundColor>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="textbox14">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Label>In Progress Changes</Label>
<Value>=Code.GetLocTable("LT_Table").GetString("T.InProgressChanges", "[In Progress Changes]")</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<Color>White</Color>
</Style>
</TextRun>
</TextRuns>
<Style /></Style>
</Paragraph>
</Paragraphs>
<rd:DefaultName>textbox14</rd:DefaultName>
<ZIndex>24</ZIndex>
<RepeatWith>table_incidents</RepeatWith>
<Style></Style>
<Border>
<Color>Gray</Color>
<Style></Style>Solid</Style>
</Border>
<LeftBorder>
<Style></Style>None</Style>
</LeftBorder>
<BackgroundColor>DimGray</BackgroundColor>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="textbox48">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Label>Completed Changes</Label>
<Value>=Code.GetLocTable("LT_Table").GetString("T.CompletedChanges", "[Completed Changes]")</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<Color>White</Color>
</Style>
</TextRun>
</TextRuns>
<Style /></Style>
</Paragraph>
</Paragraphs>
<rd:DefaultName>textbox48</rd:DefaultName>
<ZIndex>22</ZIndex>
<RepeatWith>table_incidents</RepeatWith>
<Style></Style>
<Border>
<Color>Gray</Color>
<Style></Style>Solid</Style>
</Border>
<BackgroundColor>DimGray</BackgroundColor>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="textbox17">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Label>Failed Changes</Label>
<Value>=Code.GetLocTable("LT_Table").GetString("T.FailedChanges", "[Failed changes]")</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<Color>White</Color>
</Style>
</TextRun>
</TextRuns>
<Style /></Style>
</Paragraph>
</Paragraphs>
<rd:DefaultName>textbox17</rd:DefaultName>
<ZIndex>17</ZIndex>
<RepeatWith>table_incidents</RepeatWith>
<Style></Style>
<Border>
<Color>Gray</Color>
<Style></Style>Solid</Style>
</Border>
<BackgroundColor>DimGray</BackgroundColor>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="textbox4">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Label>Cancelled Changes</Label>
<Value>=Code.GetLocTable("LT_Table").GetString("T.CancelledChanges", "[Cancelled changes]")</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<Color>White</Color>
</Style>
</TextRun>
</TextRuns>
<Style /></Style>
</Paragraph>
</Paragraphs>
<rd:DefaultName>textbox4</rd:DefaultName>
<ZIndex>23</ZIndex>
<RepeatWith>table_incidents</RepeatWith>
<Style></Style>
<Border>
<Color>Gray</Color>
<Style></Style>Solid</Style>
</Border>
<BackgroundColor>DimGray</BackgroundColor>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="Textbox16">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Label>Avg. Process Time</Label>
<Value>=Code.GetLocTable("LT_Table").GetString("T.AvgProcessTime", "[Avg. Process Time per Change(Days)]")</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<Color>White</Color>
</Style>
</TextRun>
</TextRuns>
<Style /></Style>
</Paragraph>
</Paragraphs>
<rd:DefaultName>Textbox16</rd:DefaultName>
<Style></Style>
<Border>
<Color>Gray</Color>
<Style></Style>Solid</Style>
</Border>
<BackgroundColor>DimGray</BackgroundColor>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
</TablixCells>
</TablixRow>
<TablixRow>
<Height>0.35417in</Height>
<TablixCells>
<TablixCell>
<CellContents>
<Textbox Name="Id2">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Label>Aggregation</Label>
<Value>=Code.FormatAggregatedTimeValue(Fields!AggregatedTime.Value, Parameters!Aggregation.Value)</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<TextDecoration>None</TextDecoration>
</Style>
</TextRun>
</TextRuns>
<Style /></Style>
</Paragraph>
</Paragraphs>
<rd:DefaultName>Id</rd:DefaultName>
<ZIndex>11</ZIndex>
<Style></Style>
<Border>
<Color>DarkGray</Color>
<Style></Style>Solid</Style>
</Border>
<LeftBorder>
<Style></Style>None</Style>
</LeftBorder>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>4pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="Id">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Label>In Progress Changes</Label>
<Value>=Sum(
IIF(
Parameters!InProgressStatus.Value = Fields!StatusValue.Value
,1
,0
)
,
"Table_Change_Group"
)</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<TextDecoration>None</TextDecoration>
</Style>
</TextRun>
</TextRuns>
<Style /></Style>
</Paragraph>
</Paragraphs>
<rd:DefaultName>Id</rd:DefaultName>
<ZIndex>11</ZIndex>
<Style></Style>
<Border>
<Color>DarkGray</Color>
<Style></Style>Solid</Style>
</Border>
<LeftBorder>
<Style></Style>None</Style>
</LeftBorder>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>4pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="Title">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Label>Completed Changes</Label>
<Value>=Sum
(
IIF(

Parameters!CompletedStatus.Value = Fields!StatusValue.Value OR
(
Parameters!ClosedStatus.Value = Fields!StatusValue.Value AND
Fields!NumberOfCompletedActivities.Value = Fields!NumberOfActivities.Value
)
,1,0),

"Table_Change_Group"
)</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style /></Style>
</Paragraph>
</Paragraphs>
<rd:DefaultName>Title</rd:DefaultName>
<ZIndex>9</ZIndex>
<Style></Style>
<Border>
<Color>DarkGray</Color>
<Style></Style>Solid</Style>
</Border>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>4pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="FailedChanges">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Sum
(
IIF(
Parameters!FailedStatus.Value = Fields!StatusValue.Value OR

(
Parameters!ClosedStatus.Value = Fields!StatusValue.Value AND
Fields!NumberOfFailedActivities.Value &lt;&gt; 0
)

,1,0
)
,
"Table_Change_Group"
)</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style /></Style>
</Paragraph>
</Paragraphs>
<ZIndex>4</ZIndex>
<Style></Style>
<Border>
<Color>DarkGray</Color>
<Style></Style>Solid</Style>
</Border>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>4pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="Status_1">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Sum
(
IIF
(
Parameters!CancelledStatus.Value = Fields!StatusValue.Value
,1
,0
)
,
"Table_Change_Group"
)</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style /></Style>
</Paragraph>
</Paragraphs>
<rd:DefaultName>Status_1</rd:DefaultName>
<ZIndex>10</ZIndex>
<Style></Style>
<Border>
<Color>DarkGray</Color>
<Style></Style>Solid</Style>
</Border>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>4pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="Textbox18">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=IIF(Sum(
IIF(
(not(Fields!ActualStartDate.Value is nothing) and not(Fields!ActualEndDate.Value is nothing)),
1,
0
)
) = 0,
"-",
ToDouble(Avg(
IIF(
(not(Fields!ActualStartDate.Value is nothing) and
not(Fields!ActualEndDate.Value is nothing)) ,
ToDouble(DateDiff("h", Fields!ActualStartDate.Value, Fields!ActualEndDate.Value))/24,
nothing
)
)).ToString("N")
)</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style /></Style>
</Paragraph>
</Paragraphs>
<rd:DefaultName>Textbox18</rd:DefaultName>
<Style></Style>
<Border>
<Color>DarkGray</Color>
<Style></Style>Solid</Style>
</Border>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>4pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
</TablixCells>
</TablixRow>
</TablixRows>
</TablixBody>
<TablixColumnHierarchy>
<TablixMembers>
<TablixMember />
<TablixMember />
<TablixMember />
<TablixMember />
<TablixMember />
<TablixMember />
</TablixMembers>
</TablixColumnHierarchy>
<TablixRowHierarchy>
<TablixMembers>
<TablixMember>
<FixedData>true</FixedData>
<KeepTogether>true</KeepTogether>
</TablixMember>
<TablixMember>
<TablixMembers>
<TablixMember>
<Group Name="Table_Change_Group">
<GroupExpressions>
<GroupExpression>=Fields!AggregatedTime.Value</GroupExpression>
</GroupExpressions>
</Group>
<SortExpressions>
<SortExpression>
<Value>=Fields!AggregatedTime.Value</Value>
</SortExpression>
</SortExpressions>
<TablixMembers>
<TablixMember />
</TablixMembers>
</TablixMember>
</TablixMembers>
<DataElementName>Detail_Collection</DataElementName>
<DataElementOutput>Output</DataElementOutput>
<KeepTogether>true</KeepTogether>
</TablixMember>
</TablixMembers>
</TablixRowHierarchy>
<RepeatColumnHeaders>true</RepeatColumnHeaders>
<RepeatRowHeaders>true</RepeatRowHeaders>
<NoRowsMessage>There is no data available for this report.</NoRowsMessage>
<DataSetName>Table_ChangeKPI</DataSetName>
<Top>8.10833in</Top>
<Left>0.15208in</Left>
<Height>0.70417in</Height>
<Width>10.59378in</Width>
<ZIndex>4</ZIndex>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<TextAlign>Center</TextAlign>
</Style>
</Tablix>
<Image Name="image2">
<Source>External</Source>
<Value>Report_Header_Landscape.png</Value>
<Sizing>FitProportional</Sizing>
<Top>0.19075in</Top>
<Left>0.14792in</Left>
<Height>0.73981in</Height>
<Width>10.59792in</Width>
<ZIndex>5</ZIndex>
<Style /></Style>
</Image>
<Chart Name="Chart2">
<ChartCategoryHierarchy>
<ChartMembers>
<ChartMember>
<Group Name="Chart2_CategoryGroup1">
<GroupExpressions>
<GroupExpression>=Fields!AggregatedTime.Value</GroupExpression>
</GroupExpressions>
</Group>
<SortExpressions>
<SortExpression>
<Value>=Fields!AggregatedTime.Value</Value>
</SortExpression>
</SortExpressions>
<Label>=Fields!AggregatedTime.Value</Label>
</ChartMember>
</ChartMembers>
</ChartCategoryHierarchy>
<ChartSeriesHierarchy>
<ChartMembers>
<ChartMember>
<Label>Impact</Label>
</ChartMember>
<ChartMember>
<Label>Category</Label>
</ChartMember>
<ChartMember>
<Label />
</ChartMember>
</ChartMembers>
</ChartSeriesHierarchy>
<ChartData>
<ChartSeriesCollection>
<ChartSeries Name="Impact">
<ChartDataPoints>
<ChartDataPoint>
<ChartDataPointValues>
<X>=Fields!AggregatedTime.Value</X>
<Y>=Int(Sum(IIF(Parameters!MajorChange.Value = Fields!Category.Value,1,0)))</Y>
</ChartDataPointValues>
<ChartDataLabel>
<Style /></Style>
</ChartDataLabel>
<Style></Style>
<Border>
<Color>CornflowerBlue</Color>
<Width>0.5pt</Width>
</Border>
<Color>CornflowerBlue</Color>
<BackgroundGradientType>TopBottom</BackgroundGradientType>
<BackgroundGradientEndColor>LightBlue</BackgroundGradientEndColor>
</Style>
<ChartMarker>
<Type>Auto</Type>
<Style /></Style>
</ChartMarker>
<DataElementOutput>Output</DataElementOutput>
</ChartDataPoint>
</ChartDataPoints>
<Type>Line</Type>
<Style></Style>
<ShadowOffset>0.5pt</ShadowOffset>
</Style>
<ChartEmptyPoints>
<Style /></Style>
<ChartMarker>
<Style /></Style>
</ChartMarker>
<ChartDataLabel>
<Style /></Style>
</ChartDataLabel>
</ChartEmptyPoints>
<ChartItemInLegend>
<LegendText>=Code.GetLocTable("LT_Table").GetString("T.MajorChange", "[Category - Major Change]")</LegendText>
</ChartItemInLegend>
<ValueAxisName>Primary</ValueAxisName>
<CategoryAxisName>Primary</CategoryAxisName>
<ChartSmartLabel>
<CalloutLineColor>Black</CalloutLineColor>
<MinMovingDistance>0pt</MinMovingDistance>
</ChartSmartLabel>
</ChartSeries>
<ChartSeries Name="MinorChange">
<ChartDataPoints>
<ChartDataPoint>
<ChartDataPointValues>
<X>=Fields!AggregatedTime.Value</X>
<Y>=Int(Sum(IIF(Parameters!MinorChange.Value = Fields!Category.Value,1,0)))</Y>
</ChartDataPointValues>
<ChartDataLabel>
<Style /></Style>
</ChartDataLabel>
<Style></Style>
<Border>
<Color>Orange</Color>
<Width>0.5pt</Width>
</Border>
<Color>Orange</Color>
<BackgroundGradientType>TopBottom</BackgroundGradientType>
<BackgroundGradientEndColor>Gold</BackgroundGradientEndColor>
</Style>
<ChartMarker>
<Type>Auto</Type>
<Style /></Style>
</ChartMarker>
<DataElementOutput>Output</DataElementOutput>
</ChartDataPoint>
</ChartDataPoints>
<Type>Line</Type>
<Style></Style>
<ShadowOffset>0.5pt</ShadowOffset>
</Style>
<ChartEmptyPoints>
<Style /></Style>
<ChartMarker>
<Style /></Style>
</ChartMarker>
<ChartDataLabel>
<Style /></Style>
</ChartDataLabel>
</ChartEmptyPoints>
<ChartItemInLegend>
<LegendText>=Code.GetLocTable("LT_Table").GetString("T.MinorChange", "[Category - Minor Change]")</LegendText>
</ChartItemInLegend>
<ValueAxisName>Primary</ValueAxisName>
<CategoryAxisName>Primary</CategoryAxisName>
<ChartSmartLabel>
<CalloutLineColor>Black</CalloutLineColor>
<MinMovingDistance>0pt</MinMovingDistance>
</ChartSmartLabel>
</ChartSeries>
<ChartSeries Name="AvgProcessTime">
<ChartDataPoints>
<ChartDataPoint>
<ChartDataPointValues>
<X>=Fields!AggregatedTime.Value</X>
<Y>=IIF(
SUM(
IIF(
IsNothing(Fields!ActualEndDate.Value) = False
AND
IsNothing(Fields!ActualStartDate.Value) = False,
1,0)
)
&gt;0,
Avg(
IIF(
(not(Fields!ActualStartDate.Value is nothing) and
not(Fields!ActualEndDate.Value is nothing)) ,
ToDouble(DateDiff("h", Fields!ActualStartDate.Value, Fields!ActualEndDate.Value))/24,
nothing
)
),
0
)</Y>
</ChartDataPointValues>
<ChartDataLabel>
<Style /></Style>
</ChartDataLabel>
<Style></Style>
<Border />
<Color>Tomato</Color>
</Style>
<ChartMarker>
<Type>Auto</Type>
<Size>5pt</Size>
<Style></Style>
<Border>
<Width>1.5pt</Width>
</Border>
</Style>
</ChartMarker>
<DataElementOutput>Output</DataElementOutput>
</ChartDataPoint>
</ChartDataPoints>
<Type>Line</Type>
<Style></Style>
<ShadowOffset>0.5pt</ShadowOffset>
</Style>
<ChartEmptyPoints>
<Style /></Style>
<ChartMarker>
<Style /></Style>
</ChartMarker>
<ChartDataLabel>
<Style /></Style>
</ChartDataLabel>
</ChartEmptyPoints>
<ChartItemInLegend>
<LegendText>=Code.GetLocTable("LT_Table").GetString("T.AverageProcessTimePerChange", "[Average process time per change]")</LegendText>
</ChartItemInLegend>
<ValueAxisName>Secondary</ValueAxisName>
<CategoryAxisName>Primary</CategoryAxisName>
<ChartSmartLabel>
<CalloutLineColor>Black</CalloutLineColor>
<MinMovingDistance>0pt</MinMovingDistance>
</ChartSmartLabel>
</ChartSeries>
</ChartSeriesCollection>
</ChartData>
<ChartAreas>
<ChartArea Name="Default">
<ChartCategoryAxes>
<ChartAxis Name="Primary">
<Style></Style>
<Border>
<Color>Silver</Color>
</Border>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<Format>=Switch(
Parameters!Aggregation.Value = "Daily",
"d",
Parameters!Aggregation.Value = "Weekly",
"D",
Parameters!Aggregation.Value = "Monthly",
"MMM yyyy",
Parameters!Aggregation.Value = "Quarterly",
"MMM yyyy",
Parameters!Aggregation.Value = "Yearly",
"yyyy")</Format>
</Style>
<ChartAxisTitle>
<Caption />
<Style></Style>
<FontSize>8pt</FontSize>
</Style>
</ChartAxisTitle>
<Interval>=IIF(Parameters!Aggregation.Value = "Quarterly", 3, 0)</Interval>
<IntervalType>=Switch(
Parameters!Aggregation.Value = "Daily", "Days",
Parameters!Aggregation.Value = "Weekly", "Weeks",
Parameters!Aggregation.Value = "Monthly", "Months",
Parameters!Aggregation.Value = "Quarterly", "Months",
Parameters!Aggregation.Value = "Yearly", "Years"
)</IntervalType>
<VariableAutoInterval>true</VariableAutoInterval>
<LabelInterval>=IIF(Parameters!Aggregation.Value = "Quarterly", 3, 0)</LabelInterval>
<LabelIntervalType>=Switch(
Parameters!Aggregation.Value = "Daily", "Days",
Parameters!Aggregation.Value = "Weekly", "Weeks",
Parameters!Aggregation.Value = "Monthly", "Months",
Parameters!Aggregation.Value = "Quarterly", "Months",
Parameters!Aggregation.Value = "Yearly", "Years"
)</LabelIntervalType>
<ChartMajorGridLines>
<Enabled>False</Enabled>
<Style></Style>
<Border>
<Color>Gainsboro</Color>
</Border>
</Style>
</ChartMajorGridLines>
<ChartMinorGridLines>
<Style></Style>
<Border>
<Color>Gainsboro</Color>
<Style></Style>Dotted</Style>
</Border>
</Style>
</ChartMinorGridLines>
<ChartMajorTickMarks>
<Style></Style>
<Border>
<Color>Silver</Color>
</Border>
</Style>
</ChartMajorTickMarks>
<ChartMinorTickMarks>
<Length>0.5</Length>
</ChartMinorTickMarks>
<CrossAt>NaN</CrossAt>
<Minimum>NaN</Minimum>
<Maximum>NaN</Maximum>
</ChartAxis>
<ChartAxis Name="Secondary">
<Style></Style>
<FontSize>8pt</FontSize>
</Style>
<ChartAxisTitle>
<Caption>Axis Title</Caption>
<Style></Style>
<FontSize>8pt</FontSize>
</Style>
</ChartAxisTitle>
<ChartMajorGridLines>
<Enabled>False</Enabled>
<Style></Style>
<Border>
<Color>Gainsboro</Color>
</Border>
</Style>
</ChartMajorGridLines>
<ChartMinorGridLines>
<Style></Style>
<Border>
<Color>Gainsboro</Color>
<Style></Style>Dotted</Style>
</Border>
</Style>
</ChartMinorGridLines>
<ChartMinorTickMarks>
<Length>0.5</Length>
</ChartMinorTickMarks>
<CrossAt>NaN</CrossAt>
<Location>Opposite</Location>
<Minimum>NaN</Minimum>
<Maximum>NaN</Maximum>
</ChartAxis>
</ChartCategoryAxes>
<ChartValueAxes>
<ChartAxis Name="Primary">
<Style></Style>
<Border>
<Color>Silver</Color>
</Border>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
<ChartAxisTitle>
<Caption>=Code.GetLocTable("LT_Table").GetString("T.ChangeRequests", "[Change Requests]")</Caption>
<Style></Style>
<FontSize>8pt</FontSize>
</Style>
</ChartAxisTitle>
<VariableAutoInterval>true</VariableAutoInterval>
<LabelIntervalType>Auto</LabelIntervalType>
<ChartMajorGridLines>
<Style></Style>
<Border>
<Color>Gainsboro</Color>
</Border>
</Style>
</ChartMajorGridLines>
<ChartMinorGridLines>
<Style></Style>
<Border>
<Color>Gainsboro</Color>
<Style></Style>Dotted</Style>
</Border>
</Style>
</ChartMinorGridLines>
<ChartMajorTickMarks>
<Style></Style>
<Border>
<Color>Silver</Color>
</Border>
</Style>
</ChartMajorTickMarks>
<ChartMinorTickMarks>
<Length>0.5</Length>
</ChartMinorTickMarks>
<CrossAt>NaN</CrossAt>
<Minimum>NaN</Minimum>
<Maximum>NaN</Maximum>
</ChartAxis>
<ChartAxis Name="Secondary">
<Style></Style>
<Border>
<Color>Silver</Color>
</Border>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<Format>f2</Format>
</Style>
<ChartAxisTitle>
<Caption>=Code.GetLocTable("LT_Table").GetString("T.TimeDays", "[Time(Days)]")</Caption>
<Style></Style>
<FontSize>8pt</FontSize>
</Style>
</ChartAxisTitle>
<ChartMajorGridLines>
<Enabled>False</Enabled>
<Style></Style>
<Border>
<Color>Gainsboro</Color>
</Border>
</Style>
</ChartMajorGridLines>
<ChartMinorGridLines>
<Style></Style>
<Border>
<Color>Gainsboro</Color>
<Style></Style>Dotted</Style>
</Border>
</Style>
</ChartMinorGridLines>
<ChartMajorTickMarks>
<Style></Style>
<Border>
<Color>Silver</Color>
</Border>
</Style>
</ChartMajorTickMarks>
<ChartMinorTickMarks>
<Length>0.5</Length>
</ChartMinorTickMarks>
<CrossAt>NaN</CrossAt>
<Location>Opposite</Location>
<Minimum>NaN</Minimum>
<Maximum>NaN</Maximum>
</ChartAxis>
</ChartValueAxes>
<Style></Style>
<BackgroundColor>White</BackgroundColor>
<BackgroundGradientType>TopBottom</BackgroundGradientType>
<BackgroundGradientEndColor>Gainsboro</BackgroundGradientEndColor>
</Style>
</ChartArea>
</ChartAreas>
<ChartLegends>
<ChartLegend Name="Default">
<Style></Style>
<BackgroundGradientType>None</BackgroundGradientType>
<BackgroundGradientEndColor>Gainsboro</BackgroundGradientEndColor>
<FontSize>8pt</FontSize>
</Style>
<Position>BottomCenter</Position>
<DockOutsideChartArea>true</DockOutsideChartArea>
<ChartLegendTitle>
<Caption />
<Style></Style>
<FontSize>8pt</FontSize>
<FontWeight>Bold</FontWeight>
<TextAlign>Center</TextAlign>
</Style>
</ChartLegendTitle>
<HeaderSeparatorColor>Black</HeaderSeparatorColor>
<ColumnSeparatorColor>Black</ColumnSeparatorColor>
</ChartLegend>
</ChartLegends>
<ChartTitles>
<ChartTitle Name="Default">
<Caption>=Code.GetLocTable("LT_Table").GetString("T.AverageProcessTimePerChange", "[Average process time per change]")</Caption>
<Style></Style>
<BackgroundGradientType>None</BackgroundGradientType>
<FontFamily>Tahoma</FontFamily>
<FontWeight>Bold</FontWeight>
<TextAlign>General</TextAlign>
<VerticalAlign>Top</VerticalAlign>
</Style>
</ChartTitle>
</ChartTitles>
<Palette>BrightPastel</Palette>
<ChartBorderSkin>
<Style></Style>
<BackgroundColor>Gray</BackgroundColor>
<BackgroundGradientType>None</BackgroundGradientType>
<Color>White</Color>
</Style>
</ChartBorderSkin>
<ChartNoDataMessage Name="NoDataMessage">
<Caption>No Data Available</Caption>
<Style></Style>
<BackgroundGradientType>None</BackgroundGradientType>
<TextAlign>General</TextAlign>
<VerticalAlign>Top</VerticalAlign>
</Style>
</ChartNoDataMessage>
<DataSetName>Table_ChangeKPI</DataSetName>
<Top>5.1198in</Top>
<Left>0.15208in</Left>
<Height>2.91909in</Height>
<Width>10.59584in</Width>
<ZIndex>6</ZIndex>
<Style></Style>
<Border>
<Color>LightGrey</Color>
<Style></Style>None</Style>
</Border>
<BackgroundColor>White</BackgroundColor>
<BackgroundGradientType>None</BackgroundGradientType>
</Style>
</Chart>
</ReportItems>
<Height>8.95833in</Height>
<Style /></Style>
</Script></Body>
<ReportParameters>
<ReportParameter Name="Interactive">
<DataType>Boolean</DataType>
<DefaultValue>
<Values>
<Value>False</Value>
</Values>
</DefaultValue>
<Prompt>Interactive</Prompt>
<Hidden>true</Hidden>
</ReportParameter>
<ReportParameter Name="LT_Report">
<DataType>String</DataType>
<DefaultValue>
<DataSetReference>
<DataSetName>LT_Report</DataSetName>
<ValueField>XML_F52E2B61_18A1_11d1_B105_00805F49916B</ValueField>
</DataSetReference>
</DefaultValue>
<Hidden>true</Hidden>
</ReportParameter>
<ReportParameter Name="LT_Strings">
<DataType>String</DataType>
<DefaultValue>
<DataSetReference>
<DataSetName>LT_Strings</DataSetName>
<ValueField>XML_F52E2B61_18A1_11d1_B105_00805F49916B</ValueField>
</DataSetReference>
</DefaultValue>
<Hidden>true</Hidden>
</ReportParameter>
<ReportParameter Name="LT_Table">
<DataType>String</DataType>
<DefaultValue>
<DataSetReference>
<DataSetName>LT_Table</DataSetName>
<ValueField>XML_F52E2B61_18A1_11d1_B105_00805F49916B</ValueField>
</DataSetReference>
</DefaultValue>
<Hidden>true</Hidden>
</ReportParameter>
<ReportParameter Name="LT_Parameters">
<DataType>String</DataType>
<DefaultValue>
<DataSetReference>
<DataSetName>LT_Parameters</DataSetName>
<ValueField>XML_F52E2B61_18A1_11d1_B105_00805F49916B</ValueField>
</DataSetReference>
</DefaultValue>
<Hidden>true</Hidden>
</ReportParameter>
<ReportParameter Name="AllLabel">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>=Code.GetLocTable("LT_Strings").GetString("S.All", "[All]")</Value>
</Values>
</DefaultValue>
<Hidden>true</Hidden>
</ReportParameter>
<ReportParameter Name="DateFilter">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>Created</Value>
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>Date Filter</Prompt>
</ReportParameter>
<ReportParameter Name="TimeType">
<DataType>String</DataType>
<Nullable>true</Nullable>
<AllowBlank>true</AllowBlank>
<Hidden>true</Hidden>
</ReportParameter>
<ReportParameter Name="ID">
<DataType>String</DataType>
<Nullable>true</Nullable>
<AllowBlank>true</AllowBlank>
<Prompt>ID</Prompt>
</ReportParameter>
<ReportParameter Name="Description">
<DataType>String</DataType>
<Nullable>true</Nullable>
<DefaultValue>
<Values>
<Value xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>Description</Prompt>
</ReportParameter>
<ReportParameter Name="Status">
<DataType>Integer</DataType>
<DefaultValue>
<Values>
<Value>-1</Value>
</Values>
</DefaultValue>
<Prompt>Status</Prompt>
<ValidValues>
<DataSetReference>
<DataSetName>List_Status</DataSetName>
<ValueField>Value</ValueField>
<LabelField>Label</LabelField>
</DataSetReference>
</ValidValues>
<MultiValue>true</MultiValue>
</ReportParameter>
<ReportParameter Name="Priority">
<DataType>Integer</DataType>
<DefaultValue>
<Values>
<Value>-1</Value>
</Values>
</DefaultValue>
<Prompt>Priority</Prompt>
<ValidValues>
<DataSetReference>
<DataSetName>List_Priority</DataSetName>
<ValueField>Value</ValueField>
<LabelField>Label</LabelField>
</DataSetReference>
</ValidValues>
<MultiValue>true</MultiValue>
</ReportParameter>
<ReportParameter Name="Impact">
<DataType>Integer</DataType>
<DefaultValue>
<Values>
<Value>-1</Value>
</Values>
</DefaultValue>
<Prompt>Impact</Prompt>
<ValidValues>
<DataSetReference>
<DataSetName>List_Impact</DataSetName>
<ValueField>Value</ValueField>
<LabelField>Label</LabelField>
</DataSetReference>
</ValidValues>
<MultiValue>true</MultiValue>
</ReportParameter>
<ReportParameter Name="Category">
<DataType>Integer</DataType>
<DefaultValue>
<Values>
<Value>-1</Value>
</Values>
</DefaultValue>
<Prompt>Category</Prompt>
<ValidValues>
<DataSetReference>
<DataSetName>List_Category</DataSetName>
<ValueField>Value</ValueField>
<LabelField>Label</LabelField>
</DataSetReference>
</ValidValues>
<MultiValue>true</MultiValue>
</ReportParameter>
<ReportParameter Name="Risk">
<DataType>Integer</DataType>
<DefaultValue>
<Values>
<Value>-1</Value>
</Values>
</DefaultValue>
<Prompt>Risk</Prompt>
<ValidValues>
<DataSetReference>
<DataSetName>List_Risk</DataSetName>
<ValueField>Value</ValueField>
<LabelField>Label</LabelField>
</DataSetReference>
</ValidValues>
<MultiValue>true</MultiValue>
</ReportParameter>
<ReportParameter Name="AssignedTo">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value />
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>Assigned To User</Prompt>
</ReportParameter>
<ReportParameter Name="CreatedBy">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value />
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>Created By</Prompt>
</ReportParameter>
<ReportParameter Name="ChangeResult">
<DataType>Integer</DataType>
<DefaultValue>
<Values>
<Value>-1</Value>
</Values>
</DefaultValue>
<Prompt>Change Result</Prompt>
<ValidValues>
<DataSetReference>
<DataSetName>List_ChangeResult</DataSetName>
<ValueField>Value</ValueField>
<LabelField>Label</LabelField>
</DataSetReference>
</ValidValues>
<MultiValue>true</MultiValue>
</ReportParameter>
<ReportParameter Name="ClosedStatus">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>ChangeStatusEnum.Closed</Value>
</Values>
</DefaultValue>
<Prompt>ClosedStatus</Prompt>
<Hidden>true</Hidden>
</ReportParameter>
<ReportParameter Name="CancelledStatus">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>ChangeStatusEnum.Cancelled</Value>
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>CancelledStatus</Prompt>
<Hidden>true</Hidden>
</ReportParameter>
<ReportParameter Name="CompletedStatus">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>ChangeStatusEnum.Completed</Value>
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>CompletedStatus</Prompt>
<Hidden>true</Hidden>
</ReportParameter>
<ReportParameter Name="FailedStatus">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>ChangeStatusEnum.Failed</Value>
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>FailedStatus</Prompt>
<Hidden>true</Hidden>
</ReportParameter>
<ReportParameter Name="EmergencyCategory">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>ChangeCategoryEnum.Emergency</Value>
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>EmergencyCategory</Prompt>
<Hidden>true</Hidden>
</ReportParameter>
<ReportParameter Name="SubmittedStatus">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>ChangeStatusEnum.Submitted</Value>
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>SubmittedStatus</Prompt>
<Hidden>true</Hidden>
</ReportParameter>
<ReportParameter Name="OnHoldStatus">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>ChangeStatusEnum.OnHold</Value>
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>OnHoldStatus</Prompt>
<Hidden>true</Hidden>
</ReportParameter>
<ReportParameter Name="NewStatus">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>ChangeStatusEnum.New</Value>
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>NewStatus</Prompt>
<Hidden>true</Hidden>
</ReportParameter>
<ReportParameter Name="InProgressStatus">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>ChangeStatusEnum.InProgress</Value>
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>InProgressStatus</Prompt>
<Hidden>true</Hidden>
</ReportParameter>
<ReportParameter Name="Aggregation">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>Daily</Value>
</Values>
</DefaultValue>
<Prompt>Aggregation</Prompt>
<ValidValues>
<ParameterValues>
<ParameterValue>
<Value>Daily</Value>
<Label>=Code.GetLocTable("LT_Parameters").GetString("P.A.Daily", "[Daily]")</Label>
</ParameterValue>
<ParameterValue>
<Value>Weekly</Value>
<Label>=Code.GetLocTable("LT_Parameters").GetString("P.A.Weekly", "[Weekly]")</Label>
</ParameterValue>
<ParameterValue>
<Value>Monthly</Value>
<Label>=Code.GetLocTable("LT_Parameters").GetString("P.A.Monthly", "[Monthly]")</Label>
</ParameterValue>
<ParameterValue>
<Value>Quarterly</Value>
<Label>=Code.GetLocTable("LT_Parameters").GetString("P.A.Quarterly", "[Quarterly]")</Label>
</ParameterValue>
<ParameterValue>
<Value>Yearly</Value>
<Label>=Code.GetLocTable("LT_Parameters").GetString("P.A.Yearly", "[Yearly]")</Label>
</ParameterValue>
</ParameterValues>
</ValidValues>
</ReportParameter>
<ReportParameter Name="ActivityType">
<DataType>String</DataType>
<Nullable>true</Nullable>
<DefaultValue>
<Values>
<Value xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />
</Values>
</DefaultValue>
<Prompt>Activity Type</Prompt>
<ValidValues>
<ParameterValues>
<ParameterValue>
<Label>=Code.GetLocTable("LT_Strings").GetString("S.All", "[All]")</Label>
</ParameterValue>
<ParameterValue>
<Value>System.WorkItem.Activity.ReviewActivity</Value>
<Label>=Code.GetLocTable("LT_Strings").GetString("S.Review", "[Review]")</Label>
</ParameterValue>
<ParameterValue>
<Value>System.WorkItem.Activity.ManualActivity</Value>
<Label>=Code.GetLocTable("LT_Strings").GetString("S.Manual", "[Manual]")</Label>
</ParameterValue>
</ParameterValues>
</ValidValues>
</ReportParameter>
<ReportParameter Name="MajorChange">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>ChangeCategoryEnum.Major</Value>
</Values>
</DefaultValue>
<Prompt>MajorChange</Prompt>
<Hidden>true</Hidden>
</ReportParameter>
<ReportParameter Name="MinorChange">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>ChangeCategoryEnum.Minor</Value>
</Values>
</DefaultValue>
<Prompt>MinorChange</Prompt>
<Hidden>true</Hidden>
</ReportParameter>
<ReportParameter Name="ActivityName">
<DataType>String</DataType>
<Nullable>true</Nullable>
<AllowBlank>true</AllowBlank>
<Prompt>Activity Name</Prompt>
</ReportParameter>
<ReportParameter Name="ActivityStatus">
<DataType>Integer</DataType>
<DefaultValue>
<Values>
<Value>-1</Value>
</Values>
</DefaultValue>
<Prompt>Activity Status</Prompt>
<ValidValues>
<DataSetReference>
<DataSetName>List_ActivityStatus</DataSetName>
<ValueField>Value</ValueField>
<LabelField>Label</LabelField>
</DataSetReference>
</ValidValues>
</ReportParameter>
<ReportParameter Name="ActivityStage">
<DataType>Integer</DataType>
<DefaultValue>
<Values>
<Value>-1</Value>
</Values>
</DefaultValue>
<Prompt>Activity Stage</Prompt>
<ValidValues>
<DataSetReference>
<DataSetName>List_ActivityStage</DataSetName>
<ValueField>Value</ValueField>
<LabelField>Label</LabelField>
</DataSetReference>
</ValidValues>
<MultiValue>true</MultiValue>
</ReportParameter>
<ReportParameter Name="ActivityID">
<DataType>String</DataType>
<Nullable>true</Nullable>
<DefaultValue>
<Values>
<Value xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>Activity ID</Prompt>
</ReportParameter>
<ReportParameter Name="CIName">
<DataType>String</DataType>
<Nullable>true</Nullable>
<AllowBlank>true</AllowBlank>
<Prompt>CI Name</Prompt>
</ReportParameter>
<ReportParameter Name="TimeZone">
<DataType>String</DataType>
<Nullable>true</Nullable>
<Prompt>TimeZone</Prompt>
</ReportParameter>
<ReportParameter Name="TimeZoneName">
<DataType>String</DataType>
<Nullable>true</Nullable>
<AllowBlank>true</AllowBlank>
<Prompt>TimeZoneName</Prompt>
<Hidden>true</Hidden>
</ReportParameter>
<ReportParameter Name="StartDate_BaseType">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>Today</Value>
</Values>
</DefaultValue>
<Prompt>Start Date Type</Prompt>
</ReportParameter>
<ReportParameter Name="StartDate_BaseValue">
<DataType>DateTime</DataType>
<Prompt>Start Date Value</Prompt>
</ReportParameter>
<ReportParameter Name="StartDate_OffsetType">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>Month</Value>
</Values>
</DefaultValue>
<Prompt>Start Date Offset Type</Prompt>
</ReportParameter>
<ReportParameter Name="StartDate_OffsetValue">
<DataType>Integer</DataType>
<Nullable>true</Nullable>
<DefaultValue>
<Values>
<Value>-1</Value>
</Values>
</DefaultValue>
<Prompt>Start Date Offset Value</Prompt>
</ReportParameter>
<ReportParameter Name="EndDate_BaseType">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>Today</Value>
</Values>
</DefaultValue>
<Prompt>End Date Type</Prompt>
</ReportParameter>
<ReportParameter Name="EndDate_BaseValue">
<DataType>DateTime</DataType>
<Prompt>End Date Value</Prompt>
</ReportParameter>
<ReportParameter Name="EndDate_OffsetType">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>None</Value>
</Values>
</DefaultValue>
<Prompt>End Date Offset Type</Prompt>
</ReportParameter>
<ReportParameter Name="EndDate_OffsetValue">
<DataType>Integer</DataType>
<Nullable>true</Nullable>
<Prompt>End Date Offset Value</Prompt>
</ReportParameter>
<ReportParameter Name="StartDate_ScheduledStart">
<DataType>DateTime</DataType>
<Nullable>true</Nullable>
<DefaultValue>
<Values>
<Value xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />
</Values>
</DefaultValue>
<Prompt>(Scheduled Start) From</Prompt>
</ReportParameter>
<ReportParameter Name="EndDate_ScheduledStart">
<DataType>DateTime</DataType>
<Nullable>true</Nullable>
<DefaultValue>
<Values>
<Value xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />
</Values>
</DefaultValue>
<Prompt>(Scheduled Start) To</Prompt>
</ReportParameter>
<ReportParameter Name="StartDate_ScheduledEnd">
<DataType>DateTime</DataType>
<Nullable>true</Nullable>
<DefaultValue>
<Values>
<Value xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />
</Values>
</DefaultValue>
<Prompt>(Scheduled End) From</Prompt>
</ReportParameter>
<ReportParameter Name="EndDate_ScheduledEnd">
<DataType>DateTime</DataType>
<Nullable>true</Nullable>
<DefaultValue>
<Values>
<Value xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />
</Values>
</DefaultValue>
<Prompt>(Scheduled End) To</Prompt>
</ReportParameter>
<ReportParameter Name="StartDate_ActualStart">
<DataType>DateTime</DataType>
<Nullable>true</Nullable>
<DefaultValue>
<Values>
<Value xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />
</Values>
</DefaultValue>
<Prompt>(Actual Start) From</Prompt>
</ReportParameter>
<ReportParameter Name="EndDate_ActualStart">
<DataType>DateTime</DataType>
<Nullable>true</Nullable>
<DefaultValue>
<Values>
<Value xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />
</Values>
</DefaultValue>
<Prompt>(Actual Start) To</Prompt>
</ReportParameter>
<ReportParameter Name="StartDate_ActualEnd">
<DataType>DateTime</DataType>
<Nullable>true</Nullable>
<DefaultValue>
<Values>
<Value xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />
</Values>
</DefaultValue>
<Prompt>(Actual End) From</Prompt>
</ReportParameter>
<ReportParameter Name="EndDate_ActualEnd">
<DataType>DateTime</DataType>
<Nullable>true</Nullable>
<DefaultValue>
<Values>
<Value xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />
</Values>
</DefaultValue>
<Prompt>(Actual End) To</Prompt>
</ReportParameter>
</ReportParameters>
<Code><Script>
Const LocTableStringQuery As String = "R/S[@N='{0}']/text()"

Const TimeZoneParameterName As String = "TimeZone"
Const SD_BaseTypeParameterName As String = "StartDate_BaseType"
Const SD_BaseValueParameterName As String = "StartDate_BaseValue"
Const SD_OffsetTypeParameterName As String = "StartDate_OffsetType"
Const SD_OffsetValueParameterName As String = "StartDate_OffsetValue"
Const ED_BaseTypeParameterName As String = "EndDate_BaseType"
Const ED_BaseValueParameterName As String = "EndDate_BaseValue"
Const ED_OffsetTypeParameterName As String = "EndDate_OffsetType"
Const ED_OffsetValueParameterName As String = "EndDate_OffsetValue"
Const IsRelativeTimeSupported As Boolean = False
Const TimeTypeParameterName As String = "TimeType"
Const TimeWeekMapParameterName As String = "TimeWeekMap"

Public NumberOfChangesInPipeline As Integer
Public NumberOfEmergencyChanges As Integer
Public NumberOfFailedChanges As Integer
Public NumberOfImplementedChanges As Integer

Public NumberOfChangesInPipelineOnChart As Integer
Public NumberOfEmergencyChangesOnChart As Integer
Public NumberOfChangesInPipelineOnChartEmergency As Integer
Public NumberOfImplementedChangesOnChart As Integer


Dim LocTables As System.Collections.Generic.Dictionary(Of String, Microsoft.EnterpriseManagement.Reporting.XmlStringTable)
Dim ReportTimeZone As Microsoft.EnterpriseManagement.Reporting.TimeZoneCoreInformation
Dim ReportStartDate As DateTime
Dim ReportEndDate As DateTime
Dim ReportTime As Microsoft.EnterpriseManagement.Reporting.ParameterProcessor.RelativeTime
Dim ReportCulture As System.Globalization.CultureInfo
Dim ParameterProcessor As Microsoft.EnterpriseManagement.Reporting.ParameterProcessor
Dim TargetList As String

Protected Overrides Sub OnInit()
LocTables = new System.Collections.Generic.Dictionary(Of String, Microsoft.EnterpriseManagement.Reporting.XmlStringTable)()
ReportTimeZone = Nothing
ReportStartDate = DateTime.MinValue
ReportEndDate = DateTime.MinValue
ReportTime = Nothing
ReportCulture = System.Globalization.CultureInfo.GetCultureInfo(Report.User("Language"))
ParameterProcessor = New Microsoft.EnterpriseManagement.Reporting.ParameterProcessor(ReportCulture)
TargetList =Nothing
End Sub

'Public Function GetCallingManagementGroupId() As String
' Return 'Microsoft.EnterpriseManagement.Reporting.ReportingConfiguration.M'anagementGroupId
'End Function

Public Function GetReportLocLanguageCode() As String
Return ReportCulture.ThreeLetterWindowsLanguageName
End Function

Public Function GetReportLCID() As Integer
Return ReportCulture.LCID
End Function

Public Function GetLocTable(Name As String) As Microsoft.EnterpriseManagement.Reporting.XmlStringTable
Dim LocTable As Microsoft.EnterpriseManagement.Reporting.XmlStringTable

If Not LocTables.TryGetValue(Name, LocTable) Then
LocTable = New Microsoft.EnterpriseManagement.Reporting.XmlStringTable(LocTableStringQuery, Report.Parameters(Name).Value)
LocTables.Add(Name, LocTable)
End If

Return LocTable
End Function

Public Function GetReportTimeZone() As Microsoft.EnterpriseManagement.Reporting.TimeZoneCoreInformation
If IsNothing(ReportTimeZone) Then ReportTimeZone = Microsoft.EnterpriseManagement.Reporting.TimeZoneCoreInformation.FromValueString(Report.Parameters(TimeZoneParameterName).Value)
If IsNothing(ReportTimeZone) Then ReportTimeZone = Microsoft.EnterpriseManagement.Reporting.TimeZoneInformation.Current
Return ReportTimeZone
End Function

Public Function ToDbDate(ByVal DateValue As DateTime) As DateTime
return GetReportTimeZone.ToUniversalTime(DateValue)
End Function

Public Function ToReportDate(ByVal DateValue As DateTime) As DateTime
return GetReportTimeZone.ToLocalTime(DateValue)
End Function

Public Function GetReportStartDate() As DateTime
If (ReportStartDate = DateTime.MinValue) Then
If (IsRelativeTimeSupported) Then
ReportStartDate = ParameterProcessor.GetDateTime(ToReportDate(DateTime.UtcNow), Report.Parameters(SD_BaseTypeParameterName).Value, Report.Parameters(SD_BaseValueParameterName).Value, Report.Parameters(SD_OffsetTypeParameterName).Value, Report.Parameters(SD_OffsetValueParameterName).Value, Report.Parameters(TimeTypeParameterName).Value)
Else
ReportStartDate = ParameterProcessor.GetDateTime(ToReportDate(DateTime.UtcNow), Report.Parameters(SD_BaseTypeParameterName).Value, Report.Parameters(SD_BaseValueParameterName).Value, Report.Parameters(SD_OffsetTypeParameterName).Value, Report.Parameters(SD_OffsetValueParameterName).Value)
End if
End If
return ReportStartDate
End Function

Public Function GetReportEndDate() As DateTime
If (ReportEndDate = DateTime.MinValue) Then
If (IsRelativeTimeSupported) Then
ReportEndDate = ParameterProcessor.GetDateTime(ToReportDate(DateTime.UtcNow), Report.Parameters(ED_BaseTypeParameterName).Value, Report.Parameters(ED_BaseValueParameterName).Value, Report.Parameters(ED_OffsetTypeParameterName).Value, Report.Parameters(ED_OffsetValueParameterName).Value, Report.Parameters(TimeTypeParameterName).Value)
If IsBusinessHours(GetReportTimeFilter()) Then ReportEndDate = ReportCulture.Calendar.AddDays(ReportEndDate, 1)
Else
ReportEndDate = ParameterProcessor.GetDateTime(ToReportDate(DateTime.UtcNow), Report.Parameters(ED_BaseTypeParameterName).Value, Report.Parameters(ED_BaseValueParameterName).Value, Report.Parameters(ED_OffsetTypeParameterName).Value, Report.Parameters(ED_OffsetValueParameterName).Value)
End if
End If
return ReportEndDate
End Function

Public Function GetReportTimeFilter() As Microsoft.EnterpriseManagement.Reporting.ParameterProcessor.RelativeTime
If IsNothing(ReportTime) Then ReportTime = New Microsoft.EnterpriseManagement.Reporting.ParameterProcessor.RelativeTime(Report.Parameters(TimeTypeParameterName).Value, Report.Parameters(SD_BaseValueParameterName).Value, Report.Parameters(ED_BaseValueParameterName).Value, CStr(Join(Report.Parameters(TimeWeekMapParameterName).Value, ",")))
return ReportTime
End Function

Public Function IsBusinessHours(Value As Microsoft.EnterpriseManagement.Reporting.ParameterProcessor.RelativeTime) As Boolean
return (Not IsNothing(Value)) And (Value.TimeType = Microsoft.EnterpriseManagement.Reporting.ParameterProcessor.RelativeTimeType.Business)
End Function

Public Function FormatDateTime(Format As String, Value As DateTime) As String
return Value.ToString(Format, ReportCulture)
End Function

Public Function FormatNumber(Format As String, Value As Decimal) As String
return Value.ToString(Format, ReportCulture)
End Function

Public Function FormatString(Format As String, ParamArray Values() as Object) As String
return String.Format(ReportCulture, Format, Values)
End Function

Public Function NullFormatString(Format As String, Value as String) As String
return IIF(String.IsNullOrEmpty(Value), String.Empty, String.Format(ReportCulture, Format, Value))
End Function

Public Function FormatBusinessHours(Format As String, Value As Microsoft.EnterpriseManagement.Reporting.ParameterProcessor.RelativeTime) As String
Dim result As String

If IsBusinessHours(Value) Then

Dim firstDay As DayOfWeek
Dim days As System.Collections.Generic.List(Of String)

firstDay = ReportCulture.DateTimeFormat.FirstDayOfWeek
days = new System.Collections.Generic.List(Of String)()

For loopDay As DayOfWeek = DayOfWeek.Sunday To DayOfWeek.Saturday
Dim day As DayOfWeek
day = CType((CInt(loopDay) + CInt(firstDay)) Mod 7, DayOfWeek)

If value.WeekMap.Contains(day) Then days.Add(ReportCulture.DateTimeFormat.GetAbbreviatedDayName(day))
Next loopDay

result = FormatString(Format, DateTime.Today.Add(Value.StartTime).ToString(ReportCulture.DateTimeFormat.ShortTimePattern), DateTime.Today.Add(Value.EndTime).ToString(ReportCulture.DateTimeFormat.ShortTimePattern), String.Join(",", days.ToArray()))

Else
result = String.Empty
End if

return result
End Function

Public Function BuildXmlValueList(ByVal ValueList() As Object) As String
Return Microsoft.EnterpriseManagement.Reporting.MultiValueParameter.ToXml("Data", "Value", ValueList)
End Function


REM -------------------------------------------------

Dim ReportFormatList As System.Collections.Generic.Dictionary(Of String, IDataFormatter)
Const FormatListParameterName As String = "DataFormat"

REM -------------------------------------------------

Public Interface IDataFormatter
Function FormatData(ByVal Value As String) As String
End Interface

Public Class RankDataFormatter
Implements IDataFormatter

Private Series As System.Collections.Generic.SortedDictionary(Of Decimal, String)
Private Culture As System.Globalization.CultureInfo

Public Sub New(ByVal Config As System.Xml.XmlNode, ByVal ReportCulture As System.Globalization.CultureInfo)
Culture = ReportCulture
Series = New System.Collections.Generic.SortedDictionary(Of Decimal, String)()

For Each SeriesXml As System.Xml.XmlNode In Config.ChildNodes
Series.Add(Decimal.Parse(SeriesXml.Attributes("Rank").Value), SeriesXml.Attributes("Format").Value)
Next
End Sub

Public Function FormatData(ByVal Value As String) As String Implements IDataFormatter.FormatData
Dim Result As String = CDec(Value).ToString("G", Culture)

For Each FormatItem As System.Collections.Generic.KeyValuePair(Of Decimal, String) In Series
Dim RunningValue As Decimal = Math.Round(Value / FormatItem.Key)
If RunningValue &gt; 0 Then
Result = String.Format(Culture, FormatItem.Value, RunningValue.ToString("G", Culture))
Else
Exit For
End If
Next

Return Result
End Function
End Class

Public Class LookupDataFormatter
Implements IDataFormatter

Private MappingTable As System.Collections.Generic.IDictionary(Of String, String)

Public Sub New(ByVal Config As System.Xml.XmlNode)
MappingTable = New System.Collections.Generic.Dictionary(Of String, String)(StringComparer.OrdinalIgnoreCase)
For Each SeriesXml As System.Xml.XmlNode In Config.ChildNodes
MappingTable.Add(Decimal.Parse(SeriesXml.Attributes("Value").Value), SeriesXml.Attributes("Label").Value)
Next
End Sub

Public Function FormatData(ByVal Value As String) As String Implements IDataFormatter.FormatData
Dim Result As String
If MappingTable.ContainsKey(Value) Then
Result = MappingTable(Value)
Else
Result = Value
End If
Return Result
End Function
End Class

Public Function GetReportFormatList() As System.Collections.Generic.Dictionary(Of String, IDataFormatter)
If IsNothing(ReportFormatList) Then
Dim Xml As System.Xml.XmlDocument = New System.Xml.XmlDocument()
Xml.LoadXml(Report.Parameters(FormatListParameterName).Value)

ReportFormatList = New System.Collections.Generic.Dictionary(Of String, IDataFormatter)(StringComparer.OrdinalIgnoreCase)
For Each Node As System.Xml.XmlNode In Xml.DocumentElement.ChildNodes
Dim Formatter As IDataFormatter = Nothing

Select Case Node.Attributes("Type").Value.ToUpper()
Case "RANK"
Formatter = New RankDataFormatter(Node, ReportCulture)
Case "LOOKUP"
Formatter = New LookupDataFormatter(Node)
End Select

If Not IsNothing(Formatter) Then
ReportFormatList.Add(Node.Attributes("Name").Value, Formatter)
End If
Next
End If
Return ReportFormatList
End Function

Public Function FormatData(ByVal FormatName As String, ByVal DataType As String, ByVal Value As String)
Dim FormatList As System.Collections.Generic.Dictionary(Of String, IDataFormatter) = GetReportFormatList()
If Not String.IsNullOrEmpty(FormatName) And Not IsNothing(FormatList) Then
If FormatList.ContainsKey(FormatName) Then
Return FormatList(FormatName).FormatData(Value)
End If
End If

If Not String.IsNullOrEmpty(DataType) Then
If DataType = "DateTime" Then
Return FormatDateTime("g", CDate(Value))
ElseIf DataType.StartsWith("UInt") Then
Return FormatNumber("G", Value)
End If
End If

Return Value
End Function

REM ----------------------------------------

Public Dim CurrentObjectList As String

Public Function InitList(ByRef List As String) As String
List = String.Empty
Return List
End Function

Public Function AddListItem(ByRef List As String, Item as String) As String
List = List + Item
Return List
End Function

Public Function GetObjectList(ByVal OptionsXml As String) As String()
Dim Xml As System.Xml.XmlDocument
Xml = New System.Xml.XmlDocument()
Xml.LoadXml(OptionsXml)

Dim Result As System.Collections.Generic.List(Of String)
Result = New System.Collections.Generic.List(Of String)
For Each ObjectNode As System.Xml.XmlNode In Xml.SelectNodes("/Value/Object")
If Not Result.Contains(ObjectNode.InnerText) Then
Result.Add(ObjectNode.InnerText)
End If
Next

Return Result.ToArray()
End Function
REM ------------------------------ custom aggregation code

Public Function FormatAggregatedTimeInterval(ByVal TimeValue As DateTime, ByVal AggType As String) As String
Dim FromDate As DateTime = TimeValue

Dim ToDate As DateTime

Dim ResultString As String = String.Empty


Select Case (AggType)
Case "Daily"
ToDate = FromDate.AddDays(1)

Case "Weekly"
ToDate = FromDate.AddDays(7)

Case "Monthly"
ToDate = FromDate.AddMonths(1)

Case "Quarterly"
ToDate = FromDate.AddMonths(3)

Case "Yearly"
ToDate = FromDate.AddYears(1)

End Select

ResultString = String.Format("{0} - {1}", FormatAggregatedTimeValue(FromDate, AggType), FormatAggregatedTimeValue(ToDate, AggType))

Return ResultString
End Function

Public Function FormatAggregatedTimeValue(ByVal TimeValue As DateTime, ByVal AggType As String) As String
Dim ResultString As String = String.Empty
Select Case (AggType)
Case "Daily"
ResultString = TimeValue.ToString("d",ReportCulture)

Case "Weekly"
ResultString = TimeValue.ToString("D",ReportCulture)

Case "Monthly"
ResultString = TimeValue.ToString("MMM yyyy",ReportCulture)

Case "Quarterly"
ResultString = TimeValue.ToString("MMM yyyy",ReportCulture)

Case "Yearly"
ResultString = TimeValue.ToString("yyyy",ReportCulture)

End Select

Return ResultString
End Function

Public Function AggregatedTimeValue(ByVal TimeValue As DateTime, ByVal AggType As String) As DateTime
Dim Result As DateTime
Select Case (AggType)
Case "Daily"
Result = New DateTime(TimeValue.Year, TimeValue.Month, TimeValue.Day, 0, 0, 0, DateTimeKind.Utc)
Case "Weekly"
Dim firstDayOfWeek As DayOfWeek
firstDayOfWeek = ReportCulture.DateTimeFormat.FirstDayOfWeek

Dim dayOfWeek As DayOfWeek
dayOfWeek = ReportCulture.Calendar.GetDayOfWeek(TimeValue)

Dim diff As Integer
diff = firstDayOfWeek - dayOfWeek
If diff &gt; 0 Then
diff = diff - 7
End If
Result = TimeValue.Date.AddDays(diff)
Case "Monthly"
Result = New DateTime(TimeValue.Year, TimeValue.Month, 1, 0, 0, 0, DateTimeKind.Utc)
Case "Quarterly"
Dim offset As Integer
Dim quarter As Integer
offset = (TimeValue.Month Mod 3)
quarter = (TimeValue.Month - offset) / 3
If (offset = 0) Then
quarter = quarter - 1
End If
Result = New DateTime(TimeValue.Year, (quarter * 3) + 1, 1, 0, 0, 0, DateTimeKind.Utc)
Case "Yearly"
Result = New DateTime(TimeValue.Year, 1, 1, 0, 0, 0, DateTimeKind.Utc)
End Select
Return Result
End Function

Public Function CalculateNumberOfChangesInPipeline(ByVal Value As Integer)
NumberOfChangesInPipeline = NumberOfChangesInPipeline + Value
Return NumberOfChangesInPipeline
End Function

Public Function CalculateNumberOfEmergencyChanges(ByVal Value As Integer)
NumberOfEmergencyChanges = NumberOfEmergencyChanges + Value
Return NumberOfEmergencyChanges
End Function

Public Function CalculateNumberOfFailedChanges(ByVal Value As Integer)
NumberOfFailedChanges = NumberOfFailedChanges + Value
Return NumberOfFailedChanges
End Function

Public Function CalculateNumberOfImplementedChanges(ByVal Value As Integer)
NumberOfImplementedChanges = NumberOfImplementedChanges + Value
Return NumberOfImplementedChanges
End Function

Public Function CalculateNumberOfChangesInPipelineOnChart(ByVal Value As Integer)
NumberOfChangesInPipelineOnChart = NumberOfChangesInPipelineOnChart + Value
Return NumberOfChangesInPipelineOnChart
End Function

Public Function CalculateNumberOfEmergencyChangesOnChart(ByVal Value As Integer)
NumberOfEmergencyChangesOnChart = NumberOfEmergencyChangesOnChart + Value
Return NumberOfEmergencyChangesOnChart
End Function

Public Function CalculateNumberOfChangesInPipelineOnChartEmergency(ByVal Value As Integer)
NumberOfChangesInPipelineOnChartEmergency = NumberOfChangesInPipelineOnChartEmergency + Value
Return NumberOfChangesInPipelineOnChartEmergency
End Function

Public Function CalculateNumberOfImplementedChangesOnChart(ByVal Value As Integer)
NumberOfImplementedChangesOnChart = NumberOfImplementedChangesOnChart + Value
Return NumberOfImplementedChangesOnChart
End Function

Public Function GetReportLocLanguageCodeTwoLetter() As String
Return ReportCulture.TwoLetterISOLanguageName
End Function
</Script></Code>
<Width>10.94376in</Width>
<Page>
<PageFooter>
<Height>0.40208in</Height>
<PrintOnFirstPage>true</PrintOnFirstPage>
<PrintOnLastPage>true</PrintOnLastPage>
<ReportItems>
<Textbox Name="textbox5">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Globals!PageNumber &amp; "/" &amp; Globals!TotalPages</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style /></Style>
</Paragraph>
</Paragraphs>
<rd:DefaultName>textbox5</rd:DefaultName>
<Top>0.05in</Top>
<Left>9.8in</Left>
<Height>0.24792in</Height>
<Width>0.94792in</Width>
<Style></Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="TimeZoneName">
<CanGrow>true</CanGrow>
<DataElementStyle>Element</DataElementStyle>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Parameters!TimeZoneName.Value</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<Color>DimGray</Color>
</Style>
</TextRun>
</TextRuns>
<Style /></Style>
</Paragraph>
</Paragraphs>
<rd:DefaultName>TimeZoneName</rd:DefaultName>
<Top>0.06945in</Top>
<Left>0.15208in</Left>
<Height>0.25in</Height>
<Width>9.51066in</Width>
<ZIndex>1</ZIndex>
<DataElementName>TimeZoneName</DataElementName>
<DataElementOutput>Output</DataElementOutput>
<Style></Style>
<Border>
<Style></Style>None</Style>
</Border>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</ReportItems>
<Style /></Style>
</PageFooter>
<PageHeight>8.5in</PageHeight>
<PageWidth>11in</PageWidth>
<InteractiveHeight>11in</InteractiveHeight>
<InteractiveWidth>8.5in</InteractiveWidth>
<LeftMargin>0.5in</LeftMargin>
<RightMargin>0.5in</RightMargin>
<TopMargin>0.5in</TopMargin>
<BottomMargin>0.5in</BottomMargin>
<Style /></Style>
</Page>
<Language>=Code.GetReportLocLanguageCodeTwoLetter()</Language>
<CodeModules>
<CodeModule>Microsoft.EnterpriseManagement.Reporting.Code, Version=7.0.5000.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35</CodeModule>
<CodeModule>System.Xml, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</CodeModule>
</CodeModules>
<ConsumeContainerWhitespace>true</ConsumeContainerWhitespace>
<rd:ReportID>20a1620b-e05d-4850-9c52-9c8dc5bc66d5</rd:ReportID>
<rd:ReportUnitType>Inch</rd:ReportUnitType>
</Report>