日付、管理グループ、およびバージョン別エージェント数

Microsoft.SystemCenter.OperationsManager.Reports.2007.AgentVersions.Report (Report)

このレポートは、指定した期間のエージェント アカウントに関する詳しい情報を示します。

Element properties:

AccessibilityPublic
VisibleTrue

Report Localization:

R.Title日付、管理グループ、およびバージョン別エージェント数
R.DescriptionTitleこのレポートの詳細な説明を表示するには、プラス記号をクリックしてください
R.Description選択した期間の日付、管理グループ、およびバージョン別エージェント数。
R.StartEndTimeLabel期間
R.StartEndTimeFormat{0} - {1}
R.ManagementGroupsLabel管理グループ
R.AggregationLabel集計
R.ChartGroupByMG管理グループ別エージェント数
R.ChartGroupByVerバージョン別エージェント数
R.EndAgtCntLbl最後のエージェント数
R.BenAgtCntLbl最初のエージェント数
R.PageFormat{0}/{1}
R.TimeZoneFormat{0}
R.ErrorData[開始] の値は [終了] の値より小さくなければなりません。
RT.Legend.ByDay毎日
RT.Legend.ByWeek毎週
RT.Legend.ByMonth毎月
RT.Legend.ByQuarter毎四半期
RT.Legend.ByYear毎年
RT.Chart.AltReportItemReporting Services のレポートで Dundas グラフ使用不可
RT.Chart.NoData***** データなし *****
RT.Chart.Countsカウント
RT.Chart.AgtCntByVerDay{0} ~ {1} の期間の傾向
RT.Chart.EndingAgtCntByVer{0} の内訳
RT.Chart.AgtCntByMGDay{0} ~ {1} の期間の傾向
RT.Chart.EndingAgtCntByMG{0} の内訳

Source Code:

<Report ID="Microsoft.SystemCenter.OperationsManager.Reports.2007.AgentVersions.Report" Accessibility="Public" Target="System!System.Entity" Visible="true">
<Dependencies>
<DataWarehouseScript>Microsoft.SystemCenter.OperationsManager.Reports.2007.Script.ReportAgentVersionByDateDataGet</DataWarehouseScript>
<DataWarehouseScript>Microsoft.SystemCenter.OperationsManager.Reports.2007.Script.ReportDisplayNameListGet</DataWarehouseScript>
<ReportParameterControl>ReportLibrary!Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.DatePicker</ReportParameterControl>
<ReportParameterControl>ReportLibrary!Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.CheckedListBox</ReportParameterControl>
<ReportParameterControl>ReportLibrary!Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.ComboBox</ReportParameterControl>
</Dependencies>
<ParameterBlock xmlns="http://schemas.microsoft.com/mom/reporting/2007/ReportParameterSettings" columns="2">
<Controls xmlns="http://schemas.microsoft.com/mom/reporting/2007/ReportParameterSettings">
<Control rowSpan="1" columnSpan="1" type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.DatePicker">
<ReportParameters>
<ReportParameter name="StartDate" binding="StartDate">
<Prompt>Microsoft.SystemCenter.DataWarehouse.Report.Library!Microsoft.SystemCenter.DataWarehouse.Report.ParameterPrompt.StartDateTime</Prompt>
</ReportParameter>
</ReportParameters>
</Control>
<Control rowSpan="2" columnSpan="1" type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.CheckedListBox">
<ReportParameters>
<ReportParameter name="ManagementGroupId" binding="ManagementGroupId">
<Prompt>Microsoft.SystemCenter.DataWarehouse.Report.Library!Microsoft.SystemCenter.DataWarehouse.Report.ParameterPrompt.ManagementGroup</Prompt>
</ReportParameter>
</ReportParameters>
</Control>
<Control rowSpan="1" columnSpan="1" type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.DatePicker">
<ReportParameters>
<ReportParameter name="EndDate" binding="EndDate">
<Prompt>Microsoft.SystemCenter.DataWarehouse.Report.Library!Microsoft.SystemCenter.DataWarehouse.Report.ParameterPrompt.EndDateTime</Prompt>
</ReportParameter>
</ReportParameters>
</Control>
<Control rowSpan="1" columnSpan="1" type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.ComboBox">
<ReportParameters>
<ReportParameter name="AggregationType">
<Prompt>Microsoft.SystemCenter.OperationsManager.Reports.2007!Microsoft.SystemCenter.OperationsManager.Reports.2007.ParameterPrompt.GroupingType</Prompt>
</ReportParameter>
</ReportParameters>
</Control>
</Controls>
</ParameterBlock>
<Definition>
<Report xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition">
<DataSources>
<DataSource Name="DataWarehouseMain">
<DataSourceReference>Data Warehouse Main</DataSourceReference>
<rd:DataSourceID>e4235c51-407f-4065-8519-a1e57374bc45</rd:DataSourceID>
<rd:SecurityType>None</rd:SecurityType>
</DataSource>
</DataSources>
<DataSets>
<DataSet Name="LT_Report_Query">
<Fields>
<Field Name="ValueXml">
<DataField>XML_F52E2B61-18A1-11d1-B105-00805F49916B</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="ValueName">
<Value>="LT"</Value>
</Field>
</Fields>
<Query>
<DataSourceName>DataWarehouseMain</DataSourceName>
<CommandType>StoredProcedure</CommandType>
<CommandText>ReportDisplayStringGet</CommandText>
<QueryParameters>
<QueryParameter Name="@ManagementGroupGuid">
<Value>=Code.GetCallingManagementGroupId()</Value>
</QueryParameter>
<QueryParameter Name="@ManagementPackSystemName">
<Value>Microsoft.SystemCenter.OperationsManager.Reports.2007</Value>
</QueryParameter>
<QueryParameter Name="@ReportSystemName">
<Value>Microsoft.SystemCenter.OperationsManager.Reports.2007.AgentVersions.Report</Value>
</QueryParameter>
<QueryParameter Name="@LanguageCode">
<Value>=Code.GetReportLocLanguageCode()</Value>
</QueryParameter>
<QueryParameter Name="@Scope">
<Value>R.%</Value>
</QueryParameter>
</QueryParameters>
</Query>
</DataSet>
<DataSet Name="LT_Table_Query">
<Fields>
<Field Name="ValueXml">
<DataField>XML_F52E2B61-18A1-11d1-B105-00805F49916B</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="ValueName">
<Value>="LT"</Value>
</Field>
</Fields>
<Query>
<DataSourceName>DataWarehouseMain</DataSourceName>
<CommandType>StoredProcedure</CommandType>
<CommandText>ReportDisplayStringGet</CommandText>
<QueryParameters>
<QueryParameter Name="@ManagementGroupGuid">
<Value>=Code.GetCallingManagementGroupId()</Value>
</QueryParameter>
<QueryParameter Name="@ManagementPackSystemName">
<Value>Microsoft.SystemCenter.OperationsManager.Reports.2007</Value>
</QueryParameter>
<QueryParameter Name="@ReportSystemName">
<Value>Microsoft.SystemCenter.OperationsManager.Reports.2007.AgentVersions.Report</Value>
</QueryParameter>
<QueryParameter Name="@LanguageCode">
<Value>=Code.GetReportLocLanguageCode()</Value>
</QueryParameter>
<QueryParameter Name="@Scope">
<Value>RT.%</Value>
</QueryParameter>
</QueryParameters>
</Query>
</DataSet>
<DataSet Name="NeighborManagementGroups">
<Fields>
<Field Name="ManagementGroupGuid">
<DataField>ManagementGroupGuid</DataField>
<rd:TypeName>System.Guid</rd:TypeName>
</Field>
<Field Name="ManagementGroupName">
<DataField>ManagementGroupName</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>DataWarehouseMain</DataSourceName>
<CommandText>
SELECT ManagementGroupGuid, ManagementGroupDefaultName AS ManagementGroupName
FROM vManagementGroup
</CommandText>
</Query>
</DataSet>
<DataSet Name="MPGroupsDisplayList">
<Fields>
<Field Name="DisplayName">
<DataField>DisplayName</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>DataWarehouseMain</DataSourceName>
<CommandType>StoredProcedure</CommandType>
<CommandText>Microsoft_SystemCenter_DataWarehouse_Report_Library_GetReportDisplayNameList</CommandText>
<QueryParameters>
<QueryParameter Name="@ObjectList">
<Value>=Code.BuildXmlValueList(Parameters!ManagementGroupId.Value)</Value>
</QueryParameter>
<QueryParameter Name="@ListType">
<Value>="1"</Value>
</QueryParameter>
<QueryParameter Name="@LanguageCode">
<Value>=Code.GetReportLocLanguageCode()</Value>
</QueryParameter>
</QueryParameters>
</Query>
</DataSet>
<DataSet Name="ReportDataCounts">
<Fields>
<Field Name="ChartDataSet">
<DataField>ChartDataSet</DataField>
</Field>
<Field Name="InitDate">
<DataField>InitDate</DataField>
</Field>
<Field Name="LastDate">
<DataField>LastDate</DataField>
</Field>
<Field Name="HeaderDataSet">
<DataField>HeaderDataSet</DataField>
</Field>
<Field Name="VersionDataSet">
<DataField>VersionDataSet</DataField>
</Field>
<Field Name="ManagementGroupDataSet">
<DataField>ManagementGroupDataSet</DataField>
</Field>
<Field Name="DateValue">
<DataField>DateValue</DataField>
</Field>
<Field Name="Version">
<DataField>Version</DataField>
</Field>
<Field Name="ManagementGroupRowId">
<DataField>ManagementGroupRowId</DataField>
</Field>
<Field Name="ManagementGroupDefaultName">
<DataField>ManagementGroupDefaultName</DataField>
</Field>
<Field Name="CountByDate">
<DataField>CountByDate</DataField>
</Field>
</Fields>
<Query>
<DataSourceName>DataWarehouseMain</DataSourceName>
<CommandType>StoredProcedure</CommandType>
<CommandText>Microsoft_SystemCenter_DataWarehouse_Report_AgentCountsByVerMGDateDataGet</CommandText>
<QueryParameters>
<QueryParameter Name="@StartDate">
<Value>=Code.GetReportDBStartDate()</Value>
</QueryParameter>
<QueryParameter Name="@EndDate">
<Value>=Code.GetReportDBEndDate()</Value>
</QueryParameter>
<QueryParameter Name="@AdjHours">
<Value>=0</Value>
</QueryParameter>
<QueryParameter Name="@MGPXML">
<Value>=Code.BuildXmlValueList(Parameters!ManagementGroupId.Value)</Value>
</QueryParameter>
<QueryParameter Name="@AggregationType">
<Value>=Parameters!AggregationType.Value</Value>
</QueryParameter>
</QueryParameters>
</Query>
</DataSet>
</DataSets>
<Body><Script>
<ReportItems>
<Chart Name="customReportItem1">
<ChartCategoryHierarchy>
<ChartMembers>
<ChartMember>
<Group Name="enterpriseManagementChartControl2_DCG_DataColumnGrouping3">
<GroupExpressions>
<GroupExpression>=Fields!ManagementGroupRowId.Value</GroupExpression>
</GroupExpressions>
</Group>
<Label>=Fields!ManagementGroupDefaultName.Value</Label>
</ChartMember>
</ChartMembers>
</ChartCategoryHierarchy>
<ChartSeriesHierarchy>
<ChartMembers>
<ChartMember>
<Label>Count By Date</Label>
</ChartMember>
</ChartMembers>
</ChartSeriesHierarchy>
<ChartData>
<ChartSeriesCollection>
<ChartSeries Name="CountByDate">
<ChartDataPoints>
<ChartDataPoint>
<ChartDataPointValues>
<X>=Fields!Version.Value</X>
<Y>=iif(Sum(Fields!CountByDate.Value)&gt;0,Sum(Fields!CountByDate.Value),"")</Y>
</ChartDataPointValues>
<ChartDataLabel>
<Style></Style>
<FontFamily>Microsoft Sans Serif</FontFamily>
<FontSize>8pt</FontSize>
</Style>
<UseValueAsLabel>true</UseValueAsLabel>
<Visible>true</Visible>
</ChartDataLabel>
<Style/>
<ChartMarker>
<Style/>
</ChartMarker>
<DataElementOutput>Output</DataElementOutput>
</ChartDataPoint>
</ChartDataPoints>
<Type>Shape</Type>
<Style/>
<ChartEmptyPoints>
<Style/>
<ChartMarker>
<Style/>
</ChartMarker>
<ChartDataLabel>
<Style/>
</ChartDataLabel>
</ChartEmptyPoints>
<ValueAxisName>Primary</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>
<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>
<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>
<FontSize>8pt</FontSize>
</Style>
<ChartAxisTitle>
<Caption>Axis Title</Caption>
<Style></Style>
<FontSize>8pt</FontSize>
</Style>
</ChartAxisTitle>
<ChartMajorGridLines>
<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>
<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>
<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>
</ChartValueAxes>
<Style></Style>
<BackgroundGradientType>None</BackgroundGradientType>
</Style>
</ChartArea>
</ChartAreas>
<Palette>BrightPastel</Palette>
<ChartBorderSkin>
<Style></Style>
<BackgroundColor>Gray</BackgroundColor>
<BackgroundGradientType>None</BackgroundGradientType>
<Color>White</Color>
</Style>
</ChartBorderSkin>
<ChartNoDataMessage Name="NoDataMessage">
<Caption>=Code.GetLocTable("LT_Table").GetString("RT.Chart.NoData", "[No Data]")</Caption>
<Style></Style>
<BackgroundGradientType>None</BackgroundGradientType>
<TextAlign>General</TextAlign>
<VerticalAlign>Top</VerticalAlign>
</Style>
</ChartNoDataMessage>
<DataSetName>ReportDataCounts</DataSetName>
<Filters>
<Filter>
<FilterExpression>=Fields!ChartDataSet.Value.ToString()</FilterExpression>
<Operator>Equal</Operator>
<FilterValues>
<FilterValue>="1"</FilterValue>
</FilterValues>
</Filter>
<Filter>
<FilterExpression>=Fields!HeaderDataSet.Value.ToString()</FilterExpression>
<Operator>Equal</Operator>
<FilterValues>
<FilterValue>="0"</FilterValue>
</FilterValues>
</Filter>
<Filter>
<FilterExpression>=Fields!ManagementGroupDataSet.Value.ToString()</FilterExpression>
<Operator>Equal</Operator>
<FilterValues>
<FilterValue>="1"</FilterValue>
</FilterValues>
</Filter>
<Filter>
<FilterExpression>=Fields!VersionDataSet.Value.ToString()</FilterExpression>
<Operator>Equal</Operator>
<FilterValues>
<FilterValue>="0"</FilterValue>
</FilterValues>
</Filter>
<Filter>
<FilterExpression>=Fields!LastDate.Value.ToString()</FilterExpression>
<Operator>Equal</Operator>
<FilterValues>
<FilterValue>="1"</FilterValue>
</FilterValues>
</Filter>
</Filters>
<Top>8.15in</Top>
<Left>6.2in</Left>
<Height>3.3in</Height>
<Width>3.55in</Width>
<Visibility>
<Hidden>=IIf(Parameters!StartDate.Value &gt; Parameters!EndDate.Value, True, IIf(RowNumber("MPGroupsDisplayList")=1,True,False))</Hidden>
</Visibility>
<Style></Style>
<Border>
<Color>LightGrey</Color>
<Style></Style>None</Style>
</Border>
<BackgroundColor>White</BackgroundColor>
<BackgroundGradientType>None</BackgroundGradientType>
</Style>
</Chart>
<Image Name="parameterBottomImage">
<Source>External</Source>
<Value>../gradient_portrait.gif</Value>
<Sizing>Fit</Sizing>
<Top>3.34528in</Top>
<Left>0.31333in</Left>
<Height>0.05in</Height>
<Width>9.25in</Width>
<ZIndex>1</ZIndex>
<Style/>
</Image>
<Chart Name="customReportItem2">
<ChartCategoryHierarchy>
<ChartMembers>
<ChartMember>
<Group Name="enterpriseManagementChartControl2_DCG_DataColumnGrouping2">
<GroupExpressions>
<GroupExpression>=Fields!DateValue.Value</GroupExpression>
</GroupExpressions>
</Group>
<Label>=Fields!DateValue.Value</Label>
</ChartMember>
</ChartMembers>
</ChartCategoryHierarchy>
<ChartSeriesHierarchy>
<ChartMembers>
<ChartMember>
<Group Name="enterpriseManagementChartControl2_DRG_DataRowGrouping2">
<GroupExpressions>
<GroupExpression>=Fields!ManagementGroupRowId.Value</GroupExpression>
</GroupExpressions>
</Group>
<Label>=Fields!ManagementGroupDefaultName.Value</Label>
</ChartMember>
</ChartMembers>
</ChartSeriesHierarchy>
<ChartData>
<ChartSeriesCollection>
<ChartSeries Name="CountByDate">
<ChartDataPoints>
<ChartDataPoint>
<ChartDataPointValues>
<Y>=Sum(Fields!CountByDate.Value)</Y>
</ChartDataPointValues>
<ChartDataLabel>
<Style/>
</ChartDataLabel>
<Style></Style>
<Border>
<Color>#00e6f2fc</Color>
</Border>
<BackgroundGradientType>None</BackgroundGradientType>
<BackgroundGradientEndColor>White</BackgroundGradientEndColor>
</Style>
<ChartMarker>
<Style/>
</ChartMarker>
<DataElementOutput>Output</DataElementOutput>
</ChartDataPoint>
</ChartDataPoints>
<Type>Area</Type>
<Subtype>Stacked</Subtype>
<Style/>
<ChartEmptyPoints>
<Style/>
<ChartMarker>
<Style/>
</ChartMarker>
<ChartDataLabel>
<Style/>
</ChartDataLabel>
</ChartEmptyPoints>
<ValueAxisName>Primary</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>
<FontSize>8pt</FontSize>
<Format>d</Format>
</Style>
<ChartAxisTitle>
<Caption/>
<Style></Style>
<FontSize>8pt</FontSize>
</Style>
</ChartAxisTitle>
<Margin>False</Margin>
<Interval>1</Interval>
<ChartMajorGridLines>
<Enabled>True</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>DarkGray</Color>
</Border>
</Style>
<Interval>1</Interval>
<IntervalType>Auto</IntervalType>
</ChartMajorTickMarks>
<ChartMinorTickMarks>
<Style></Style>
<Border>
<Color>DarkGray</Color>
</Border>
</Style>
<Length>0.5</Length>
</ChartMinorTickMarks>
<CrossAt>NaN</CrossAt>
<InterlacedColor>Silver</InterlacedColor>
<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>
<FontSize>8pt</FontSize>
<Format>0;(0)</Format>
</Style>
<ChartAxisTitle>
<Caption>=Code.GetLocTable("LT_Table").GetString("RT.Chart.Counts", "[Counts]")</Caption>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8.25pt</FontSize>
<FontWeight>Bold</FontWeight>
</Style>
</ChartAxisTitle>
<Interval>1</Interval>
<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>
<Interval>1</Interval>
</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>
<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>
</ChartValueAxes>
<Style></Style>
<Border>
<Color>#f050418c</Color>
</Border>
<BackgroundColor>White</BackgroundColor>
<BackgroundGradientType>TopBottom</BackgroundGradientType>
<BackgroundGradientEndColor>Gainsboro</BackgroundGradientEndColor>
</Style>
</ChartArea>
</ChartAreas>
<ChartLegends>
<ChartLegend Name="Default">
<Style></Style>
<Border>
<Color>#50108cf0</Color>
<Style></Style>Solid</Style>
<Width>0.5pt</Width>
</Border>
<BackgroundColor>#e6f2fc</BackgroundColor>
<BackgroundGradientType>TopBottom</BackgroundGradientType>
<FontFamily>Tahoma</FontFamily>
<FontSize>9.75pt</FontSize>
</Style>
<Position>RightCenter</Position>
<DockOutsideChartArea>true</DockOutsideChartArea>
<ChartLegendTitle>
<Caption/>
<Style></Style>
<FontSize>8pt</FontSize>
<FontWeight>Bold</FontWeight>
<TextAlign>Center</TextAlign>
</Style>
</ChartLegendTitle>
<AutoFitTextDisabled>true</AutoFitTextDisabled>
<HeaderSeparatorColor>Black</HeaderSeparatorColor>
<ColumnSeparatorColor>Black</ColumnSeparatorColor>
</ChartLegend>
</ChartLegends>
<Palette>BrightPastel</Palette>
<ChartBorderSkin>
<Style></Style>
<BackgroundColor>Gray</BackgroundColor>
<BackgroundGradientType>None</BackgroundGradientType>
<Color>White</Color>
</Style>
</ChartBorderSkin>
<ChartNoDataMessage Name="NoDataMessage">
<Caption>=Code.GetLocTable("LT_Table").GetString("RT.Chart.NoData", "[No Data]")</Caption>
<Style></Style>
<BackgroundGradientType>None</BackgroundGradientType>
<TextAlign>General</TextAlign>
<VerticalAlign>Top</VerticalAlign>
</Style>
</ChartNoDataMessage>
<DataSetName>ReportDataCounts</DataSetName>
<Filters>
<Filter>
<FilterExpression>=Fields!ChartDataSet.Value.ToString()</FilterExpression>
<Operator>Equal</Operator>
<FilterValues>
<FilterValue>="0"</FilterValue>
</FilterValues>
</Filter>
<Filter>
<FilterExpression>=Fields!HeaderDataSet.Value.ToString()</FilterExpression>
<Operator>Equal</Operator>
<FilterValues>
<FilterValue>="0"</FilterValue>
</FilterValues>
</Filter>
<Filter>
<FilterExpression>=Fields!ManagementGroupDataSet.Value.ToString()</FilterExpression>
<Operator>Equal</Operator>
<FilterValues>
<FilterValue>="1"</FilterValue>
</FilterValues>
</Filter>
<Filter>
<FilterExpression>=Fields!VersionDataSet.Value.ToString()</FilterExpression>
<Operator>Equal</Operator>
<FilterValues>
<FilterValue>="0"</FilterValue>
</FilterValues>
</Filter>
<Filter>
<FilterExpression>=Fields!LastDate.Value.ToString()</FilterExpression>
<Operator>Equal</Operator>
<FilterValues>
<FilterValue>="0"</FilterValue>
</FilterValues>
</Filter>
</Filters>
<Top>8.15in</Top>
<Left>0.3in</Left>
<Height>3.3in</Height>
<Width>5.75in</Width>
<ZIndex>2</ZIndex>
<Visibility>
<Hidden>=IIf(Parameters!StartDate.Value &gt; Parameters!EndDate.Value, True, IIf(RowNumber("MPGroupsDisplayList")=1,True,False))</Hidden>
</Visibility>
<Style></Style>
<Border>
<Color>LightGrey</Color>
<Style></Style>None</Style>
</Border>
<BackgroundColor>White</BackgroundColor>
<BackgroundGradientType>None</BackgroundGradientType>
</Style>
</Chart>
<Rectangle Name="list1">
<ReportItems>
<Image Name="banner_image">
<Source>External</Source>
<Value>../banner_portrait.jpg</Value>
<Sizing>Fit</Sizing>
<Top>0.1in</Top>
<Left>0.15in</Left>
<Height>0.64583in</Height>
<Width>9.25in</Width>
<Style/>
</Image>
<Rectangle Name="RptExtdHeader">
<ReportItems>
<Textbox Name="reportDescription">
<CanGrow>true</CanGrow>
<CanShrink>true</CanShrink>
<DataElementStyle>Element</DataElementStyle>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Code.GetLocTable("LT_Report").GetString("R.Description", "[Agent counts by date, version and MG in a chosen timeframe.]")</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style/>
</Paragraph>
</Paragraphs>
<rd:DefaultName>textbox4</rd:DefaultName>
<Top>0.075in</Top>
<Left>0.2in</Left>
<Height>0.2in</Height>
<Width>7.8in</Width>
<DataElementName>StartDate</DataElementName>
<DataElementOutput>Output</DataElementOutput>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</ReportItems>
<Top>1.3in</Top>
<Left>0.15in</Left>
<Height>0.34167in</Height>
<Width>9.25in</Width>
<ZIndex>1</ZIndex>
<Visibility>
<Hidden>true</Hidden>
<ToggleItem>reportDescriptionTitle</ToggleItem>
</Visibility>
<Style></Style>
<Border/>
<BackgroundColor>Gainsboro</BackgroundColor>
</Style>
</Rectangle>
<Rectangle Name="RptSpacerHeader">
<Top>1.68333in</Top>
<Left>0.15in</Left>
<Height>0.05in</Height>
<Width>9.25in</Width>
<ZIndex>2</ZIndex>
<Style></Style>
<Border>
<Color>DarkGray</Color>
<Style></Style>Solid</Style>
</Border>
<BackgroundColor>Gainsboro</BackgroundColor>
</Style>
</Rectangle>
<Rectangle Name="RptHeader">
<ReportItems>
<Textbox Name="textbox4">
<CanGrow>true</CanGrow>
<CanShrink>true</CanShrink>
<DataElementStyle>Element</DataElementStyle>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Code.GetLocTable("LT_Report").GetString("R.Title", "[Agent Counts By Date, MG and Version]")</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>11pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style/>
</Paragraph>
</Paragraphs>
<rd:DefaultName>textbox4</rd:DefaultName>
<Top>0.05in</Top>
<Left>0.2in</Left>
<Height>0.25in</Height>
<Width>7.8in</Width>
<DataElementName>Title</DataElementName>
<DataElementOutput>Output</DataElementOutput>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>11pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="reportDescriptionTitle">
<CanGrow>true</CanGrow>
<CanShrink>true</CanShrink>
<DataElementStyle>Element</DataElementStyle>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Code.GetLocTable("LT_Report").GetString("R.DescriptionTitle", "[Click on plus sign to see a full description for this report]")</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<VerticalAlign>Middle</VerticalAlign>
<Color>DimGray</Color>
</Style>
</TextRun>
</TextRuns>
<Style/>
</Paragraph>
</Paragraphs>
<rd:DefaultName>textbox4</rd:DefaultName>
<Top>0.3in</Top>
<Height>0.2in</Height>
<Width>8in</Width>
<ZIndex>1</ZIndex>
<DataElementName>StartDate</DataElementName>
<DataElementOutput>Output</DataElementOutput>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<VerticalAlign>Middle</VerticalAlign>
<Color>DimGray</Color>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</ReportItems>
<Top>0.75in</Top>
<Left>0.15in</Left>
<Height>0.55in</Height>
<Width>9.25in</Width>
<ZIndex>3</ZIndex>
<Style></Style>
<BackgroundColor>Gainsboro</BackgroundColor>
</Style>
</Rectangle>
<Rectangle Name="Rectangle1">
<ReportItems>
<Textbox Name="TxtHeaderParamTimeSpanLabel">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Code.GetLocTable("LT_Report").GetString("R.StartEndTimeLabel", "[Report Start/End Time Label]")</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style/>
</Paragraph>
</Paragraphs>
<Top>0.00778in</Top>
<Left>0.01333in</Left>
<Height>0.2in</Height>
<Width>1.6in</Width>
<Style></Style>
<Border>
<Style></Style>None</Style>
</Border>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="TxtHeaderParamAggregationLabel">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Code.GetLocTable("LT_Report").GetString("R.AggregationLabel", "[Aggregation]")</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style/>
</Paragraph>
</Paragraphs>
<Top>0.27722in</Top>
<Left>0.01333in</Left>
<Height>0.2in</Height>
<Width>1.6in</Width>
<ZIndex>1</ZIndex>
<Style></Style>
<Border>
<Style></Style>None</Style>
</Border>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="TxtHeaderBeginningAgentCountLabel">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Code.GetLocTable("LT_Report").GetString("R.BenAgtCntLbl", "[Beginning Agent Count]")</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style/>
</Paragraph>
</Paragraphs>
<Top>0.525in</Top>
<Left>0.01333in</Left>
<Height>0.2in</Height>
<Width>1.6in</Width>
<ZIndex>2</ZIndex>
<Style></Style>
<Border>
<Style></Style>None</Style>
</Border>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="TxtHeaderBeginningAgentCountLabel2">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Code.GetLocTable("LT_Report").GetString("R.EndAgtCntLbl", "[Ending Agent Count]")</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style/>
</Paragraph>
</Paragraphs>
<Top>0.78056in</Top>
<Left>0.01333in</Left>
<Height>0.2in</Height>
<Width>1.6in</Width>
<ZIndex>3</ZIndex>
<Style></Style>
<Border>
<Style></Style>None</Style>
</Border>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Tablix Name="TableHeaderMgs">
<TablixBody>
<TablixColumns>
<TablixColumn>
<Width>6.23667in</Width>
</TablixColumn>
</TablixColumns>
<TablixRows>
<TablixRow>
<Height>0.2in</Height>
<TablixCells>
<TablixCell>
<CellContents>
<Textbox Name="textbox1">
<CanGrow>true</CanGrow>
<CanShrink>true</CanShrink>
<DataElementStyle>Element</DataElementStyle>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Fields!DisplayName.Value</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style/>
</Paragraph>
</Paragraphs>
<rd:DefaultName>textbox4</rd:DefaultName>
<DataElementName>MGNames</DataElementName>
<DataElementOutput>Output</DataElementOutput>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
</TablixCells>
</TablixRow>
</TablixRows>
</TablixBody>
<TablixColumnHierarchy>
<TablixMembers>
<TablixMember/>
</TablixMembers>
</TablixColumnHierarchy>
<TablixRowHierarchy>
<TablixMembers>
<TablixMember>
<KeepTogether>true</KeepTogether>
</TablixMember>
</TablixMembers>
</TablixRowHierarchy>
<DataSetName>MPGroupsDisplayList</DataSetName>
<Top>1.05in</Top>
<Left>1.85278in</Left>
<Height>0.2in</Height>
<Width>6.23667in</Width>
<ZIndex>4</ZIndex>
<DataElementName>MPGroupsTable</DataElementName>
<DataElementOutput>Output</DataElementOutput>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</Tablix>
<Textbox Name="ManagementGroupTitle">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Code.GetLocTable("LT_Report").GetString("R.ManagementGroupsLabel", "[Report Management Groups Label]")</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style/>
</Paragraph>
</Paragraphs>
<Top>1.05in</Top>
<Left>0.01333in</Left>
<Height>0.2in</Height>
<Width>1.6in</Width>
<ZIndex>5</ZIndex>
<Style></Style>
<Border>
<Style></Style>None</Style>
</Border>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="TxtHeaderParamTimeSpanDiv">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=":"</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style/>
</Paragraph>
</Paragraphs>
<Top>0.01084in</Top>
<Left>1.69167in</Left>
<Height>0.2in</Height>
<Width>0.08333in</Width>
<ZIndex>6</ZIndex>
<Style></Style>
<Border>
<Style></Style>None</Style>
</Border>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="TxtHeaderParamAggregationDiv">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=":"</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style/>
</Paragraph>
</Paragraphs>
<Top>0.27722in</Top>
<Left>1.69167in</Left>
<Height>0.2in</Height>
<Width>0.08333in</Width>
<ZIndex>7</ZIndex>
<Style></Style>
<Border>
<Style></Style>None</Style>
</Border>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="TxtHeaderBeginningAgentCountDiv">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=":"</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style/>
</Paragraph>
</Paragraphs>
<Top>0.525in</Top>
<Left>1.69167in</Left>
<Height>0.2in</Height>
<Width>0.08333in</Width>
<ZIndex>8</ZIndex>
<Style></Style>
<Border>
<Style></Style>None</Style>
</Border>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="TxtHeaderEndingAgentCountDiv">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=":"</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style/>
</Paragraph>
</Paragraphs>
<Top>0.78056in</Top>
<Left>1.69167in</Left>
<Height>0.2in</Height>
<Width>0.08333in</Width>
<ZIndex>9</ZIndex>
<Style></Style>
<Border>
<Style></Style>None</Style>
</Border>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="TxtHeaderParamTimeSpanDiv5">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=":"</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style/>
</Paragraph>
</Paragraphs>
<Top>1.05in</Top>
<Left>1.69167in</Left>
<Height>0.2in</Height>
<Width>0.08333in</Width>
<ZIndex>10</ZIndex>
<Style></Style>
<Border>
<Style></Style>None</Style>
</Border>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="TxtHeaderParamTimeSpanValue">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>
=Code.FormatString(
Code.GetLocTable("LT_Report").GetString("R.StartEndTimeFormat", "{0} - {1}"),
Code.FormatDateTime("d", Code.GetReportDBStartDate()),
Code.FormatDateTime("d", Code.GetReportDBEndDate())
)
</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style/>
</Paragraph>
</Paragraphs>
<Top>0.00778in</Top>
<Left>1.85556in</Left>
<Height>0.2in</Height>
<Width>6.23389in</Width>
<ZIndex>11</ZIndex>
<Style></Style>
<Border>
<Style></Style>None</Style>
</Border>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="TxtHeaderParamAggregationValue">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Parameters!AggregationType.Label</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style/>
</Paragraph>
</Paragraphs>
<Top>0.285in</Top>
<Left>1.85556in</Left>
<Height>0.2in</Height>
<Width>6.23389in</Width>
<ZIndex>12</ZIndex>
<Style></Style>
<Border>
<Style></Style>None</Style>
</Border>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Tablix Name="TxtHeaderBeginningAgentCountValue">
<TablixBody>
<TablixColumns>
<TablixColumn>
<Width>1.17834in</Width>
</TablixColumn>
</TablixColumns>
<TablixRows>
<TablixRow>
<Height>0.2in</Height>
<TablixCells>
<TablixCell>
<CellContents>
<Textbox Name="textbox2">
<CanGrow>true</CanGrow>
<CanShrink>true</CanShrink>
<DataElementStyle>Element</DataElementStyle>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Sum(Fields!CountByDate.Value)</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style></Style>
<TextAlign>Left</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<rd:DefaultName>textbox4</rd:DefaultName>
<DataElementName>MGNames</DataElementName>
<DataElementOutput>Output</DataElementOutput>
<Style></Style>
<Border/>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
</TablixCells>
</TablixRow>
</TablixRows>
</TablixBody>
<TablixColumnHierarchy>
<TablixMembers>
<TablixMember/>
</TablixMembers>
</TablixColumnHierarchy>
<TablixRowHierarchy>
<TablixMembers>
<TablixMember>
<KeepTogether>true</KeepTogether>
</TablixMember>
</TablixMembers>
</TablixRowHierarchy>
<DataSetName>ReportDataCounts</DataSetName>
<Filters>
<Filter>
<FilterExpression>=Fields!HeaderDataSet.Value.ToString()</FilterExpression>
<Operator>Equal</Operator>
<FilterValues>
<FilterValue>="1"</FilterValue>
</FilterValues>
</Filter>
<Filter>
<FilterExpression>=Fields!InitDate.Value.ToString()</FilterExpression>
<Operator>Equal</Operator>
<FilterValues>
<FilterValue>="1"</FilterValue>
</FilterValues>
</Filter>
</Filters>
<Top>0.5525in</Top>
<Left>1.88166in</Left>
<Height>0.2in</Height>
<Width>1.17834in</Width>
<ZIndex>13</ZIndex>
<DataElementName>MPGroupsTable</DataElementName>
<DataElementOutput>Output</DataElementOutput>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</Tablix>
<Tablix Name="TxtHeaderEndingAgentCountValue">
<TablixBody>
<TablixColumns>
<TablixColumn>
<Width>1.17834in</Width>
</TablixColumn>
</TablixColumns>
<TablixRows>
<TablixRow>
<Height>0.2in</Height>
<TablixCells>
<TablixCell>
<CellContents>
<Textbox Name="textbox3">
<CanGrow>true</CanGrow>
<CanShrink>true</CanShrink>
<DataElementStyle>Element</DataElementStyle>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Sum(Fields!CountByDate.Value)</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style></Style>
<TextAlign>Left</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<rd:DefaultName>textbox4</rd:DefaultName>
<DataElementName>MGNames</DataElementName>
<DataElementOutput>Output</DataElementOutput>
<Style></Style>
<Border/>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
</TablixCells>
</TablixRow>
</TablixRows>
</TablixBody>
<TablixColumnHierarchy>
<TablixMembers>
<TablixMember/>
</TablixMembers>
</TablixColumnHierarchy>
<TablixRowHierarchy>
<TablixMembers>
<TablixMember>
<KeepTogether>true</KeepTogether>
</TablixMember>
</TablixMembers>
</TablixRowHierarchy>
<DataSetName>ReportDataCounts</DataSetName>
<Filters>
<Filter>
<FilterExpression>=Fields!HeaderDataSet.Value.ToString()</FilterExpression>
<Operator>Equal</Operator>
<FilterValues>
<FilterValue>="1"</FilterValue>
</FilterValues>
</Filter>
<Filter>
<FilterExpression>=Fields!LastDate.Value.ToString()</FilterExpression>
<Operator>Equal</Operator>
<FilterValues>
<FilterValue>="1"</FilterValue>
</FilterValues>
</Filter>
</Filters>
<Top>0.8025in</Top>
<Left>1.88166in</Left>
<Height>0.2in</Height>
<Width>1.17834in</Width>
<ZIndex>14</ZIndex>
<DataElementName>MPGroupsTable</DataElementName>
<DataElementOutput>Output</DataElementOutput>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</Tablix>
</ReportItems>
<KeepTogether>true</KeepTogether>
<Top>1.84778in</Top>
<Left>0.16333in</Left>
<Height>1.305in</Height>
<Width>9.25in</Width>
<ZIndex>4</ZIndex>
<Style></Style>
<Border>
<Style></Style>None</Style>
</Border>
</Style>
</Rectangle>
</ReportItems>
<DataElementOutput>Output</DataElementOutput>
<Top>0.08139in</Top>
<Left>0.15in</Left>
<Height>3.19445in</Height>
<Width>9.6in</Width>
<ZIndex>3</ZIndex>
<Style/>
</Rectangle>
<Chart Name="enterpriseManagementChartControl1">
<ChartCategoryHierarchy>
<ChartMembers>
<ChartMember>
<Group Name="enterpriseManagementChartControl1_DCG_DataColumnGrouping1">
<GroupExpressions>
<GroupExpression>=Fields!DateValue.Value</GroupExpression>
</GroupExpressions>
</Group>
<Label>=Fields!DateValue.Value</Label>
</ChartMember>
</ChartMembers>
</ChartCategoryHierarchy>
<ChartSeriesHierarchy>
<ChartMembers>
<ChartMember>
<Group Name="enterpriseManagementChartControl1_DRG_DataRowGrouping1">
<GroupExpressions>
<GroupExpression>=Fields!Version.Value</GroupExpression>
</GroupExpressions>
</Group>
<Label>=Fields!Version.Value</Label>
</ChartMember>
</ChartMembers>
</ChartSeriesHierarchy>
<ChartData>
<ChartSeriesCollection>
<ChartSeries Name="CountByDate">
<ChartDataPoints>
<ChartDataPoint>
<ChartDataPointValues>
<Y>=Sum(Fields!CountByDate.Value)</Y>
</ChartDataPointValues>
<ChartDataLabel>
<Style/>
</ChartDataLabel>
<Style></Style>
<Border>
<Color>#00e6f2fc</Color>
</Border>
<BackgroundGradientType>None</BackgroundGradientType>
<BackgroundGradientEndColor>White</BackgroundGradientEndColor>
</Style>
<ChartMarker>
<Style/>
</ChartMarker>
<DataElementOutput>Output</DataElementOutput>
</ChartDataPoint>
</ChartDataPoints>
<Type>Area</Type>
<Subtype>Stacked</Subtype>
<Style/>
<ChartEmptyPoints>
<Style/>
<ChartMarker>
<Style/>
</ChartMarker>
<ChartDataLabel>
<Style/>
</ChartDataLabel>
</ChartEmptyPoints>
<ValueAxisName>Primary</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>
<FontSize>8pt</FontSize>
<Format>d</Format>
</Style>
<ChartAxisTitle>
<Caption/>
<Style></Style>
<FontSize>8pt</FontSize>
</Style>
</ChartAxisTitle>
<Margin>False</Margin>
<Interval>1</Interval>
<ChartMajorGridLines>
<Enabled>True</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>DarkGray</Color>
</Border>
</Style>
<Interval>1</Interval>
<IntervalType>Auto</IntervalType>
</ChartMajorTickMarks>
<ChartMinorTickMarks>
<Style></Style>
<Border>
<Color>DarkGray</Color>
</Border>
</Style>
<Length>0.5</Length>
</ChartMinorTickMarks>
<CrossAt>NaN</CrossAt>
<InterlacedColor>Silver</InterlacedColor>
<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>
<FontSize>8pt</FontSize>
<Format>0;(0)</Format>
</Style>
<ChartAxisTitle>
<Caption>=Code.GetLocTable("LT_Table").GetString("RT.Chart.Counts", "[Counts]")</Caption>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8.25pt</FontSize>
<FontWeight>Bold</FontWeight>
</Style>
</ChartAxisTitle>
<Interval>1</Interval>
<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>
<Interval>1</Interval>
</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>
<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>
</ChartValueAxes>
<Style></Style>
<Border>
<Color>#f050418c</Color>
</Border>
<BackgroundColor>White</BackgroundColor>
<BackgroundGradientType>TopBottom</BackgroundGradientType>
<BackgroundGradientEndColor>Gainsboro</BackgroundGradientEndColor>
</Style>
</ChartArea>
</ChartAreas>
<ChartLegends>
<ChartLegend Name="Default">
<Style></Style>
<Border>
<Color>#50108cf0</Color>
<Style></Style>Solid</Style>
<Width>0.5pt</Width>
</Border>
<BackgroundColor>#e6f2fc</BackgroundColor>
<BackgroundGradientType>TopBottom</BackgroundGradientType>
<FontFamily>Tahoma</FontFamily>
<FontSize>9.75pt</FontSize>
</Style>
<Position>RightCenter</Position>
<DockOutsideChartArea>true</DockOutsideChartArea>
<ChartLegendTitle>
<Caption/>
<Style></Style>
<FontSize>8pt</FontSize>
<FontWeight>Bold</FontWeight>
<TextAlign>Center</TextAlign>
</Style>
</ChartLegendTitle>
<AutoFitTextDisabled>true</AutoFitTextDisabled>
<HeaderSeparatorColor>Black</HeaderSeparatorColor>
<ColumnSeparatorColor>Black</ColumnSeparatorColor>
</ChartLegend>
</ChartLegends>
<Palette>BrightPastel</Palette>
<ChartBorderSkin>
<Style></Style>
<BackgroundColor>Gray</BackgroundColor>
<BackgroundGradientType>None</BackgroundGradientType>
<Color>White</Color>
</Style>
</ChartBorderSkin>
<ChartNoDataMessage Name="NoDataMessage">
<Caption>=Code.GetLocTable("LT_Table").GetString("RT.Chart.NoData", "[No Data]")</Caption>
<Style></Style>
<BackgroundGradientType>None</BackgroundGradientType>
<TextAlign>General</TextAlign>
<VerticalAlign>Top</VerticalAlign>
</Style>
</ChartNoDataMessage>
<DataSetName>ReportDataCounts</DataSetName>
<Filters>
<Filter>
<FilterExpression>=Fields!ChartDataSet.Value.ToString()</FilterExpression>
<Operator>Equal</Operator>
<FilterValues>
<FilterValue>="0"</FilterValue>
</FilterValues>
</Filter>
<Filter>
<FilterExpression>=Fields!HeaderDataSet.Value.ToString()</FilterExpression>
<Operator>Equal</Operator>
<FilterValues>
<FilterValue>="0"</FilterValue>
</FilterValues>
</Filter>
<Filter>
<FilterExpression>=Fields!ManagementGroupDataSet.Value.ToString()</FilterExpression>
<Operator>Equal</Operator>
<FilterValues>
<FilterValue>="0"</FilterValue>
</FilterValues>
</Filter>
<Filter>
<FilterExpression>=Fields!VersionDataSet.Value.ToString()</FilterExpression>
<Operator>Equal</Operator>
<FilterValues>
<FilterValue>="1"</FilterValue>
</FilterValues>
</Filter>
<Filter>
<FilterExpression>=Fields!LastDate.Value.ToString()</FilterExpression>
<Operator>Equal</Operator>
<FilterValues>
<FilterValue>="0"</FilterValue>
</FilterValues>
</Filter>
</Filters>
<Top>4.225in</Top>
<Left>0.3in</Left>
<Height>3.3in</Height>
<Width>5.75in</Width>
<ZIndex>4</ZIndex>
<Visibility>
<Hidden>=IIf(Parameters!StartDate.Value &gt; Parameters!EndDate.Value, True, False)</Hidden>
</Visibility>
<Style></Style>
<Border>
<Color>LightGrey</Color>
<Style></Style>None</Style>
</Border>
<BackgroundColor>White</BackgroundColor>
<BackgroundGradientType>None</BackgroundGradientType>
</Style>
</Chart>
<Chart Name="enterpriseManagementChartControl2">
<ChartCategoryHierarchy>
<ChartMembers>
<ChartMember>
<Group Name="enterpriseManagementChartControl2_DCG_DataColumnGrouping1">
<GroupExpressions>
<GroupExpression>=Fields!Version.Value</GroupExpression>
</GroupExpressions>
</Group>
<Label>=Fields!Version.Value</Label>
</ChartMember>
</ChartMembers>
</ChartCategoryHierarchy>
<ChartSeriesHierarchy>
<ChartMembers>
<ChartMember>
<Label>Count By Date</Label>
</ChartMember>
</ChartMembers>
</ChartSeriesHierarchy>
<ChartData>
<ChartSeriesCollection>
<ChartSeries Name="CountByDate">
<ChartDataPoints>
<ChartDataPoint>
<ChartDataPointValues>
<X>=Fields!Version.Value</X>
<Y>=iif(Sum(Fields!CountByDate.Value)&gt;0,Sum(Fields!CountByDate.Value),"")</Y>
</ChartDataPointValues>
<ChartDataLabel>
<Style></Style>
<FontFamily>Microsoft Sans Serif</FontFamily>
<FontSize>8pt</FontSize>
</Style>
<UseValueAsLabel>true</UseValueAsLabel>
<Visible>true</Visible>
</ChartDataLabel>
<Style/>
<ChartMarker>
<Style/>
</ChartMarker>
<DataElementOutput>Output</DataElementOutput>
</ChartDataPoint>
</ChartDataPoints>
<Type>Shape</Type>
<Style/>
<ChartEmptyPoints>
<Style/>
<ChartMarker>
<Style/>
</ChartMarker>
<ChartDataLabel>
<Style/>
</ChartDataLabel>
</ChartEmptyPoints>
<ValueAxisName>Primary</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>
<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>
<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>
<FontSize>8pt</FontSize>
</Style>
<ChartAxisTitle>
<Caption>Axis Title</Caption>
<Style></Style>
<FontSize>8pt</FontSize>
</Style>
</ChartAxisTitle>
<ChartMajorGridLines>
<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>
<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>
<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>
</ChartValueAxes>
<Style></Style>
<BackgroundGradientType>None</BackgroundGradientType>
</Style>
</ChartArea>
</ChartAreas>
<Palette>BrightPastel</Palette>
<ChartBorderSkin>
<Style></Style>
<BackgroundColor>Gray</BackgroundColor>
<BackgroundGradientType>None</BackgroundGradientType>
<Color>White</Color>
</Style>
</ChartBorderSkin>
<ChartNoDataMessage Name="NoDataMessage">
<Caption>=Code.GetLocTable("LT_Table").GetString("RT.Chart.NoData", "[No Data]")</Caption>
<Style></Style>
<BackgroundGradientType>None</BackgroundGradientType>
<TextAlign>General</TextAlign>
<VerticalAlign>Top</VerticalAlign>
</Style>
</ChartNoDataMessage>
<DataSetName>ReportDataCounts</DataSetName>
<Filters>
<Filter>
<FilterExpression>=Fields!ChartDataSet.Value.ToString()</FilterExpression>
<Operator>Equal</Operator>
<FilterValues>
<FilterValue>="1"</FilterValue>
</FilterValues>
</Filter>
<Filter>
<FilterExpression>=Fields!HeaderDataSet.Value.ToString()</FilterExpression>
<Operator>Equal</Operator>
<FilterValues>
<FilterValue>="0"</FilterValue>
</FilterValues>
</Filter>
<Filter>
<FilterExpression>=Fields!ManagementGroupDataSet.Value.ToString()</FilterExpression>
<Operator>Equal</Operator>
<FilterValues>
<FilterValue>="0"</FilterValue>
</FilterValues>
</Filter>
<Filter>
<FilterExpression>=Fields!VersionDataSet.Value.ToString()</FilterExpression>
<Operator>Equal</Operator>
<FilterValues>
<FilterValue>="1"</FilterValue>
</FilterValues>
</Filter>
<Filter>
<FilterExpression>=Fields!LastDate.Value.ToString()</FilterExpression>
<Operator>Equal</Operator>
<FilterValues>
<FilterValue>="1"</FilterValue>
</FilterValues>
</Filter>
</Filters>
<Top>4.225in</Top>
<Left>6.2in</Left>
<Height>3.3in</Height>
<Width>3.55in</Width>
<ZIndex>5</ZIndex>
<Visibility>
<Hidden>=IIf(Parameters!StartDate.Value &gt; Parameters!EndDate.Value, True, False)</Hidden>
</Visibility>
<Style></Style>
<Border>
<Color>LightGrey</Color>
<Style></Style>None</Style>
</Border>
<BackgroundColor>White</BackgroundColor>
<BackgroundGradientType>None</BackgroundGradientType>
</Style>
</Chart>
<Textbox Name="TxtChartTitle03">
<CanGrow>true</CanGrow>
<CanShrink>true</CanShrink>
<DataElementStyle>Element</DataElementStyle>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Code.FormatString(Code.GetLocTable("LT_Table").GetString("RT.Chart.AgtCntByMGDay", "[Trend over time from {0} to {1}]"), Code.FormatDateTime("d",Code.GetReportDBStartDate()) , Code.FormatDateTime("d",Code.GetReportDBEndDate()))</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>11pt</FontSize>
<TextAlign>Left</TextAlign>
</Style>
</TextRun>
</TextRuns>
<Style/>
</Paragraph>
</Paragraphs>
<rd:DefaultName>textbox4</rd:DefaultName>
<Top>7.9in</Top>
<Left>0.925in</Left>
<Height>0.25in</Height>
<Width>4.88333in</Width>
<ZIndex>6</ZIndex>
<Visibility>
<Hidden>=IIf(Parameters!StartDate.Value &gt; Parameters!EndDate.Value, True, IIf(RowNumber("MPGroupsDisplayList")=1,True,False))</Hidden>
</Visibility>
<DataElementName>Title</DataElementName>
<DataElementOutput>Output</DataElementOutput>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>11pt</FontSize>
<TextAlign>Left</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="TxtChartTitle04">
<CanGrow>true</CanGrow>
<CanShrink>true</CanShrink>
<DataElementStyle>Element</DataElementStyle>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Code.FormatString(Code.GetLocTable("LT_Table").GetString("RT.Chart.EndingAgtCntByMG", "[Break down on {0}]"), Code.FormatDateTime("d",Code.GetReportDBEndDate()))</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>11pt</FontSize>
<TextAlign>Left</TextAlign>
</Style>
</TextRun>
</TextRuns>
<Style></Style>
<TextAlign>Center</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<rd:DefaultName>textbox4</rd:DefaultName>
<Top>7.9in</Top>
<Left>6.305in</Left>
<Height>0.25in</Height>
<Width>3.245in</Width>
<ZIndex>7</ZIndex>
<Visibility>
<Hidden>=IIf(Parameters!StartDate.Value &gt; Parameters!EndDate.Value, True, IIf(RowNumber("MPGroupsDisplayList")=1,True,False))</Hidden>
</Visibility>
<DataElementName>Title</DataElementName>
<DataElementOutput>Output</DataElementOutput>
<Style></Style>
<Border/>
<FontFamily>Tahoma</FontFamily>
<FontSize>11pt</FontSize>
<TextAlign>Left</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="TxtDatesParamMsgError">
<CanGrow>true</CanGrow>
<CanShrink>true</CanShrink>
<DataElementStyle>Element</DataElementStyle>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Code.GetLocTable("LT_Report").GetString("R.ErrorData", "[Error Start Date must be before End Date]")</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>11pt</FontSize>
<TextAlign>Center</TextAlign>
</Style>
</TextRun>
</TextRuns>
<Style/>
</Paragraph>
</Paragraphs>
<rd:DefaultName>textbox4</rd:DefaultName>
<Top>3.46472in</Top>
<Left>0.32667in</Left>
<Height>0.25in</Height>
<Width>9.35in</Width>
<ZIndex>8</ZIndex>
<Visibility>
<Hidden>=IIf(Parameters!StartDate.Value &gt; Parameters!EndDate.Value, False, True)</Hidden>
</Visibility>
<DataElementName>Title</DataElementName>
<DataElementOutput>Output</DataElementOutput>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>11pt</FontSize>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="TxtChartTitle02">
<CanGrow>true</CanGrow>
<CanShrink>true</CanShrink>
<DataElementStyle>Element</DataElementStyle>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Code.FormatString(Code.GetLocTable("LT_Table").GetString("RT.Chart.EndingAgtCntByVer", "[Break down on {0}]"), Code.FormatDateTime("d",Code.GetReportDBEndDate()))</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>11pt</FontSize>
<TextAlign>Left</TextAlign>
</Style>
</TextRun>
</TextRuns>
<Style></Style>
<TextAlign>Center</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<rd:DefaultName>textbox4</rd:DefaultName>
<Top>3.975in</Top>
<Left>6.305in</Left>
<Height>0.25in</Height>
<Width>3.245in</Width>
<ZIndex>9</ZIndex>
<Visibility>
<Hidden>=IIf(Parameters!StartDate.Value &gt; Parameters!EndDate.Value, True, False)</Hidden>
</Visibility>
<DataElementName>Title</DataElementName>
<DataElementOutput>Output</DataElementOutput>
<Style></Style>
<Border/>
<FontFamily>Tahoma</FontFamily>
<FontSize>11pt</FontSize>
<TextAlign>Left</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="TxtChartGroup01Title">
<CanGrow>true</CanGrow>
<CanShrink>true</CanShrink>
<DataElementStyle>Element</DataElementStyle>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Code.GetLocTable("LT_Report").GetString("R.ChartGroupByVer", "[Agent counts By Version]")</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>12pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style/>
</Paragraph>
</Paragraphs>
<rd:DefaultName>textbox4</rd:DefaultName>
<Top>3.75639in</Top>
<Left>0.925in</Left>
<Height>0.25in</Height>
<Width>4.88333in</Width>
<ZIndex>10</ZIndex>
<Visibility>
<Hidden>=IIf(Parameters!StartDate.Value &gt; Parameters!EndDate.Value, True, False)</Hidden>
</Visibility>
<DataElementName>Title</DataElementName>
<DataElementOutput>Output</DataElementOutput>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>12pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="TxtChartGroup02Title">
<CanGrow>true</CanGrow>
<CanShrink>true</CanShrink>
<DataElementStyle>Element</DataElementStyle>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Code.GetLocTable("LT_Report").GetString("R.ChartGroupByMG", "[Agent Counts By Management Group]")</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>12pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
</Style>
</TextRun>
</TextRuns>
<Style/>
</Paragraph>
</Paragraphs>
<rd:DefaultName>textbox4</rd:DefaultName>
<Top>7.7in</Top>
<Left>0.925in</Left>
<Height>0.25in</Height>
<Width>4.88333in</Width>
<ZIndex>11</ZIndex>
<Visibility>
<Hidden>=IIf(Parameters!StartDate.Value &gt; Parameters!EndDate.Value, True, IIf(RowNumber("MPGroupsDisplayList")=1,True,False))</Hidden>
</Visibility>
<DataElementName>Title</DataElementName>
<DataElementOutput>Output</DataElementOutput>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>12pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="TxtChartTitle01">
<CanGrow>true</CanGrow>
<CanShrink>true</CanShrink>
<DataElementStyle>Element</DataElementStyle>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Code.FormatString(Code.GetLocTable("LT_Table").GetString("RT.Chart.AgtCntByVerDay", "[Trend over time from {0} to {1}]"), Code.FormatDateTime("d",Code.GetReportDBStartDate()) , Code.FormatDateTime("d",Code.GetReportDBEndDate()))</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>11pt</FontSize>
<TextAlign>Left</TextAlign>
</Style>
</TextRun>
</TextRuns>
<Style/>
</Paragraph>
</Paragraphs>
<rd:DefaultName>textbox4</rd:DefaultName>
<Top>3.95639in</Top>
<Left>0.925in</Left>
<Height>0.25in</Height>
<Width>4.88333in</Width>
<ZIndex>12</ZIndex>
<Visibility>
<Hidden>=IIf(Parameters!StartDate.Value &gt; Parameters!EndDate.Value, True, False)</Hidden>
</Visibility>
<DataElementName>Title</DataElementName>
<DataElementOutput>Output</DataElementOutput>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>11pt</FontSize>
<TextAlign>Left</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</ReportItems>
<Height>11.55in</Height>
<Style/>
</Script></Body>
<ReportParameters>
<ReportParameter Name="LT_Report">
<DataType>String</DataType>
<DefaultValue>
<DataSetReference>
<DataSetName>LT_Report_Query</DataSetName>
<ValueField>ValueXml</ValueField>
</DataSetReference>
</DefaultValue>
<Hidden>true</Hidden>
<ValidValues>
<DataSetReference>
<DataSetName>LT_Report_Query</DataSetName>
<ValueField>ValueXml</ValueField>
<LabelField>ValueName</LabelField>
</DataSetReference>
</ValidValues>
</ReportParameter>
<ReportParameter Name="LT_Table">
<DataType>String</DataType>
<DefaultValue>
<DataSetReference>
<DataSetName>LT_Table_Query</DataSetName>
<ValueField>ValueXml</ValueField>
</DataSetReference>
</DefaultValue>
<Hidden>true</Hidden>
<ValidValues>
<DataSetReference>
<DataSetName>LT_Table_Query</DataSetName>
<ValueField>ValueXml</ValueField>
<LabelField>ValueName</LabelField>
</DataSetReference>
</ValidValues>
</ReportParameter>
<ReportParameter Name="ManagementGroupId">
<DataType>String</DataType>
<DefaultValue>
<DataSetReference>
<DataSetName>NeighborManagementGroups</DataSetName>
<ValueField>ManagementGroupGuid</ValueField>
</DataSetReference>
</DefaultValue>
<Prompt>ManagementGroupId</Prompt>
<Hidden>true</Hidden>
<ValidValues>
<DataSetReference>
<DataSetName>NeighborManagementGroups</DataSetName>
<ValueField>ManagementGroupGuid</ValueField>
<LabelField>ManagementGroupName</LabelField>
</DataSetReference>
</ValidValues>
<MultiValue>true</MultiValue>
</ReportParameter>
<ReportParameter Name="UserLanguageCode">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>=Code.GetReportLocLanguageCode()</Value>
</Values>
</DefaultValue>
</ReportParameter>
<ReportParameter Name="AggregationType">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>1</Value>
</Values>
</DefaultValue>
<Prompt>[AggregationType]</Prompt>
<ValidValues>
<ParameterValues>
<ParameterValue>
<Value>1</Value>
<Label>=Code.GetLocTable("LT_Table").GetString("RT.Legend.ByDay", "[Daily]")</Label>
</ParameterValue>
<ParameterValue>
<Value>2</Value>
<Label>=Code.GetLocTable("LT_Table").GetString("RT.Legend.ByWeek", "[Weekly]")</Label>
</ParameterValue>
<ParameterValue>
<Value>3</Value>
<Label>=Code.GetLocTable("LT_Table").GetString("RT.Legend.ByMonth", "[Monthly]")</Label>
</ParameterValue>
<ParameterValue>
<Value>4</Value>
<Label>=Code.GetLocTable("LT_Table").GetString("RT.Legend.ByQuarter", "[Quarterly]")</Label>
</ParameterValue>
<ParameterValue>
<Value>5</Value>
<Label>=Code.GetLocTable("LT_Table").GetString("RT.Legend.ByYear", "[Yearly]")</Label>
</ParameterValue>
</ParameterValues>
</ValidValues>
</ReportParameter>
<ReportParameter Name="StartDate">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>=FormatDateTime(DateAdd(DateInterval.Day,-14,Today()),DateFormat.ShortDate)</Value>
</Values>
</DefaultValue>
<Prompt>[From]</Prompt>
</ReportParameter>
<ReportParameter Name="EndDate">
<DataType>DateTime</DataType>
<Prompt>[To]</Prompt>
</ReportParameter>
<ReportParameter Name="Interactive">
<DataType>Boolean</DataType>
<Nullable>true</Nullable>
<DefaultValue>
<Values>
<Value>=False</Value>
</Values>
</DefaultValue>
<Prompt>Interactive</Prompt>
<Hidden>true</Hidden>
</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 SD_ParameterName As String = "StartDate"
Const ED_ParameterName As String = "EndDate"

Const IsRelativeTimeSupported As Boolean = False
Const TimeTypeParameterName As String = "TimeType"
Const TimeWeekMapParameterName As String = "TimeWeekMap"

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

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)
End Sub

Public Function GetCallingManagementGroupId() As String
Return Microsoft.EnterpriseManagement.Reporting.ReportingConfiguration.ManagementGroupId
End Function

Public Function GetReportLocLanguageCode() As String
Return ReportCulture.ThreeLetterWindowsLanguageName
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)
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

Public Function BuildStringValueList(ByVal ValueList() As Object) As String
Dim strValues As New System.Text.StringBuilder()
strValues.Append("&lt;Data&gt;")

For Each ItmOpc As String In ValueList
strValues.Append("&lt;Value&gt;")
strValues.Append(ItmOpc)
strValues.Append("&lt;/Value&gt;")
Next
strValues.Append("&lt;/Data&gt;")
Return strValues.ToString()
End Function

Public Function CheckOption(ByVal ValueList() As Object, ByVal OptionToCheck As String, ByVal OptSpace as Boolean) As Boolean
Dim strCheckValid As Boolean
Dim myIndex As Integer = Array.IndexOf(ValueList, OptionToCheck)

If (myIndex = -1) Then
strCheckValid = True
Else
strCheckValid = False
End If

If strCheckValid = True And OptSpace = True Then
strCheckValid = False
Else
If strCheckValid = False And OptSpace = True Then
strCheckValid = True
Else
strCheckValid = strCheckValid
End If
End If

Return strCheckValid
End Function

Public Function CheckOptionVal(ByVal ParamValue As String, ByVal OptionToCheck As String, ByVal OptSpace as Boolean) As Boolean
Dim strCheckValid As Boolean

If (ParamValue.Contains(OptionToCheck)) Then
strCheckValid = False
Else
strCheckValid = True
End If

If strCheckValid = True And OptSpace = True Then
strCheckValid = False
Else
If strCheckValid = False And OptSpace = True Then
strCheckValid = True
Else
strCheckValid = strCheckValid
End If
End If

Return strCheckValid
End Function

Public Function GetReportParamStartDate(ByVal DateValue As DateTime) As DateTime
Dim DateTimeToUse As New DateTime()
Dim DateTimeToReturn As New DateTime(DateValue.Year, DateValue.Month, DateValue.Day, 0, 0, 0)
Return DateTimeToReturn
End Function

Public Function GetReportParamEndDate(ByVal DateValue As DateTime) As DateTime
Dim DateTimeToUse As New DateTime()
Dim DateTimeToReturn As New DateTime(DateValue.Year, DateValue.Month, DateValue.Day, 23, 59, 59)
Return DateTimeToReturn
End Function

Public Function GetAdjHours(ByVal DateValue As DateTime, ByVal ReportDateValue As DateTime) As String
Return DateValue.Subtract(ReportDateValue).Hours.ToString()
End Function

Public Function GetReportDBStartDate() As DateTime
Dim DateTimeToUse As New DateTime()
Dim DateValue As New DateTime()
DateValue = Report.Parameters(SD_ParameterName).Value
Dim DateTimeToReturn As New DateTime(DateValue.Year, DateValue.Month, DateValue.Day, 0, 1, 0)
Return DateTimeToReturn
End Function

Public Function GetReportDBEndDate() As DateTime
Dim DateTimeToUse As New DateTime()
Dim DateValue As New DateTime()
DateValue = Report.Parameters(ED_ParameterName).Value
Dim DateTimeToReturn As New DateTime(DateValue.Year, DateValue.Month, DateValue.Day, 0, 1, 0)
Return DateTimeToReturn
End Function
</Script></Code>
<Width>10.15in</Width>
<Page>
<PageFooter>
<Height>0.35in</Height>
<PrintOnFirstPage>true</PrintOnFirstPage>
<PrintOnLastPage>true</PrintOnLastPage>
<ReportItems>
<Textbox Name="textbox37">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value/>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<Color>DimGray</Color>
</Style>
</TextRun>
</TextRuns>
<Style/>
</Paragraph>
</Paragraphs>
<Top>0.1in</Top>
<Left>0.3in</Left>
<Height>0.1875in</Height>
<Width>5.75in</Width>
<Style></Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="textbox8">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=string.Format(Code.GetLocTable("LT_Report").GetString("R.PageFormat", "{0}/{1}"), Globals!PageNumber, Globals!TotalPages)</Value>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<Color>DimGray</Color>
</Style>
</TextRun>
</TextRuns>
<Style></Style>
<TextAlign>Right</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<Top>0.1in</Top>
<Left>8.05in</Left>
<Height>0.1875in</Height>
<Width>1.7in</Width>
<ZIndex>1</ZIndex>
<Style></Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</ReportItems>
<Style/>
</PageFooter>
<Style/>
</Page>
<Language>en-US</Language>
<CodeModules>
<CodeModule>Microsoft.EnterpriseManagement.Reporting.Code, Version=6.0.0.0, Culture=neutral</CodeModule>
</CodeModules>
<ConsumeContainerWhitespace>true</ConsumeContainerWhitespace>
<DataElementStyle>Element</DataElementStyle>
<rd:ReportID>16c7e843-b425-4dcc-b22f-fcc7250ca68d</rd:ReportID>
<rd:ReportUnitType>Inch</rd:ReportUnitType>
</Report>
</Definition>
<ReportStrings>
<ReportString ID="R.Title"/>
<ReportString ID="R.DescriptionTitle"/>
<ReportString ID="R.Description"/>
<ReportString ID="R.StartEndTimeLabel"/>
<ReportString ID="R.StartEndTimeFormat"/>
<ReportString ID="R.ManagementGroupsLabel"/>
<ReportString ID="R.AggregationLabel"/>
<ReportString ID="R.ChartGroupByMG"/>
<ReportString ID="R.ChartGroupByVer"/>
<ReportString ID="R.EndAgtCntLbl"/>
<ReportString ID="R.BenAgtCntLbl"/>
<ReportString ID="R.PageFormat"/>
<ReportString ID="R.TimeZoneFormat"/>
<ReportString ID="R.ErrorData"/>
<ReportString ID="RT.Legend.ByDay"/>
<ReportString ID="RT.Legend.ByWeek"/>
<ReportString ID="RT.Legend.ByMonth"/>
<ReportString ID="RT.Legend.ByQuarter"/>
<ReportString ID="RT.Legend.ByYear"/>
<ReportString ID="RT.Chart.AltReportItem"/>
<ReportString ID="RT.Chart.NoData"/>
<ReportString ID="RT.Chart.Counts"/>
<ReportString ID="RT.Chart.AgtCntByVerDay"/>
<ReportString ID="RT.Chart.EndingAgtCntByVer"/>
<ReportString ID="RT.Chart.AgtCntByMGDay"/>
<ReportString ID="RT.Chart.EndingAgtCntByMG"/>
</ReportStrings>
</Report>