날짜, 관리 그룹 및 버전별 에이전트 개수

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 Chart를 사용할 수 없습니다.
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>