Res.Microsoft.Windows.BranchCache.Report.SMBCSCBandwidthSavings (ReportResource)

Element properties:

TypeReportResource
File NameMicrosoft.Windows.BranchCache.Report.SMBCSCBandwidthSavings.rdl
AccessibilityPublic

Source Code:

<ReportResource ID="Res.Microsoft.Windows.BranchCache.Report.SMBCSCBandwidthSavings" Accessibility="Public" FileName="Microsoft.Windows.BranchCache.Report.SMBCSCBandwidthSavings.rdl" MIMEType="application/octet-stream" HasNullStream="false"/>

File Content: Microsoft.Windows.BranchCache.Report.SMBCSCBandwidthSavings.rdl



<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<DataSources>
<DataSource Name="DataWarehouseMain">
<rd:DataSourceID>b7cbcfcb-fb7f-4893-92cc-70620775b165</rd:DataSourceID>
<DataSourceReference>Data Warehouse Main</DataSourceReference>
</DataSource>
</DataSources>
<InteractiveHeight>11in</InteractiveHeight>
<ReportParameters>
<ReportParameter Name="StartDate_BaseType">
<DataType>String</DataType>
<Prompt>[Start Date Base]</Prompt>
</ReportParameter>
<ReportParameter Name="StartDate_BaseValue">
<DataType>DateTime</DataType>
<Prompt>[From]</Prompt>
</ReportParameter>
<ReportParameter Name="StartDate_OffsetType">
<DataType>String</DataType>
<Prompt>[Start Date Offset Type]</Prompt>
</ReportParameter>
<ReportParameter Name="StartDate_OffsetValue">
<DataType>Integer</DataType>
<AllowBlank>true</AllowBlank>
<Prompt>[Start Date Offset]</Prompt>
</ReportParameter>
<ReportParameter Name="EndDate_BaseType">
<DataType>String</DataType>
<Prompt>[End Date Base]</Prompt>
</ReportParameter>
<ReportParameter Name="EndDate_BaseValue">
<DataType>DateTime</DataType>
<Prompt>[To]</Prompt>
</ReportParameter>
<ReportParameter Name="EndDate_OffsetType">
<DataType>String</DataType>
<Prompt>[End Date Offset Type]</Prompt>
</ReportParameter>
<ReportParameter Name="EndDate_OffsetValue">
<DataType>Integer</DataType>
<AllowBlank>true</AllowBlank>
<Prompt>[End Date Offset]</Prompt>
</ReportParameter>
<ReportParameter Name="TimeZone">
<DataType>String</DataType>
<Prompt>[Time Zone]</Prompt>
</ReportParameter>
<ReportParameter Name="TimeZoneName">
<DataType>String</DataType>
<Nullable>true</Nullable>
<AllowBlank>true</AllowBlank>
<Prompt>[Time Zone Name]</Prompt>
</ReportParameter>
<ReportParameter Name="ObjectList">
<DataType>String</DataType>
<AllowBlank>true</AllowBlank>
<Prompt>ObjectList</Prompt>
</ReportParameter>
<ReportParameter Name="ManagementGroupId">
<DataType>String</DataType>
<DefaultValue>
<DataSetReference>
<DataSetName>ManagementGroups</DataSetName>
<ValueField>ManagementGroupGUID</ValueField>
</DataSetReference>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>ManagementGroupId</Prompt>
<ValidValues>
<DataSetReference>
<DataSetName>ManagementGroups</DataSetName>
<ValueField>ManagementGroupGUID</ValueField>
<LabelField>ManagementGroupDefaultName</LabelField>
</DataSetReference>
</ValidValues>
<MultiValue>true</MultiValue>
<Hidden>true</Hidden>
</ReportParameter>
<ReportParameter Name="LT_Report">
<DataType>String</DataType>
<DefaultValue>
<DataSetReference>
<DataSetName>LT_Report_Query</DataSetName>
<ValueField>ValueXml</ValueField>
</DataSetReference>
</DefaultValue>
<ValidValues>
<DataSetReference>
<DataSetName>LT_Report_Query</DataSetName>
<ValueField>ValueXml</ValueField>
<LabelField>ValueName</LabelField>
</DataSetReference>
</ValidValues>
<Hidden>true</Hidden>
</ReportParameter>
</ReportParameters>
<rd:DrawGrid>true</rd:DrawGrid>
<InteractiveWidth>8.5in</InteractiveWidth>
<rd:SnapToGrid>true</rd:SnapToGrid>
<RightMargin>1in</RightMargin>
<LeftMargin>1in</LeftMargin>
<PageHeader>
<PrintOnFirstPage>true</PrintOnFirstPage>
<ReportItems>
<Textbox Name="textbox5">
<rd:DefaultName>textbox5</rd:DefaultName>
<Top>0.25in</Top>
<Width>2.5in</Width>
<Style></Style>
<TextAlign>Left</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>4</ZIndex>
<CanGrow>true</CanGrow>
<Left>4in</Left>
<Height>0.25in</Height>
<Value>=Code.FormatDateTime("f", Code.GetReportEndDate())</Value>
</Textbox>
<Textbox Name="textbox4">
<rd:DefaultName>textbox4</rd:DefaultName>
<Top>0.25in</Top>
<Width>0.5in</Width>
<Style></Style>
<FontWeight>700</FontWeight>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>3</ZIndex>
<CanGrow>true</CanGrow>
<Left>3.5in</Left>
<Height>0.25in</Height>
<Value>=Code.GetLocTable("LT_Report").GetString("R.EndDate", "End: ")</Value>
</Textbox>
<Textbox Name="textbox3">
<rd:DefaultName>textbox3</rd:DefaultName>
<Top>0.25in</Top>
<Width>2.5in</Width>
<Style></Style>
<TextAlign>Left</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>2</ZIndex>
<CanGrow>true</CanGrow>
<Left>0.5in</Left>
<Height>0.25in</Height>
<Value>=Code.FormatDateTime("f", Code.GetReportStartDate())</Value>
</Textbox>
<Textbox Name="textbox2">
<rd:DefaultName>textbox2</rd:DefaultName>
<Top>0.25in</Top>
<Width>0.5in</Width>
<Style></Style>
<FontWeight>700</FontWeight>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>1</ZIndex>
<CanGrow>true</CanGrow>
<Height>0.25in</Height>
<Value>=Code.GetLocTable("LT_Report").GetString("R.StartDate", "Start: ")</Value>
</Textbox>
<Textbox Name="textbox1">
<rd:DefaultName>textbox1</rd:DefaultName>
<Width>6.5in</Width>
<Style></Style>
<Color>White</Color>
<BackgroundColor>Black</BackgroundColor>
<BorderStyle>
<Bottom>Solid</Bottom>
</BorderStyle>
<BorderWidth>
<Default>2pt</Default>
</BorderWidth>
<FontSize>12pt</FontSize>
<FontWeight>700</FontWeight>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<CanGrow>true</CanGrow>
<Height>0.25in</Height>
<Value>=Code.GetLocTable("LT_Report").GetString("R.ReportTitle", "BranchCache SMB CSC Bandwidth Usage and Savings Statistics")</Value>
</Textbox>
</ReportItems>
<Height>0.75in</Height>
<PrintOnLastPage>true</PrintOnLastPage>
</PageHeader>
<BottomMargin>1in</BottomMargin>
<rd:ReportID>94704d8d-1f4d-489f-9de4-3349f515d70d</rd:ReportID>
<CodeModules>
<CodeModule>Microsoft.EnterpriseManagement.Reporting.Code, Version=6.0.0.0, Culture=neutral</CodeModule>
</CodeModules>
<DataSets>
<DataSet Name="SMBPerfDataSet">
<Fields>
<Field Name="Path">
<DataField>Path</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="ProtocolName">
<DataField>ProtocolName</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="BytesFromCacheCounterValue">
<DataField>BytesFromCacheCounterValue</DataField>
<rd:TypeName>System.Int64</rd:TypeName>
</Field>
<Field Name="BytesFromServerCounterValue">
<DataField>BytesFromServerCounterValue</DataField>
<rd:TypeName>System.Int64</rd:TypeName>
</Field>
<Field Name="BandwidthSaving">
<DataField>BandwidthSaving</DataField>
<rd:TypeName>System.Double</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>DataWarehouseMain</DataSourceName>
<CommandType>StoredProcedure</CommandType>
<CommandText>prc_Microsoft_Windows_BranchCache_SMBCSC_ComputePerfCounterDataSet</CommandText>
<QueryParameters>
<QueryParameter Name="@StartDate_BaseValue">
<Value>=Code.ToDbDate(Code.GetReportStartDate())</Value>
</QueryParameter>
<QueryParameter Name="@EndDate_BaseValue">
<Value>=Code.ToDbDate(Code.GetReportEndDate())</Value>
</QueryParameter>
<QueryParameter Name="@ObjectList">
<Value>=Parameters!ObjectList.Value</Value>
</QueryParameter>
</QueryParameters>
</Query>
</DataSet>
<DataSet Name="ManagementGroups">
<Fields>
<Field Name="ManagementGroupGUID">
<DataField>ManagementGroupGUID</DataField>
<rd:TypeName>System.Guid</rd:TypeName>
</Field>
<Field Name="ManagementGroupDefaultName">
<DataField>ManagementGroupDefaultName</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>DataWarehouseMain</DataSourceName>
<CommandText>SELECT ManagementGroupGUID, ManagementGroupDefaultName from vManagementGroup</CommandText>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
</DataSet>
<DataSet Name="LT_Report_Query">
<Fields>
<Field Name="ValueXml">
<DataField>XML_F52E2B61-18A1-11d1-B105-00805F49916B</DataField>
</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.Windows.BranchCache.Reports</Value>
</QueryParameter>
<QueryParameter Name="@ReportSystemName">
<Value>Microsoft.Windows.BranchCache.Report.SMBCSCBandwidthSavings</Value>
</QueryParameter>
<QueryParameter Name="@LanguageCode">
<Value>=Code.GetReportLocLanguageCode()</Value>
</QueryParameter>
<QueryParameter Name="@Scope">
<Value>R.%</Value>
</QueryParameter>
</QueryParameters>
</Query>
</DataSet>
</DataSets>
<Code><Script>
Const TimeZoneParameterName As String = "TimeZone"
Const SD_BaseTypeParameterName As String = "StartDate_BaseType"
Const SD_BaseValueParameterName As String = "StartDate_BaseValue"
Const SD_OffsetTypeParameterName As String = "StartDate_OffsetType"
Const SD_OffsetValueParameterName As String = "StartDate_OffsetValue"
Const ED_BaseTypeParameterName As String = "EndDate_BaseType"
Const ED_BaseValueParameterName As String = "EndDate_BaseValue"
Const ED_OffsetTypeParameterName As String = "EndDate_OffsetType"
Const ED_OffsetValueParameterName As String = "EndDate_OffsetValue"
Const IsRelativeTimeSupported As Boolean = True

Const LocTableStringQuery As String = "R/S[@N='{0}']/text()"

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
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, Microsoft.EnterpriseManagement.Reporting.ParameterProcessor.RelativeTimeType.Regular.ToString())
End If
return ReportStartDate
End Function

Public Function GetReportEndDate() As DateTime
If (ReportEndDate = DateTime.MinValue) 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, Microsoft.EnterpriseManagement.Reporting.ParameterProcessor.RelativeTimeType.Regular.ToString())
End If
return ReportEndDate
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

</Script></Code>
<Width>6.5in</Width>
<Body><Script>
<ReportItems>
<Textbox Name="textbox10">
<rd:DefaultName>textbox10</rd:DefaultName>
<Width>6.5in</Width>
<Style></Style>
<Color>White</Color>
<BackgroundColor>Gray</BackgroundColor>
<FontSize>12pt</FontSize>
<FontWeight>700</FontWeight>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>12</ZIndex>
<CanGrow>true</CanGrow>
<Height>0.25in</Height>
<Value>=Code.GetLocTable("LT_Report").GetString("R.TotalBandwidthSaving", "Total Bandwidth Saving - CSC Bytes from Cache vs. Bytes from Server")</Value>
</Textbox>
<Textbox Name="textbox8">
<rd:DefaultName>textbox8</rd:DefaultName>
<Top>3.75in</Top>
<Width>6.5in</Width>
<Style></Style>
<Color>White</Color>
<BackgroundColor>Gray</BackgroundColor>
<FontSize>12pt</FontSize>
<FontWeight>700</FontWeight>
<TextAlign>Left</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>11</ZIndex>
<CanGrow>true</CanGrow>
<Height>0.25in</Height>
<Value>=Code.GetLocTable("LT_Report").GetString("R.TotalTraffic", "Total SMB Client Side Caching Traffic &amp; Bandwidth Saving")</Value>
</Textbox>
<Textbox Name="textbox12">
<rd:DefaultName>textbox12</rd:DefaultName>
<Top>4.75in</Top>
<Width>6.5in</Width>
<Style></Style>
<Color>White</Color>
<BackgroundColor>Gray</BackgroundColor>
<FontSize>12pt</FontSize>
<FontWeight>700</FontWeight>
<TextAlign>Left</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>10</ZIndex>
<CanGrow>true</CanGrow>
<Height>0.25in</Height>
<Value>=Code.GetLocTable("LT_Report").GetString("R.TotalPerSystemTraffic", "Per-System SMB CSC Traffic")</Value>
</Textbox>
<Textbox Name="textbox26">
<rd:DefaultName>textbox26</rd:DefaultName>
<Top>4.25in</Top>
<Width>1.5in</Width>
<Style></Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<Format>P2</Format>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>9</ZIndex>
<CanGrow>true</CanGrow>
<Left>5in</Left>
<Height>0.25in</Height>
<Value>=iif(Sum(Fields!BytesFromCacheCounterValue.Value, "SMBPerfDataSet") &lt;&gt; 0, (Sum(Fields!BytesFromCacheCounterValue.Value, "SMBPerfDataSet")/(Sum(Fields!BytesFromCacheCounterValue.Value, "SMBPerfDataSet")+Sum(Fields!BytesFromServerCounterValue.Value, "SMBPerfDataSet"))), 0)</Value>
</Textbox>
<Chart Name="Total_Data">
<Legend>
<Visible>true</Visible>
<Style></Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Position>RightCenter</Position>
</Legend>
<CategoryAxis>
<Axis>
<Title />
<MajorGridLines>
<Style></Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MajorGridLines>
<MinorGridLines>
<Style></Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MinorGridLines>
<MajorTickMarks>Outside</MajorTickMarks>
<Min>0</Min>
<Visible>true</Visible>
</Axis>
</CategoryAxis>
<ZIndex>8</ZIndex>
<DataSetName>SMBPerfDataSet</DataSetName>
<PlotArea>
<Style></Style>
<BackgroundColor>LightGrey</BackgroundColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</PlotArea>
<ThreeDProperties>
<Rotation>30</Rotation>
<Inclination>30</Inclination>
<Shading>Simple</Shading>
<WallThickness>50</WallThickness>
</ThreeDProperties>
<PointWidth>0</PointWidth>
<SeriesGroupings>
<SeriesGrouping>
<StaticSeries>
<StaticMember>
<Label>=Code.GetLocTable("LT_Report").GetString("R.BytesFromServer", "Bytes From Server")</Label>
</StaticMember>
<StaticMember>
<Label>=Code.GetLocTable("LT_Report").GetString("R.BytesFromCache", "Bytes From Cache")</Label>
</StaticMember>
</StaticSeries>
</SeriesGrouping>
</SeriesGroupings>
<Top>0.25in</Top>
<Subtype>Plain</Subtype>
<ValueAxis>
<Axis>
<Title />
<MajorGridLines>
<ShowGridLines>true</ShowGridLines>
<Style></Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MajorGridLines>
<MinorGridLines>
<Style></Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MinorGridLines>
<MajorTickMarks>Outside</MajorTickMarks>
<Min>0</Min>
<Margin>true</Margin>
<Visible>true</Visible>
<Scalar>true</Scalar>
</Axis>
</ValueAxis>
<Type>Pie</Type>
<Width>6.5in</Width>
<Palette>Default</Palette>
<ChartData>
<ChartSeries>
<DataPoints>
<DataPoint>
<DataValues>
<DataValue>
<Value>=iif((Sum(Fields!BytesFromCacheCounterValue.Value, "SMBPerfDataSet")+Sum(Fields!BytesFromServerCounterValue.Value, "SMBPerfDataSet")) &lt;&gt; 0, Sum(Fields!BytesFromServerCounterValue.Value, "SMBPerfDataSet")/(Sum(Fields!BytesFromServerCounterValue.Value, "SMBPerfDataSet") + Sum(Fields!BytesFromCacheCounterValue.Value, "SMBPerfDataSet")), 0)</Value>
</DataValue>
</DataValues>
<DataLabel>
<Style></Style>
<Format>P2</Format>
</Style>
<Value>=iif((Sum(Fields!BytesFromServerCounterValue.Value, "SMBPerfDataSet")+Sum(Fields!BytesFromCacheCounterValue.Value, "SMBPerfDataSet")) &lt;&gt; 0, Sum(Fields!BytesFromServerCounterValue.Value, "SMBPerfDataSet")/(Sum(Fields!BytesFromServerCounterValue.Value, "SMBPerfDataSet") + Sum(Fields!BytesFromCacheCounterValue.Value, "SMBPerfDataSet")), 0)</Value>
<Visible>true</Visible>
</DataLabel>
<Style></Style>
<BackgroundColor>DarkOrange</BackgroundColor>
</Style>
<Marker>
<Size>6pt</Size>
</Marker>
</DataPoint>
</DataPoints>
</ChartSeries>
<ChartSeries>
<DataPoints>
<DataPoint>
<DataValues>
<DataValue>
<Value>=iif((Sum(Fields!BytesFromCacheCounterValue.Value, "SMBPerfDataSet")+Sum(Fields!BytesFromServerCounterValue.Value, "SMBPerfDataSet")) &lt;&gt; 0, Sum(Fields!BytesFromCacheCounterValue.Value, "SMBPerfDataSet")/(Sum(Fields!BytesFromServerCounterValue.Value, "SMBPerfDataSet") + Sum(Fields!BytesFromCacheCounterValue.Value, "SMBPerfDataSet")), 0)</Value>
</DataValue>
</DataValues>
<DataLabel>
<Style></Style>
<Format>P2</Format>
</Style>
<Value>=iif((Sum(Fields!BytesFromCacheCounterValue.Value, "SMBPerfDataSet")+Sum(Fields!BytesFromServerCounterValue.Value, "SMBPerfDataSet")) &lt;&gt; 0, Sum(Fields!BytesFromCacheCounterValue.Value, "SMBPerfDataSet")/(Sum(Fields!BytesFromServerCounterValue.Value, "SMBPerfDataSet") + Sum(Fields!BytesFromCacheCounterValue.Value, "SMBPerfDataSet")), 0)</Value>
<Visible>true</Visible>
</DataLabel>
<Style></Style>
<BackgroundColor>RoyalBlue</BackgroundColor>
</Style>
<Marker>
<Size>6pt</Size>
</Marker>
</DataPoint>
</DataPoints>
</ChartSeries>
</ChartData>
<Style></Style>
<BackgroundColor>White</BackgroundColor>
</Style>
<Title>
<Style></Style>
<Color>Teal</Color>
<FontSize>12pt</FontSize>
<FontWeight>700</FontWeight>
</Style>
</Title>
<Height>3.25in</Height>
</Chart>
<Textbox Name="textbox25">
<rd:DefaultName>textbox25</rd:DefaultName>
<Top>4in</Top>
<Width>1.5in</Width>
<Style></Style>
<BackgroundColor>LightBlue</BackgroundColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontWeight>700</FontWeight>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>7</ZIndex>
<CanGrow>true</CanGrow>
<Left>5in</Left>
<Height>0.25in</Height>
<Value>=Code.GetLocTable("LT_Report").GetString("R.BandwidthSaving", "Bandwidth Savings")</Value>
</Textbox>
<Textbox Name="textbox24">
<rd:DefaultName>textbox24</rd:DefaultName>
<Top>4.25in</Top>
<Width>2in</Width>
<Style></Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<Format>N0</Format>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>6</ZIndex>
<CanGrow>true</CanGrow>
<Left>3in</Left>
<Height>0.25in</Height>
<Value>=Sum(Fields!BytesFromCacheCounterValue.Value, "SMBPerfDataSet") + Sum(Fields!BytesFromServerCounterValue.Value, "SMBPerfDataSet")</Value>
</Textbox>
<Textbox Name="textbox23">
<rd:DefaultName>textbox23</rd:DefaultName>
<Top>4in</Top>
<Width>2in</Width>
<Style></Style>
<BackgroundColor>LightBlue</BackgroundColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontWeight>700</FontWeight>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>5</ZIndex>
<CanGrow>true</CanGrow>
<Left>3in</Left>
<Height>0.25in</Height>
<Value>=Code.GetLocTable("LT_Report").GetString("R.TotalDataTransmitted", "Total Data Transmitted")</Value>
</Textbox>
<Textbox Name="textbox22">
<rd:DefaultName>textbox22</rd:DefaultName>
<Top>4.25in</Top>
<Width>1.5in</Width>
<Style></Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<Format>N0</Format>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>4</ZIndex>
<CanGrow>true</CanGrow>
<Left>1.5in</Left>
<Height>0.25in</Height>
<Value>=Sum(Fields!BytesFromServerCounterValue.Value, "SMBPerfDataSet")</Value>
</Textbox>
<Textbox Name="textbox21">
<rd:DefaultName>textbox21</rd:DefaultName>
<Top>4in</Top>
<Width>1.5in</Width>
<Style></Style>
<BackgroundColor>LightBlue</BackgroundColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontWeight>700</FontWeight>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>3</ZIndex>
<CanGrow>true</CanGrow>
<Left>1.5in</Left>
<Height>0.25in</Height>
<Value>=Code.GetLocTable("LT_Report").GetString("R.BytesFromServer", "Bytes From Server")</Value>
</Textbox>
<Textbox Name="textbox20">
<rd:DefaultName>textbox20</rd:DefaultName>
<Top>4.25in</Top>
<Width>1.5in</Width>
<Style></Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<Format>N0</Format>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>2</ZIndex>
<CanGrow>true</CanGrow>
<Height>0.25in</Height>
<Value>=Sum(Fields!BytesFromCacheCounterValue.Value, "SMBPerfDataSet")</Value>
</Textbox>
<Textbox Name="textbox16">
<rd:DefaultName>textbox16</rd:DefaultName>
<Top>4in</Top>
<Width>1.5in</Width>
<Style></Style>
<BackgroundColor>LightBlue</BackgroundColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontWeight>700</FontWeight>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>1</ZIndex>
<CanGrow>true</CanGrow>
<Height>0.25in</Height>
<Value>=Code.GetLocTable("LT_Report").GetString("R.BytesFromCache", "Bytes From Cache")</Value>
</Textbox>
<Table Name="table2">
<DataSetName>SMBPerfDataSet</DataSetName>
<Top>5in</Top>
<Width>6.5in</Width>
<Details>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="Path_1">
<rd:DefaultName>Path_1</rd:DefaultName>
<Style></Style>
<BackgroundColor>LightGrey</BackgroundColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontSize>9pt</FontSize>
<FontWeight>700</FontWeight>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>3</ZIndex>
<CanGrow>true</CanGrow>
<Value>=First(Fields!Path.Value)</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="BytesFromCacheCounterValue">
<rd:DefaultName>BytesFromCacheCounterValue</rd:DefaultName>
<Style></Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<Format>N0</Format>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>2</ZIndex>
<CanGrow>true</CanGrow>
<Value>=Sum(Fields!BytesFromCacheCounterValue.Value)</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="BytesFromServerCounterValue">
<rd:DefaultName>BytesFromServerCounterValue</rd:DefaultName>
<Style></Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<Format>N0</Format>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>1</ZIndex>
<CanGrow>true</CanGrow>
<Value>=Sum(Fields!BytesFromServerCounterValue.Value)</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="BandwidthSaving">
<rd:DefaultName>BandwidthSaving</rd:DefaultName>
<Style></Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<Format>P2</Format>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<CanGrow>true</CanGrow>
<Value>=Sum(Fields!BandwidthSaving.Value)/100</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.25in</Height>
</TableRow>
</TableRows>
<Grouping Name="table2_Details_Group">
<GroupExpressions>
<GroupExpression>=Fields!Path.Value</GroupExpression>
</GroupExpressions>
</Grouping>
</Details>
<Style></Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Header>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox6">
<rd:DefaultName>textbox6</rd:DefaultName>
<Style></Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>7</ZIndex>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox7">
<rd:DefaultName>textbox7</rd:DefaultName>
<Style></Style>
<BackgroundColor>LightBlue</BackgroundColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontWeight>700</FontWeight>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>6</ZIndex>
<CanGrow>true</CanGrow>
<Value>=Code.GetLocTable("LT_Report").GetString("R.BytesFromCache", "Bytes From Cache")</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox9">
<rd:DefaultName>textbox9</rd:DefaultName>
<Style></Style>
<BackgroundColor>LightBlue</BackgroundColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontWeight>700</FontWeight>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>5</ZIndex>
<CanGrow>true</CanGrow>
<Value>=Code.GetLocTable("LT_Report").GetString("R.BytesFromServer", "Bytes From Server") </Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox11">
<rd:DefaultName>textbox11</rd:DefaultName>
<Style></Style>
<BackgroundColor>LightBlue</BackgroundColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontWeight>700</FontWeight>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>4</ZIndex>
<CanGrow>true</CanGrow>
<Value>=Code.GetLocTable("LT_Report").GetString("R.BandwidthSaving", "Bandwidth Savings")</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.25in</Height>
</TableRow>
</TableRows>
</Header>
<TableColumns>
<TableColumn>
<Width>2in</Width>
</TableColumn>
<TableColumn>
<Width>1.5in</Width>
</TableColumn>
<TableColumn>
<Width>1.5in</Width>
</TableColumn>
<TableColumn>
<Width>1.5in</Width>
</TableColumn>
</TableColumns>
<Height>0.5in</Height>
</Table>
</ReportItems>
<Height>9in</Height>
</Script></Body>
<Language>en-US</Language>
<TopMargin>1in</TopMargin>
</Report>