Contagens do Agente por Data, Grupo de Gerenciamento e Versão
Microsoft.SystemCenter.OperationsManager.Reports.2007.AgentVersions.Report (Report)
Esse relatório mostra informações detalhadas para contas de agente durante o intervalo de tempo especificado.
Element properties: Report Localization: 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)>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 > 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 > 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 > 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)>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 > 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 > 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 > 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 > 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 > 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 > 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 > 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 > 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("<Data>")
For Each ItmOpc As String In ValueList
strValues.Append("<Value>")
strValues.Append(ItmOpc)
strValues.Append("</Value>")
Next
strValues.Append("</Data>")
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>