TCP connections - Consolidated summary

Jalasoft.Xian.OpsMgr2007MP.Report.NetworkDevice.TCPConnections_Perf.Consolidated.Summary (Report)

This report provides consolidated summary information about the Open active TCP connections, Open TCP connections, Established TCP connections and Attempt failed TCP connections registered during a defined period for the monitored Network Device. Jalasoft Xian Network Manager collects data for this report (using the Open active TCP connections, Open TCP connections, Established TCP connections and Attempt failed TCP connections rule included in the Jalasoft Xian NM plug-in for Network Devices).

Element properties:

AccessibilityPublic
VisibleTrue

Source Code:

<Report ID="Jalasoft.Xian.OpsMgr2007MP.Report.NetworkDevice.TCPConnections_Perf.Consolidated.Summary" Accessibility="Public" Target="Standard_Snmp_Rfc1213!Jalasoft.Xian.Common.Elements.Standard.Snmp.Rfc1213.JsXNetworkDeviceSnmpDeviceElement" Visible="true">
<ParameterBlock xmlns="http://schemas.microsoft.com/mom/reporting/2007/ReportParameterSettings" columns="2">
<Controls>
<Control type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.RelativeDateTimePicker" rowSpan="3" columnSpan="1">
<ReportParameters>
<ReportParameter name="TimeZone" binding="TimeZone"/>
<ReportParameter name="TimeZoneName" binding="TimeZoneName"/>
<ReportParameter name="StartDate_BaseType" binding="StartDate_BaseType"/>
<ReportParameter name="StartDate" binding="StartDate_BaseValue"/>
<ReportParameter name="StartDate_OffsetType" binding="StartDate_OffsetType"/>
<ReportParameter name="StartDate_OffsetValue" binding="StartDate_OffsetValue"/>
<ReportParameter name="EndDate_BaseType" binding="EndDate_BaseType"/>
<ReportParameter name="EndDate" binding="EndDate_BaseValue"/>
<ReportParameter name="EndDate_OffsetType" binding="EndDate_OffsetType"/>
<ReportParameter name="EndDate_OffsetValue" binding="EndDate_OffsetValue"/>
</ReportParameters>
</Control>
<Control type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.CheckedListBox">
<ReportParameters>
<ReportParameter name="SelectedRulesList"/>
</ReportParameters>
</Control>
</Controls>
</ParameterBlock>
<Definition>
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<DataSources>
<DataSource Name="DataWarehouseMain">
<DataSourceReference>Data Warehouse Main</DataSourceReference>
</DataSource>
</DataSources>
<BottomMargin>1in</BottomMargin>
<RightMargin>1in</RightMargin>
<ReportParameters>
<ReportParameter Name="StartDate">
<DataType>DateTime</DataType>
<AllowBlank>true</AllowBlank>
<Prompt>Start Date</Prompt>
</ReportParameter>
<ReportParameter Name="EndDate">
<DataType>DateTime</DataType>
<AllowBlank>true</AllowBlank>
<Prompt>End Date</Prompt>
</ReportParameter>
<ReportParameter Name="TimeZone">
<DataType>String</DataType>
<AllowBlank>true</AllowBlank>
<Prompt>Time Zone</Prompt>
</ReportParameter>
<ReportParameter Name="TimeZoneName">
<DataType>String</DataType>
<AllowBlank>true</AllowBlank>
<Prompt>TimeZoneName</Prompt>
</ReportParameter>
<ReportParameter Name="StartDate_BaseType">
<DataType>String</DataType>
<AllowBlank>true</AllowBlank>
<Prompt>StartDate_BaseType</Prompt>
</ReportParameter>
<ReportParameter Name="StartDate_OffsetType">
<DataType>String</DataType>
<AllowBlank>true</AllowBlank>
<Prompt>StartDate_OffsetType</Prompt>
</ReportParameter>
<ReportParameter Name="StartDate_OffsetValue">
<DataType>String</DataType>
<AllowBlank>true</AllowBlank>
<Prompt>StartDate_OffsetValue</Prompt>
</ReportParameter>
<ReportParameter Name="EndDate_BaseType">
<DataType>String</DataType>
<AllowBlank>true</AllowBlank>
<Prompt>EndDate_BaseType</Prompt>
</ReportParameter>
<ReportParameter Name="EndDate_OffsetType">
<DataType>String</DataType>
<AllowBlank>true</AllowBlank>
<Prompt>EndDate_OffsetType</Prompt>
</ReportParameter>
<ReportParameter Name="EndDate_OffsetValue">
<DataType>String</DataType>
<AllowBlank>true</AllowBlank>
<Prompt>EndDate_OffsetValue</Prompt>
</ReportParameter>
<ReportParameter Name="RulesList">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>Jalasoft.Xian.SmartManagementPacks.NetworkDevices.DW.OpenActiveTCPConnections.1.1|Open active TCP connections (1)|Open active TCP connections|Connections|Y;Jalasoft.Xian.SmartManagementPacks.NetworkDevices.DW.OpenTCPConnections.1.1|Open TCP connections (1)|Open TCP connections|Connections|Y;Jalasoft.Xian.SmartManagementPacks.NetworkDevices.DW.EstablishedTCPConnections.1.1|Established TCP connections (1)|Established TCP connections|Connections|Y;Jalasoft.Xian.SmartManagementPacks.NetworkDevices.DW.AttemptFailedTCPConnections.1.1|Attempt failed TCP connections (1)|Attempt failed TCP connections|Connections|Y;</Value>
</Values>
</DefaultValue>
</ReportParameter>
<ReportParameter Name="SelectedRulesList">
<DataType>String</DataType>
<DefaultValue>
<DataSetReference>
<DataSetName>PerfRulesList</DataSetName>
<ValueField>RuleSystemName</ValueField>
</DataSetReference>
</DefaultValue>
<Prompt>Type</Prompt>
<ValidValues>
<DataSetReference>
<DataSetName>PerfRulesList</DataSetName>
<ValueField>RuleSystemName</ValueField>
<LabelField>RuleName</LabelField>
</DataSetReference>
</ValidValues>
<MultiValue>true</MultiValue>
</ReportParameter>
<ReportParameter Name="DeviceType">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>Jalasoft.Xian.Common.Elements.Standard.Snmp.Rfc1213.JsXNetworkDeviceSnmpDeviceElement;</Value>
</Values>
</DefaultValue>
</ReportParameter>
<ReportParameter Name="PluginName">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>Jalasoft Xian NM plugin for Network Devices</Value>
</Values>
</DefaultValue>
</ReportParameter>
<ReportParameter Name="NodeType">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>Jalasoft.Xian.Common.Elements.Standard.Snmp.Rfc1213.JsXNetworkDeviceSnmpDeviceElement;</Value>
</Values>
</DefaultValue>
</ReportParameter>
</ReportParameters>
<rd:DrawGrid>true</rd:DrawGrid>
<InteractiveWidth>8.5in</InteractiveWidth>
<rd:GridSpacing>0.05in</rd:GridSpacing>
<rd:SnapToGrid>true</rd:SnapToGrid>
<Body><Script>
<ReportItems>
<List Name="matrixNAA">
<Left>0.1in</Left>
<ReportItems>
<Textbox Name="matrixNA">
<HideDuplicates>ReportDataEx</HideDuplicates>
<Style></Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>N/A: Not available</Value>
</Textbox>
</ReportItems>
<DataSetName>ReportDataEx</DataSetName>
<Top>3.25in</Top>
<ZIndex>7</ZIndex>
<Visibility>
<Hidden>=iif(CountRows()&gt;0 And Parameters!SelectedRulesList.Count &gt; 1,false,true)</Hidden>
</Visibility>
<Width>1.95in</Width>
<Grouping Name="list1_Details_Group">
<Filters>
<Filter>
<Operator>In</Operator>
<FilterValues>
<FilterValue>=Parameters!SelectedRulesList.Value</FilterValue>
</FilterValues>
<FilterExpression>=Fields!RuleSystemName.Value</FilterExpression>
</Filter>
</Filters>
<GroupExpressions>
<GroupExpression>=Fields!RuleSystemName.Value</GroupExpression>
</GroupExpressions>
</Grouping>
<Height>0.25in</Height>
</List>
<Table Name="tblPerformanceNA">
<Footer>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ColSpan>2</ColSpan>
<ReportItems>
<Textbox Name="txtNANA">
<ZIndex>2</ZIndex>
<Style></Style>
<BorderStyle>
<Top>Solid</Top>
</BorderStyle>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>N/A: Not available</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.25in</Height>
</TableRow>
</TableRows>
</Footer>
<Left>0.1in</Left>
<Filters>
<Filter>
<Operator>Equal</Operator>
<FilterValues>
<FilterValue>N</FilterValue>
</FilterValues>
<FilterExpression>=Fields!Averagable.Value</FilterExpression>
</Filter>
<Filter>
<Operator>Equal</Operator>
<FilterValues>
<FilterValue>=False</FilterValue>
</FilterValues>
<FilterExpression>=IsNothing(Fields!DeviceRowId.Value)</FilterExpression>
</Filter>
<Filter>
<Operator>In</Operator>
<FilterValues>
<FilterValue>=Parameters!SelectedRulesList.Value</FilterValue>
</FilterValues>
<FilterExpression>=Fields!RuleSystemName.Value</FilterExpression>
</Filter>
</Filters>
<DataSetName>ReportDataEx</DataSetName>
<Top>3.6in</Top>
<ZIndex>6</ZIndex>
<Visibility>
<Hidden>=IIf(Parameters!SelectedRulesList.Count&gt;1 or CountRows()=0, true, false)</Hidden>
</Visibility>
<Width>6.3in</Width>
<Details>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="txtDeviceNameNA">
<ZIndex>1</ZIndex>
<Action>
<Drillthrough>
<ReportName>Jalasoft.Xian.OpsMgr2007MP.Report.NetworkDevice.TCPConnections_Perf.Consolidated.Detailed</ReportName>
<Parameters>
<Parameter Name="StartDate">
<Value>=Parameters!StartDate.Value</Value>
</Parameter>
<Parameter Name="EndDate">
<Value>=Parameters!EndDate.Value</Value>
</Parameter>
<Parameter Name="Device">
<Value>=Fields!DeviceRowId.Value</Value>
</Parameter>
<Parameter Name="SelectedRulesList">
<Value>=Parameters!SelectedRulesList.Value</Value>
</Parameter>
<Parameter Name="TimeZone">
<Value>=Parameters!TimeZone.Value</Value>
</Parameter>
<Parameter Name="TimeZoneName">
<Value>=Parameters!TimeZoneName.Value</Value>
</Parameter>
<Parameter Name="StartDate_BaseType">
<Value>=Parameters!StartDate_BaseType.Value</Value>
</Parameter>
<Parameter Name="StartDate_OffsetType">
<Value>=Parameters!StartDate_OffsetType.Value</Value>
</Parameter>
<Parameter Name="StartDate_OffsetValue">
<Value>=Parameters!StartDate_OffsetValue.Value</Value>
</Parameter>
<Parameter Name="EndDate_BaseType">
<Value>=Parameters!EndDate_BaseType.Value</Value>
</Parameter>
<Parameter Name="EndDate_OffsetType">
<Value>=Parameters!EndDate_OffsetType.Value</Value>
</Parameter>
<Parameter Name="EndDate_OffsetValue">
<Value>=Parameters!EndDate_OffsetValue.Value</Value>
</Parameter>
</Parameters>
</Drillthrough>
</Action>
<Style></Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<BackgroundColor>=iif(rownumber(nothing) mod 2, "white", "whitesmoke")</BackgroundColor>
<TextDecoration>Underline</TextDecoration>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!DeviceDisplayName.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="txtTotal">
<Style></Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<BackgroundColor>=iif(rownumber(nothing) mod 2, "white", "whitesmoke")</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Code.FormatNumberByCounterType(Fields!SumValue.Value,Fields!Unit.Value,Fields!Averagable.Value)</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.25in</Height>
</TableRow>
</TableRows>
</Details>
<Style></Style>
<BorderWidth>
<Bottom>1pt</Bottom>
</BorderWidth>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<BorderColor>
<Bottom>DimGray</Bottom>
<Top>DimGray</Top>
<Default>DimGray</Default>
<Left>DimGray</Left>
<Right>DimGray</Right>
</BorderColor>
</Style>
<Header>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="lblDeviceNameNA">
<ZIndex>4</ZIndex>
<Style></Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<BackgroundColor>Gray</BackgroundColor>
<Color>White</Color>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<UserSort>
<SortExpression>=Fields!DeviceDisplayName.Value</SortExpression>
</UserSort>
<Value>=First(Fields!ManagedEntityTypeDefaultName.Value, "DeviceTypeDisplayName")
</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="lblTotal">
<ZIndex>3</ZIndex>
<Style></Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<BackgroundColor>Gray</BackgroundColor>
<Color>White</Color>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>Total</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.35in</Height>
</TableRow>
</TableRows>
<RepeatOnNewPage>true</RepeatOnNewPage>
</Header>
<TableColumns>
<TableColumn>
<Width>3.90698in</Width>
</TableColumn>
<TableColumn>
<Width>2.39302in</Width>
</TableColumn>
</TableColumns>
<Height>0.85in</Height>
</Table>
<List Name="NoDataList">
<Left>0.5in</Left>
<DataSetName>ReportDataEx</DataSetName>
<Top>2.75in</Top>
<NoRows>There is no data available for this report. This may occur when there is no relevant data available for collection, this report depends on data generated by the following Xian Network Manager rules, included in the Jalasoft Xian NM plug-in for Network Devices: Open active TCP connections, Open TCP connections, Established TCP connections and Attempt failed TCP connections</NoRows>
<ZIndex>5</ZIndex>
<Visibility>
<Hidden>=iif(CountRows()&gt;0,true,false)</Hidden>
</Visibility>
<Width>5.5in</Width>
<Style></Style>
<TextAlign>Center</TextAlign>
</Style>
<Grouping Name="NoDataList_Details_Group">
<Filters>
<Filter>
<Operator>In</Operator>
<FilterValues>
<FilterValue>=Parameters!SelectedRulesList.Value</FilterValue>
</FilterValues>
<FilterExpression>=Fields!RuleSystemName.Value</FilterExpression>
</Filter>
</Filters>
<GroupExpressions>
<GroupExpression>=Fields!RuleSystemName.Value</GroupExpression>
</GroupExpressions>
</Grouping>
<Height>2in</Height>
</List>
<Table Name="tblPerformanceA">
<Footer>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ColSpan>4</ColSpan>
<ReportItems>
<Textbox Name="txtNAA">
<ZIndex>4</ZIndex>
<Style></Style>
<BorderStyle>
<Top>Solid</Top>
</BorderStyle>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>N/A: Not available</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.25in</Height>
</TableRow>
</TableRows>
</Footer>
<Left>0.09999in</Left>
<Filters>
<Filter>
<Operator>Equal</Operator>
<FilterValues>
<FilterValue>=False</FilterValue>
</FilterValues>
<FilterExpression>=IsNothing(Fields!DeviceRowId.Value)</FilterExpression>
</Filter>
<Filter>
<Operator>Equal</Operator>
<FilterValues>
<FilterValue>Y</FilterValue>
</FilterValues>
<FilterExpression>=Fields!Averagable.Value</FilterExpression>
</Filter>
<Filter>
<Operator>In</Operator>
<FilterValues>
<FilterValue>=Parameters!SelectedRulesList.Value</FilterValue>
</FilterValues>
<FilterExpression>=Fields!RuleSystemName.Value</FilterExpression>
</Filter>
</Filters>
<DataSetName>ReportDataEx</DataSetName>
<Top>2.75in</Top>
<ZIndex>4</ZIndex>
<Visibility>
<Hidden>=IIf(Parameters!SelectedRulesList.Count&gt;1 or CountRows()=0, true, false)</Hidden>
</Visibility>
<Width>6.3in</Width>
<Details>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="txtDeviceNameA">
<HideDuplicates>ReportDataEx</HideDuplicates>
<ZIndex>3</ZIndex>
<Action>
<Drillthrough>
<ReportName>Jalasoft.Xian.OpsMgr2007MP.Report.NetworkDevice.TCPConnections_Perf.Consolidated.Detailed</ReportName>
<Parameters>
<Parameter Name="StartDate">
<Value>=Parameters!StartDate.Value</Value>
</Parameter>
<Parameter Name="EndDate">
<Value>=Parameters!EndDate.Value</Value>
</Parameter>
<Parameter Name="Device">
<Value>=Fields!DeviceRowId.Value</Value>
</Parameter>
<Parameter Name="SelectedRulesList">
<Value>=Parameters!SelectedRulesList.Value</Value>
</Parameter>
<Parameter Name="TimeZone">
<Value>=Parameters!TimeZone.Value</Value>
</Parameter>
<Parameter Name="TimeZoneName">
<Value>=Parameters!TimeZoneName.Value</Value>
</Parameter>
<Parameter Name="StartDate_BaseType">
<Value>=Parameters!StartDate_BaseType.Value</Value>
</Parameter>
<Parameter Name="StartDate_OffsetType">
<Value>=Parameters!StartDate_OffsetType.Value</Value>
</Parameter>
<Parameter Name="StartDate_OffsetValue">
<Value>=Parameters!StartDate_OffsetValue.Value</Value>
</Parameter>
<Parameter Name="EndDate_BaseType">
<Value>=Parameters!EndDate_BaseType.Value</Value>
</Parameter>
<Parameter Name="EndDate_OffsetType">
<Value>=Parameters!EndDate_OffsetType.Value</Value>
</Parameter>
<Parameter Name="EndDate_OffsetValue">
<Value>=Parameters!EndDate_OffsetValue.Value</Value>
</Parameter>
</Parameters>
</Drillthrough>
</Action>
<Style></Style>
<BorderStyle>
<Bottom>None</Bottom>
<Top>Solid</Top>
<Default>Solid</Default>
<Left>Solid</Left>
<Right>Solid</Right>
</BorderStyle>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!DeviceDisplayName.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="txtMinimum">
<ZIndex>2</ZIndex>
<Style></Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Code.FormatNumberByCounterType(Fields!MinValue.Value,Fields!Unit.Value,Fields!Averagable.Value)</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="txtAverage">
<ZIndex>1</ZIndex>
<Style></Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=IIF(IsNothing(Fields!SampleCount.Value),
"N/A",
Code.FormatNumberByCounterType(Fields!SumValue.Value/Fields!SampleCount.Value
,Fields!Unit.Value,Fields!Averagable.Value)
)</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="txtMaximum">
<Style></Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Code.FormatNumberByCounterType(Fields!MaxValue.Value,Fields!Unit.Value,Fields!Averagable.Value)</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.25in</Height>
</TableRow>
</TableRows>
</Details>
<Header>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="lblDeviceNameA">
<ZIndex>8</ZIndex>
<Style></Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<BackgroundColor>Gray</BackgroundColor>
<Color>White</Color>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<UserSort>
<SortExpression>=Fields!DeviceDisplayName.Value</SortExpression>
</UserSort>
<Value>=First(Fields!ManagedEntityTypeDefaultName.Value, "DeviceTypeDisplayName")
</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="lblMinimum">
<ZIndex>7</ZIndex>
<Style></Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<BackgroundColor>Gray</BackgroundColor>
<Color>White</Color>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>Minimum</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="lblAverage">
<ZIndex>6</ZIndex>
<Style></Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<BackgroundColor>Gray</BackgroundColor>
<Color>White</Color>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>Average</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="lblMaximum">
<ZIndex>5</ZIndex>
<Style></Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<BackgroundColor>Gray</BackgroundColor>
<Color>White</Color>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>Maximum</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.35in</Height>
</TableRow>
</TableRows>
</Header>
<TableColumns>
<TableColumn>
<Width>1.575in</Width>
</TableColumn>
<TableColumn>
<Width>1.575in</Width>
</TableColumn>
<TableColumn>
<Width>1.575in</Width>
</TableColumn>
<TableColumn>
<Width>1.575in</Width>
</TableColumn>
</TableColumns>
<Height>0.85in</Height>
</Table>
<Matrix Name="mtxPerformance">
<MatrixColumns>
<MatrixColumn>
<Width>1.3in</Width>
</MatrixColumn>
</MatrixColumns>
<Left>0.1in</Left>
<KeepTogether>true</KeepTogether>
<RowGroupings>
<RowGrouping>
<Width>1.55in</Width>
<DynamicRows>
<ReportItems>
<Textbox Name="txtDeviceName">
<ZIndex>1</ZIndex>
<Action>
<Drillthrough>
<ReportName>Jalasoft.Xian.OpsMgr2007MP.Report.NetworkDevice.TCPConnections_Perf.Consolidated.Detailed</ReportName>
<Parameters>
<Parameter Name="StartDate">
<Value>=Parameters!StartDate.Value</Value>
</Parameter>
<Parameter Name="EndDate">
<Value>=Parameters!EndDate.Value</Value>
</Parameter>
<Parameter Name="Device">
<Value>=Fields!DeviceRowId.Value</Value>
</Parameter>
<Parameter Name="SelectedRulesList">
<Value>=Parameters!SelectedRulesList.Value</Value>
</Parameter>
<Parameter Name="TimeZone">
<Value>=Parameters!TimeZone.Value</Value>
</Parameter>
<Parameter Name="TimeZoneName">
<Value>=Parameters!TimeZoneName.Value</Value>
</Parameter>
<Parameter Name="StartDate_BaseType">
<Value>=Parameters!StartDate_BaseType.Value</Value>
</Parameter>
<Parameter Name="StartDate_OffsetType">
<Value>=Parameters!StartDate_OffsetType.Value</Value>
</Parameter>
<Parameter Name="StartDate_OffsetValue">
<Value>=Parameters!StartDate_OffsetValue.Value</Value>
</Parameter>
<Parameter Name="EndDate_BaseType">
<Value>=Parameters!EndDate_BaseType.Value</Value>
</Parameter>
<Parameter Name="EndDate_OffsetType">
<Value>=Parameters!EndDate_OffsetType.Value</Value>
</Parameter>
<Parameter Name="EndDate_OffsetValue">
<Value>=Parameters!EndDate_OffsetValue.Value</Value>
</Parameter>
</Parameters>
</Drillthrough>
</Action>
<Style></Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!DeviceDisplayName.Value</Value>
</Textbox>
</ReportItems>
<Grouping Name="matrix1_RowGroup1">
<Filters>
<Filter>
<Operator>Equal</Operator>
<FilterValues>
<FilterValue>=false</FilterValue>
</FilterValues>
<FilterExpression>=IsNothing(Fields!DeviceRowId.Value)</FilterExpression>
</Filter>
</Filters>
<GroupExpressions>
<GroupExpression>=Fields!DeviceRowId.Value</GroupExpression>
</GroupExpressions>
</Grouping>
</DynamicRows>
</RowGrouping>
</RowGroupings>
<ColumnGroupings>
<ColumnGrouping>
<DynamicColumns>
<ReportItems>
<Textbox Name="lblRuleName">
<ZIndex>2</ZIndex>
<Style></Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<BackgroundColor>Gray</BackgroundColor>
<Color>White</Color>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!RuleName.Value</Value>
</Textbox>
</ReportItems>
<Grouping Name="matrix1_ColumnGroup1">
<Filters>
<Filter>
<Operator>In</Operator>
<FilterValues>
<FilterValue>=Parameters!SelectedRulesList.Value</FilterValue>
</FilterValues>
<FilterExpression>=Fields!RuleSystemName.Value</FilterExpression>
</Filter>
</Filters>
<GroupExpressions>
<GroupExpression>=Fields!RuleDisplayName.Value</GroupExpression>
</GroupExpressions>
</Grouping>
</DynamicColumns>
<Height>0.35in</Height>
</ColumnGrouping>
</ColumnGroupings>
<DataSetName>ReportDataEx</DataSetName>
<Top>2.65in</Top>
<ZIndex>3</ZIndex>
<Visibility>
<Hidden>=IIf((Parameters!SelectedRulesList.Count&gt;1) And (CountRows()&gt;0), false, true)</Hidden>
</Visibility>
<Width>2.85in</Width>
<Corner>
<ReportItems>
<Textbox Name="lblDeviceName">
<ZIndex>3</ZIndex>
<Style></Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<BackgroundColor>Gray</BackgroundColor>
<Color>White</Color>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=First(Fields!ManagedEntityTypeDefaultName.Value, "DeviceTypeDisplayName")</Value>
</Textbox>
</ReportItems>
</Corner>
<Style></Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
<Height>0.6in</Height>
<MatrixRows>
<MatrixRow>
<Height>0.25in</Height>
<MatrixCells>
<MatrixCell>
<ReportItems>
<Textbox Name="txtRuleName">
<Style></Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=IIF(IsNothing(Fields!SampleCount.Value),
"N/A",
Code.FormatNumberByCounterType(IIF(Fields!Averagable.Value="Y",Fields!SumValue.Value/Fields!SampleCount.Value,
Fields!SumValue.Value)
,Fields!Unit.Value,Fields!Averagable.Value)
)</Value>
</Textbox>
</ReportItems>
</MatrixCell>
</MatrixCells>
</MatrixRow>
</MatrixRows>
</Matrix>
<Rectangle Name="recReportDetail">
<ReportItems>
<Textbox Name="txtTargetCounter">
<Left>1.95in</Left>
<Top>0.45in</Top>
<ZIndex>13</ZIndex>
<Style></Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.2in</Height>
<Value>=Count(Fields!DeviceRowId.Value, "SelectedObjectList") &amp; " " &amp; "element(s) found"</Value>
</Textbox>
<Textbox Name="txtType">
<Left>1.95in</Left>
<DataElementOutput>Output</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>0.85in</Top>
<ZIndex>12</ZIndex>
<Style></Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<DataElementStyle>ElementNormal</DataElementStyle>
<CanGrow>true</CanGrow>
<DataElementName>Created</DataElementName>
<Height>0.2in</Height>
<Value>=Code.GetSelectedRules()</Value>
</Textbox>
<Textbox Name="lblSeparator4">
<Left>1.85in</Left>
<DataElementOutput>NoOutput</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>0.85in</Top>
<ZIndex>11</ZIndex>
<Width>0.1in</Width>
<Style></Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.2in</Height>
<Value>:</Value>
</Textbox>
<Textbox Name="lblType">
<Left>0.2in</Left>
<DataElementOutput>NoOutput</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>0.85in</Top>
<ZIndex>10</ZIndex>
<Width>1.65in</Width>
<Style></Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.2in</Height>
<Value>Type</Value>
</Textbox>
<Image Name="imgSeparator">
<Sizing>Fit</Sizing>
<MIMEType/>
<Top>1.15in</Top>
<ZIndex>9</ZIndex>
<Source>External</Source>
<Style/>
<Value>../gradient_portrait.gif</Value>
</Image>
<List Name="lstTargetDevices">
<ReportItems>
<Textbox Name="txtTargetNames">
<Left>1.95in</Left>
<CanShrink>true</CanShrink>
<Style></Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!DeviceDisplayName.Value</Value>
</Textbox>
</ReportItems>
<DataSetName>SelectedObjectList</DataSetName>
<Top>0.65in</Top>
<ZIndex>8</ZIndex>
<Visibility>
<ToggleItem>lbTargetlDeviceList</ToggleItem>
<Hidden>true</Hidden>
</Visibility>
<Style></Style>
<BackgroundColor>Gainsboro</BackgroundColor>
</Style>
<DataInstanceElementOutput>NoOutput</DataInstanceElementOutput>
<Height>0.2in</Height>
</List>
<Textbox Name="lblSeparator3">
<Left>1.85in</Left>
<DataElementOutput>NoOutput</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>0.45in</Top>
<ZIndex>7</ZIndex>
<Width>0.1in</Width>
<Style></Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.2in</Height>
<Value>:</Value>
</Textbox>
<Textbox Name="lbTargetlDeviceList">
<Left>0.2in</Left>
<DataElementOutput>NoOutput</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>0.45in</Top>
<ZIndex>6</ZIndex>
<Width>1.65in</Width>
<Style></Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.2in</Height>
<Value>Target Devices List</Value>
</Textbox>
<Textbox Name="txtGeneratedAt">
<Left>1.95in</Left>
<DataElementOutput>Output</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>0.05in</Top>
<ZIndex>5</ZIndex>
<Style></Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<DataElementStyle>ElementNormal</DataElementStyle>
<CanGrow>true</CanGrow>
<DataElementName>Created</DataElementName>
<Height>0.2in</Height>
<Value>=Code.GetGeneratedAtTime(Parameters!TimeZoneName.Value)</Value>
</Textbox>
<Textbox Name="lblSeparator2">
<Left>1.85in</Left>
<DataElementOutput>NoOutput</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>0.25in</Top>
<ZIndex>4</ZIndex>
<Width>0.1in</Width>
<Style></Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.2in</Height>
<Value>:</Value>
</Textbox>
<Textbox Name="lblSeparator1">
<Left>1.85in</Left>
<DataElementOutput>NoOutput</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>0.05in</Top>
<ZIndex>3</ZIndex>
<Width>0.1in</Width>
<Style></Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.2in</Height>
<Value>:</Value>
</Textbox>
<Textbox Name="lblGeneratedAt">
<Left>0.2in</Left>
<DataElementOutput>NoOutput</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>0.05in</Top>
<ZIndex>2</ZIndex>
<Width>1.65in</Width>
<Style></Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.2in</Height>
<Value>Generated At</Value>
</Textbox>
<Textbox Name="txtReportStartEnd">
<Left>1.95in</Left>
<DataElementOutput>NoOutput</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>0.25in</Top>
<ZIndex>1</ZIndex>
<Style></Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.2in</Height>
<Value>=Code.SelectedDateValue(Parameters!StartDate.Value,Parameters!StartDate_BaseType.Value,Parameters!StartDate_OffsetType.Value,Parameters!StartDate_OffsetValue.Value) &amp;" - "&amp; Code.SelectedDateValue(Parameters!EndDate.Value,Parameters!EndDate_BaseType.Value,Parameters!EndDate_OffsetType.Value,Parameters!EndDate_OffsetValue.Value)</Value>
</Textbox>
<Textbox Name="lblReportStartEnd">
<Left>0.2in</Left>
<DataElementOutput>NoOutput</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>0.25in</Top>
<Width>1.65in</Width>
<Style></Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.2in</Height>
<Value>Report Start - End Time</Value>
</Textbox>
</ReportItems>
<Top>1.256in</Top>
<ZIndex>2</ZIndex>
<Height>1.2in</Height>
</Rectangle>
<Rectangle Name="recTitle">
<ReportItems>
<Textbox Name="lblReportDescription">
<DataElementOutput>NoOutput</DataElementOutput>
<Top>0.3in</Top>
<ZIndex>2</ZIndex>
<Style></Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<VerticalAlign>Middle</VerticalAlign>
<Color>DimGray</Color>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.2in</Height>
<Value>Description</Value>
</Textbox>
<Textbox Name="txtReportTitle">
<Left>0.2in</Left>
<DataElementOutput>Output</DataElementOutput>
<Top>0.05in</Top>
<ZIndex>1</ZIndex>
<Style></Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontWeight>700</FontWeight>
<FontSize>11pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<DataElementStyle>ElementNormal</DataElementStyle>
<CanGrow>true</CanGrow>
<DataElementName>Title</DataElementName>
<Height>0.25in</Height>
<Value>TCP connections - Consolidated summary</Value>
</Textbox>
<Rectangle Name="recDescription">
<ReportItems>
<Textbox Name="txtReportDescription">
<Left>0.2in</Left>
<DataElementOutput>NoOutput</DataElementOutput>
<Style></Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.2in</Height>
<Value>This report provides consolidated summary information about the Open active TCP connections, Open TCP connections, Established TCP connections and Attempt failed TCP connections registered during a defined period for the monitored Network Device. Jalasoft Xian Network Manager collects data for this report (using the Open active TCP connections, Open TCP connections, Established TCP connections and Attempt failed TCP connections rule included in the Jalasoft Xian NM plug-in for Network Devices).</Value>
</Textbox>
</ReportItems>
<Top>0.6in</Top>
<Visibility>
<ToggleItem>lblReportDescription</ToggleItem>
<Hidden>true</Hidden>
</Visibility>
<Style></Style>
<BackgroundColor>Gainsboro</BackgroundColor>
</Style>
</Rectangle>
</ReportItems>
<Top>0.406in</Top>
<ZIndex>1</ZIndex>
<Style></Style>
<BackgroundColor>Gainsboro</BackgroundColor>
</Style>
<Height>0.85in</Height>
</Rectangle>
<Image Name="imgReportHeader">
<Sizing>Fit</Sizing>
<MIMEType/>
<Source>External</Source>
<Style/>
<Height>0.406in</Height>
<Value>ReportHeader.jpg</Value>
</Image>
</ReportItems>
<Height>8.55in</Height>
<Style></Style>
<BorderStyle>
<Bottom>None</Bottom>
</BorderStyle>
<BorderColor>
<Bottom>Black</Bottom>
</BorderColor>
</Style>
</Script></Body>
<rd:ReportID>cb8503b3-8e5b-4da0-88fd-9eee2d0adab3</rd:ReportID>
<LeftMargin>1in</LeftMargin>
<DataSets>
<DataSet Name="DateRange">
<Query>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
<CommandText>SELECT * FROM SC_JSXIO_GetDateRange_F(7)</CommandText>
<DataSourceName>DataWarehouseMain</DataSourceName>
</Query>
<Fields>
<Field Name="BeginDate">
<rd:TypeName>System.DateTime</rd:TypeName>
<DataField>BeginDate</DataField>
</Field>
<Field Name="EndDate">
<rd:TypeName>System.DateTime</rd:TypeName>
<DataField>EndDate</DataField>
</Field>
</Fields>
</DataSet>
<DataSet Name="ReportDataEx">
<Query>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
<CommandText>EXEC SC_JSXIO_GetSummarizedPerfData_SP @StartDate, @EndDate, @DeviceType, @RulesList, @NodeType</CommandText>
<QueryParameters>
<QueryParameter Name="@StartDate">
<Value>=Code.GetNewTimeZone(Code.SelectedDateValue(Parameters!StartDate.Value,Parameters!StartDate_BaseType.Value,Parameters!StartDate_OffsetType.Value,Parameters!StartDate_OffsetValue.Value),Parameters!TimeZoneName.Value)</Value>
</QueryParameter>
<QueryParameter Name="@EndDate">
<Value>=Code.GetNewTimeZone(Code.SelectedDateValue(Parameters!EndDate.Value,Parameters!EndDate_BaseType.Value,Parameters!EndDate_OffsetType.Value,Parameters!EndDate_OffsetValue.Value),Parameters!TimeZoneName.Value)</Value>
</QueryParameter>
<QueryParameter Name="@DeviceType">
<Value>=Parameters!DeviceType.Value</Value>
</QueryParameter>
<QueryParameter Name="@RulesList">
<Value>=Parameters!RulesList.Value</Value>
</QueryParameter>
<QueryParameter Name="@NodeType">
<Value>=Parameters!NodeType.Value</Value>
</QueryParameter>
</QueryParameters>
<DataSourceName>DataWarehouseMain</DataSourceName>
</Query>
<Fields>
<Field Name="DeviceRowId">
<rd:TypeName>System.Int32</rd:TypeName>
<DataField>DeviceRowId</DataField>
</Field>
<Field Name="DeviceDisplayName">
<rd:TypeName>System.String</rd:TypeName>
<DataField>DeviceDisplayName</DataField>
</Field>
<Field Name="RuleSystemName">
<rd:TypeName>System.String</rd:TypeName>
<DataField>RuleSystemName</DataField>
</Field>
<Field Name="RuleDisplayName">
<rd:TypeName>System.String</rd:TypeName>
<DataField>RuleDisplayName</DataField>
</Field>
<Field Name="Unit">
<rd:TypeName>System.String</rd:TypeName>
<DataField>Unit</DataField>
</Field>
<Field Name="Averagable">
<rd:TypeName>System.String</rd:TypeName>
<DataField>Averagable</DataField>
</Field>
<Field Name="RuleName">
<rd:TypeName>System.String</rd:TypeName>
<DataField>RuleName</DataField>
</Field>
<Field Name="MinValue">
<rd:TypeName>System.Double</rd:TypeName>
<DataField>MinValue</DataField>
</Field>
<Field Name="MaxValue">
<rd:TypeName>System.Double</rd:TypeName>
<DataField>MaxValue</DataField>
</Field>
<Field Name="SumValue">
<rd:TypeName>System.Double</rd:TypeName>
<DataField>SumValue</DataField>
</Field>
<Field Name="SampleCount">
<rd:TypeName>System.Int32</rd:TypeName>
<DataField>SampleCount</DataField>
</Field>
</Fields>
</DataSet>
<DataSet Name="SelectedObjectList">
<Query>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
<CommandText>EXEC SC_JSXIO_EnumerateNodes_SP @DeviceType, @DeviceType</CommandText>
<QueryParameters>
<QueryParameter Name="@DeviceType">
<Value>=Parameters!DeviceType.Value</Value>
</QueryParameter>
</QueryParameters>
<DataSourceName>DataWarehouseMain</DataSourceName>
</Query>
<Fields>
<Field Name="DeviceRowId">
<rd:TypeName>System.Int32</rd:TypeName>
<DataField>DeviceRowId</DataField>
</Field>
<Field Name="DeviceDisplayName">
<rd:TypeName>System.String</rd:TypeName>
<DataField>DeviceDisplayName</DataField>
</Field>
<Field Name="NodeRowId">
<rd:TypeName>System.Int32</rd:TypeName>
<DataField>NodeRowId</DataField>
</Field>
<Field Name="NodeDisplayName">
<rd:TypeName>System.String</rd:TypeName>
<DataField>NodeDisplayName</DataField>
</Field>
</Fields>
</DataSet>
<DataSet Name="DeviceTypeDisplayName">
<Query>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
<CommandText>DECLARE @DeviceTypeAux VARCHAR(MAX)
SET @DeviceTypeAux = SUBSTRING(@DeviceType,1,CHARINDEX(';',@DeviceType)-1)
SELECT [ManagedEntityTypeDefaultName] FROM vManagedEntityType WHERE [ManagedEntityTypeSystemName] LIKE @DeviceTypeAux
</CommandText>
<QueryParameters>
<QueryParameter Name="@DeviceType">
<Value>=Parameters!DeviceType.Value</Value>
</QueryParameter>
</QueryParameters>
<DataSourceName>DataWarehouseMain</DataSourceName>
</Query>
<Fields>
<Field Name="ManagedEntityTypeDefaultName">
<rd:TypeName>System.String</rd:TypeName>
<DataField>ManagedEntityTypeDefaultName</DataField>
</Field>
</Fields>
</DataSet>
<DataSet Name="PerfRulesList">
<Query>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
<CommandText>EXEC SC_JSXIO_GetPerfRulesListParameters_SP @RulesList</CommandText>
<QueryParameters>
<QueryParameter Name="@RulesList">
<Value>=Parameters!RulesList.Value</Value>
</QueryParameter>
</QueryParameters>
<DataSourceName>DataWarehouseMain</DataSourceName>
</Query>
<Fields>
<Field Name="RuleSystemName">
<rd:TypeName>System.String</rd:TypeName>
<DataField>RuleSystemName</DataField>
</Field>
<Field Name="RuleDisplayName">
<rd:TypeName>System.String</rd:TypeName>
<DataField>RuleDisplayName</DataField>
</Field>
<Field Name="Unit">
<rd:TypeName>System.String</rd:TypeName>
<DataField>Unit</DataField>
</Field>
<Field Name="Averagable">
<rd:TypeName>System.String</rd:TypeName>
<DataField>Averagable</DataField>
</Field>
<Field Name="RuleName">
<rd:TypeName>System.String</rd:TypeName>
<DataField>RuleName</DataField>
</Field>
</Fields>
</DataSet>
</DataSets>
<Author>Jalasoft Corporation</Author>
<Code><Script>
private function FirstDayMonth() As DateTime
return DateAdd("d",-Today.Day()+1,Today())
end function

private function FirstDayQuarter() As DateTime
return DateAdd("q",DATEDIFF("q",FirstDayYear(),Now()),FirstDayYear())
end function

private function FirstDayYear() As DateTime
return DateAdd("m",-Today.Month()+1,FirstDayMonth())
end function

public function SelectedDateValue(aSpecificDateTime, aBaseType, aOffsetType, aOffsetValue) As DateTime
Dim specificDateTime As DateTime
Dim specificDate() As String
Dim specificTime() As String

specificTime = Split(aSpecificDateTime.ToString()," ")

select case aBaseType
case "Fixed"
return aSpecificDateTime
case "Today"
specificDateTime = Today()
case "Sunday"
specificDateTime = DateAdd("d",1-Weekday(Today()),Today())
case "Monday"
specificDateTime = DateAdd("d",2-Weekday(Today()),Today())
case "Tuesday"
specificDateTime = DateAdd("d",3-Weekday(Today()),Today())
case "Wednesday"
specificDateTime = DateAdd("d",4-Weekday(Today()),Today())
case "Thursday"
specificDateTime = DateAdd("d",5-Weekday(Today()),Today())
case "Friday"
specificDateTime = DateAdd("d",6-Weekday(Today()),Today())
case "Saturday"
specificDateTime = DateAdd("d",7-Weekday(Today()),Today())
case "FirstDayMonth"
specificDateTime = FirstDayMonth()
case "LastDayMonth"
specificDateTime = DateAdd("d",-1,DateAdd("m",1,FirstDayMonth()))
case "FirstDayQuarter"
specificDateTime = FirstDayQuarter()
case "LastDayQuarter"
specificDateTime = DateAdd("d",-1,DateAdd("q",1,FirstDayQuarter()))
case "FirstDayYear"
specificDateTime = FirstDayYear()
case "LastDayYear"
specificDateTime = DateAdd("m",11,DateAdd("d",30,FirstDayYear()))
end select

if (aOffsetType = "None")
specificDate = Split(specificDateTime.ToString()," ")
else
if (aBaseType = "LastDayMonth" AND aOffsetType = "Month")
specificDateTime = DateAdd("d",-1,DateAdd("m",aOffsetValue+1,FirstDayMonth()))
else if (aBaseType = "LastDayQuarter" AND aOffsetType = "Quarter")
specificDateTime = DateAdd("d",-1,DateAdd("q",aOffsetValue+1,FirstDayQuarter()))
else
specificDateTime = DateAdd(DateTimeType(aOffsetType),aOffsetValue,specificDateTime)
end if
specificDate = Split(specificDateTime.ToString()," ")
end if
return CDate(specificDate(0) + " " + specificTime(1) + " " + specificTime(2))
end function

private function DateTimeType(aOffsetType) As String
select case aOffsetType
case "Day"
return "d"
case "Week"
return "ww"
case "Month"
return "m"
case "Quarter"
return "q"
case "Year"
return "yyyy"
end select
end function

public function GetGeneratedAtTime(aTimeZone) As String
Dim utcLocalTimeDiff As String
Dim minutes As Integer
Dim minutesWithSign As Integer

utcLocalTimeDiff = System.TimeZone.CurrentTimeZone.GetUtcOffset(Now).ToString()
minutes = CInt(Mid(utcLocalTimeDiff,2,2))*60 + CInt(Mid(utcLocalTimeDiff,5,2))
minutesWithSign = CInt(Mid(utcLocalTimeDiff,1,1) + CStr(minutes))

return DateAdd("n",(minutesWithSign*(-1)) + GetTimeZoneMinutesDiff(aTimeZone), Now())
end function

public function GetTimeZoneMinutesDiff(aTimeZone) As Integer
Dim minutes As Integer
if (Mid(aTimeZone,5,1) = ")")
return 0
else
minutes = CInt(Mid(aTimeZone,6,2))*60 + CInt(Mid(aTimeZone,9,2))
return CInt(Mid(aTimeZone,5,1) + CStr(minutes))
end if
end function

public function GetNewTimeZone(aSelectedDate, aTimeZone) As DateTime
return DateAdd("n",GetTimeZoneMinutesDiff(aTimeZone)*(-1), aSelectedDate)
end function

public function GetSelectedRules() as string
dim x as Integer
dim limit as integer = Report.Parameters!SelectedRulesList.Count -1
dim RuleList as string

For x = 0 To limit
RuleList = RuleList + Report.Parameters!SelectedRulesList.Label(x) + ", "
Next x
RuleList = RuleList.Remove(RuleList.Length -2)
return RuleList
end function

public function FormatNumber(fieldValue, formatString, unit) as string
if (fieldValue is Nothing)
FormatNumber = "N/A"
else
FormatNumber = Format(fieldValue,formatString) &amp; " " &amp; unit
end if
end function

public function FormatNumberByCounterType(fieldValue, unit, isAveragable) as string
if (fieldValue is Nothing)
FormatNumberByCounterType= "N/A"
else
if (isAveragable= "N")
FormatNumberByCounterType= Format(fieldValue,"#0") &amp; " " &amp; unit
else if (isAveragable = "Y")
FormatNumberByCounterType= Format(fieldValue,"#0.00") &amp; " " &amp; unit
else
FormatNumberByCounterType= Format(fieldValue,"#0") &amp; " " &amp; unit
end if
end if
end function</Script></Code>
<Width>6.5in</Width>
<InteractiveHeight>11in</InteractiveHeight>
<PageFooter>
<ReportItems>
<Textbox Name="lblPageNumber">
<Left>4.7in</Left>
<Top>0.15in</Top>
<ZIndex>1</ZIndex>
<Width>1.7in</Width>
<Style></Style>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<Color>DimGray</Color>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.1875in</Height>
<Value>="Page " &amp; Globals.PageNumber &amp; "/" &amp; Globals.TotalPages</Value>
</Textbox>
<Textbox Name="lblJalasoft">
<Left>0.1in</Left>
<Top>0.15in</Top>
<Action>
<Hyperlink>http://www.jalasoft.com</Hyperlink>
</Action>
<Width>1.1in</Width>
<Style></Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<Color>DimGray</Color>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.1875in</Height>
<Value>Jalasoft Corporation</Value>
</Textbox>
</ReportItems>
<Height>0.45in</Height>
<PrintOnLastPage>true</PrintOnLastPage>
<PrintOnFirstPage>true</PrintOnFirstPage>
</PageFooter>
<TopMargin>1in</TopMargin>
</Report>
</Definition>
</Report>