Provance.ITAssetManagement.Report.HardwareAssetManagementDashboard.ReportRdl (ReportResource)

Element properties:

Type	ReportResource
File Name	Hardware Asset Management Dashboard.rdl
Accessibility	Public

Source Code:

<ReportResource ID="Provance.ITAssetManagement.Report.HardwareAssetManagementDashboard.ReportRdl" Accessibility="Public" FileName="Hardware Asset Management Dashboard.rdl" HasNullStream="false" MIMEType="application/octet-stream"/>

File Content: Hardware Asset Management Dashboard.rdl

<?xml version="1.0" encoding="utf-8"?>


<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">


  <Body><Script>


    <ReportItems>


      <Chart Name="Chart2">


        <ChartCategoryHierarchy>


          <ChartMembers>


            <ChartMember>


              <Group Name="Chart2_CategoryGroup1">


                <GroupExpressions>


                  <GroupExpression>=Fields!DisplayName.Value</GroupExpression>


                </GroupExpressions>


              </Group>


              <SortExpressions>


                <SortExpression>


                  <Value>=Fields!DisplayName.Value</Value>


                </SortExpression>


              </SortExpressions>


              <Label>=Fields!DisplayName.Value</Label>


            </ChartMember>


          </ChartMembers>


        </ChartCategoryHierarchy>


        <ChartSeriesHierarchy>


          <ChartMembers>


            <ChartMember>


              <Group Name="Chart2_SeriesGroup1">


                <GroupExpressions>


                  <GroupExpression>=Fields!AssetCount.Value</GroupExpression>


                </GroupExpressions>


              </Group>


              <SortExpressions>


                <SortExpression>


                  <Value>=Fields!DisplayName.Value</Value>


                </SortExpression>


              </SortExpressions>


              <Label>=Fields!AssetCount.Value</Label>


            </ChartMember>


          </ChartMembers>


        </ChartSeriesHierarchy>


        <ChartData>


          <ChartSeriesCollection>


            <ChartSeries Name="AssetCount">


              <ChartDataPoints>


                <ChartDataPoint>


                  <ChartDataPointValues>


                    <X>=Fields!DisplayName.Value</X>


                    <Y>=Sum(Fields!AssetCount.Value)</Y>


                  </ChartDataPointValues>


                  <ChartDataLabel>


                    <Style /></Style>


                    <Label>=FormatPercent(Fields!AssetCount.Value/Fields!TotalAssetCount.Value,0)</Label>


                    <Visible>true</Visible>


                  </ChartDataLabel>


                  <ToolTip>=Fields!AssetCount.Value &amp; " " &amp; 


	Code.GetLocTable("LT_Report").GetString("LabelAssetsAt", "[Assets(s) at]") &amp; " " &amp; 


	Fields!DisplayName.Value</ToolTip>


                  <ActionInfo>


                    <Actions>


                      <Action>


                        <Drillthrough>


                          <ReportName>Provance.ITAssetManagement.Report.HardwareAssetDetailReport</ReportName>


                          <Parameters>


                            <Parameter Name="LocationId">


                              <Value>=Fields!LocationDimKey.Value</Value>


                            </Parameter>


                          </Parameters>


                        </Drillthrough>


                      </Action>


                    </Actions>


                  </ActionInfo>


                  <Style /></Style>


                  <ChartMarker>


                    <Style /></Style>


                  </ChartMarker>


                  <DataElementOutput>Output</DataElementOutput>


                  <ChartItemInLegend>


                    <LegendText>=IIF(Fields!DisplayName.Value &lt;&gt; "Unknown", Fields!DisplayName.Value,


	Code.GetLocTable("LT_Report").GetString("LabelUnknown", "[Unknown]"))</LegendText>


                  </ChartItemInLegend>


                </ChartDataPoint>


              </ChartDataPoints>


              <Type>Shape</Type>


              <Style /></Style>


              <ChartEmptyPoints>


                <Style /></Style>


                <ChartMarker>


                  <Style /></Style>


                </ChartMarker>


                <ChartDataLabel>


                  <Style /></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>


                <ChartAxisScaleBreak>


                  <Style /></Style>


                </ChartAxisScaleBreak>


              </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>


                <ChartAxisScaleBreak>


                  <Style /></Style>


                </ChartAxisScaleBreak>


              </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>


                <ChartAxisScaleBreak>


                  <Style /></Style>


                </ChartAxisScaleBreak>


              </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>


                <ChartAxisScaleBreak>


                  <Style /></Style>


                </ChartAxisScaleBreak>


              </ChartAxis>


            </ChartValueAxes>


            <ChartThreeDProperties>


              <Enabled>true</Enabled>


            </ChartThreeDProperties>


            <Style></Style>


              <BackgroundGradientType>None</BackgroundGradientType>


            </Style>


          </ChartArea>


        </ChartAreas>


        <ChartLegends>


          <ChartLegend Name="Default">


            <Style></Style>


              <BackgroundGradientType>None</BackgroundGradientType>


              <FontSize>8pt</FontSize>


            </Style>


            <Position>TopCenter</Position>


            <ChartLegendTitle>


              <Caption />


              <Style></Style>


                <FontSize>8pt</FontSize>


                <FontWeight>Bold</FontWeight>


                <TextAlign>Center</TextAlign>


              </Style>


            </ChartLegendTitle>


            <HeaderSeparatorColor>Black</HeaderSeparatorColor>


            <ColumnSeparatorColor>Black</ColumnSeparatorColor>


          </ChartLegend>


        </ChartLegends>


        <ChartTitles>


          <ChartTitle Name="Default">


            <Caption>=Code.GetLocTable("LT_Report").GetString("ElementAssetByLocation", "[Assets By Location]")</Caption>


            <Style></Style>


              <BackgroundGradientType>None</BackgroundGradientType>


              <FontWeight>Bold</FontWeight>


              <TextAlign>General</TextAlign>


              <VerticalAlign>Top</VerticalAlign>


            </Style>


            <Position>TopLeft</Position>


          </ChartTitle>


        </ChartTitles>


        <Palette>BrightPastel</Palette>


        <ChartBorderSkin>


          <Style></Style>


            <BackgroundColor>Gray</BackgroundColor>


            <BackgroundGradientType>None</BackgroundGradientType>


            <Color>White</Color>


          </Style>


        </ChartBorderSkin>


        <ChartNoDataMessage Name="NoDataMessage">


          <Caption>=Code.GetLocTable("LT_Report").GetString("A", "[No Data Available]")</Caption>


          <Style></Style>


            <BackgroundGradientType>None</BackgroundGradientType>


            <TextAlign>General</TextAlign>


            <VerticalAlign>Top</VerticalAlign>


          </Style>


        </ChartNoDataMessage>


        <DataSetName>AssetsByLocation</DataSetName>


        <Height>2.96875in</Height>


        <Width>2.4in</Width>


        <Style></Style>


          <Border>


            <Color>LightGrey</Color>


            <Style></Style>Solid</Style>


          </Border>


          <BackgroundColor>White</BackgroundColor>


          <BackgroundGradientType>None</BackgroundGradientType>


        </Style>


      </Chart>


      <Chart Name="Chart3">


        <ChartCategoryHierarchy>


          <ChartMembers>


            <ChartMember>


              <Group Name="Chart3_CategoryGroup1">


                <GroupExpressions>


                  <GroupExpression>=Fields!DisplayName.Value</GroupExpression>


                </GroupExpressions>


              </Group>


              <SortExpressions>


                <SortExpression>


                  <Value>=Fields!DisplayName.Value</Value>


                </SortExpression>


              </SortExpressions>


              <Label>=Fields!DisplayName.Value</Label>


            </ChartMember>


          </ChartMembers>


        </ChartCategoryHierarchy>


        <ChartSeriesHierarchy>


          <ChartMembers>


            <ChartMember>


              <Group Name="Chart3_SeriesGroup1">


                <GroupExpressions>


                  <GroupExpression>=Fields!AssetCount.Value</GroupExpression>


                </GroupExpressions>


              </Group>


              <Label>=Fields!AssetCount.Value</Label>


            </ChartMember>


          </ChartMembers>


        </ChartSeriesHierarchy>


        <ChartData>


          <ChartSeriesCollection>


            <ChartSeries Name="AssetCount">


              <ChartDataPoints>


                <ChartDataPoint>


                  <ChartDataPointValues>


                    <X>=Fields!DisplayName.Value</X>


                    <Y>=Sum(Fields!AssetCount.Value)</Y>


                  </ChartDataPointValues>


                  <ChartDataLabel>


                    <Style /></Style>


                    <Label>=FormatPercent(Fields!AssetCount.Value/Fields!TotalAssetCount.Value,0)</Label>


                    <Visible>true</Visible>


                  </ChartDataLabel>


                  <ToolTip>=Fields!AssetCount.Value &amp; " " &amp; 


	Code.GetLocTable("LT_Report").GetString("LabelAssetsAt", "[Assets(s) at]") &amp; " " &amp; 


	Fields!DisplayName.Value</ToolTip>


                  <ActionInfo>


                    <Actions>


                      <Action>


                        <Drillthrough>


                          <ReportName>Provance.ITAssetManagement.Report.HardwareAssetDetailReport</ReportName>


                          <Parameters>


                            <Parameter Name="CostCenterId">


                              <Value>=Fields!CostCenterDimKey.Value</Value>


                            </Parameter>


                          </Parameters>


                        </Drillthrough>


                      </Action>


                    </Actions>


                  </ActionInfo>


                  <Style /></Style>


                  <ChartMarker>


                    <Style /></Style>


                  </ChartMarker>


                  <DataElementOutput>Output</DataElementOutput>


                  <ChartItemInLegend>


                    <LegendText>=IIF(Fields!DisplayName.Value &lt;&gt; "Unknown", Fields!DisplayName.Value,


	Code.GetLocTable("LT_Report").GetString("LabelUnknown", "[Unknown]"))</LegendText>


                  </ChartItemInLegend>


                </ChartDataPoint>


              </ChartDataPoints>


              <Type>Shape</Type>


              <Style /></Style>


              <ChartEmptyPoints>


                <Style /></Style>


                <ChartMarker>


                  <Style /></Style>


                </ChartMarker>


                <ChartDataLabel>


                  <Style /></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>


                <ChartAxisScaleBreak>


                  <Style /></Style>


                </ChartAxisScaleBreak>


              </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>


                <ChartAxisScaleBreak>


                  <Style /></Style>


                </ChartAxisScaleBreak>


              </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>


                <ChartAxisScaleBreak>


                  <Style /></Style>


                </ChartAxisScaleBreak>


              </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>


                <ChartAxisScaleBreak>


                  <Style /></Style>


                </ChartAxisScaleBreak>


              </ChartAxis>


            </ChartValueAxes>


            <ChartThreeDProperties>


              <Enabled>true</Enabled>


            </ChartThreeDProperties>


            <Style></Style>


              <BackgroundGradientType>None</BackgroundGradientType>


            </Style>


          </ChartArea>


        </ChartAreas>


        <ChartLegends>


          <ChartLegend Name="Default">


            <Style></Style>


              <BackgroundGradientType>None</BackgroundGradientType>


              <FontSize>8pt</FontSize>


            </Style>


            <Position>TopCenter</Position>


            <ChartLegendTitle>


              <Caption />


              <Style></Style>


                <FontSize>8pt</FontSize>


                <FontWeight>Bold</FontWeight>


                <TextAlign>Center</TextAlign>


              </Style>


            </ChartLegendTitle>


            <HeaderSeparatorColor>Black</HeaderSeparatorColor>


            <ColumnSeparatorColor>Black</ColumnSeparatorColor>


          </ChartLegend>


        </ChartLegends>


        <ChartTitles>


          <ChartTitle Name="Default">


            <Caption>=Code.GetLocTable("LT_Report").GetString("ElementAssetByCostCenter", "[Assets By Cost Center]")</Caption>


            <Style></Style>


              <BackgroundGradientType>None</BackgroundGradientType>


              <FontWeight>Bold</FontWeight>


              <TextAlign>General</TextAlign>


              <VerticalAlign>Top</VerticalAlign>


            </Style>


            <Position>TopLeft</Position>


          </ChartTitle>


        </ChartTitles>


        <Palette>BrightPastel</Palette>


        <ChartBorderSkin>


          <Style></Style>


            <BackgroundColor>Gray</BackgroundColor>


            <BackgroundGradientType>None</BackgroundGradientType>


            <Color>White</Color>


          </Style>


        </ChartBorderSkin>


        <ChartNoDataMessage Name="NoDataMessage">


          <Caption>=Code.GetLocTable("LT_Report").GetString("A", "[No Data Available]")</Caption>


          <Style></Style>


            <BackgroundGradientType>None</BackgroundGradientType>


            <TextAlign>General</TextAlign>


            <VerticalAlign>Top</VerticalAlign>


          </Style>


        </ChartNoDataMessage>


        <DataSetName>AssetByCostCenter</DataSetName>


        <Left>2.46944in</Left>


        <Height>2.96874in</Height>


        <Width>2.4in</Width>


        <ZIndex>1</ZIndex>


        <Style></Style>


          <Border>


            <Color>LightGrey</Color>


            <Style></Style>Solid</Style>


          </Border>


          <BackgroundColor>White</BackgroundColor>


          <BackgroundGradientType>None</BackgroundGradientType>


        </Style>


      </Chart>


      <Chart Name="Chart4">


        <ChartCategoryHierarchy>


          <ChartMembers>


            <ChartMember>


              <Group Name="Chart4_CategoryGroup1">


                <GroupExpressions>


                  <GroupExpression>=Fields!DisplayName.Value</GroupExpression>


                </GroupExpressions>


              </Group>


              <SortExpressions>


                <SortExpression>


                  <Value>=Fields!DisplayName.Value</Value>


                </SortExpression>


              </SortExpressions>


              <Label>=Fields!DisplayName.Value</Label>


            </ChartMember>


          </ChartMembers>


        </ChartCategoryHierarchy>


        <ChartSeriesHierarchy>


          <ChartMembers>


            <ChartMember>


              <Group Name="Chart4_SeriesGroup1">


                <GroupExpressions>


                  <GroupExpression>=Fields!AssetCount.Value</GroupExpression>


                </GroupExpressions>


              </Group>


              <Label>=Fields!AssetCount.Value</Label>


            </ChartMember>


          </ChartMembers>


        </ChartSeriesHierarchy>


        <ChartData>


          <ChartSeriesCollection>


            <ChartSeries Name="AssetCount">


              <ChartDataPoints>


                <ChartDataPoint>


                  <ChartDataPointValues>


                    <X>=Fields!DisplayName.Value</X>


                    <Y>=Sum(Fields!AssetCount.Value)</Y>


                  </ChartDataPointValues>


                  <ChartDataLabel>


                    <Style /></Style>


                    <Label>=FormatPercent(Fields!AssetCount.Value/Fields!TotalAssetCount.Value,0)</Label>


                    <Visible>true</Visible>


                  </ChartDataLabel>


                  <ToolTip>=Fields!AssetCount.Value &amp; " " &amp; 


	Code.GetLocTable("LT_Report").GetString("LabelAssetsAt", "[Assets(s) at]") &amp; " " &amp; 


	Fields!DisplayName.Value</ToolTip>


                  <ActionInfo>


                    <Actions>


                      <Action>


                        <Drillthrough>


                          <ReportName>Provance.ITAssetManagement.Report.HardwareAssetDetailReport</ReportName>


                          <Parameters>


                            <Parameter Name="OrganizationId">


                              <Value>=Fields!OrganizationDimKey.Value</Value>


                            </Parameter>


                          </Parameters>


                        </Drillthrough>


                      </Action>


                    </Actions>


                  </ActionInfo>


                  <Style /></Style>


                  <ChartMarker>


                    <Style /></Style>


                  </ChartMarker>


                  <DataElementOutput>Output</DataElementOutput>


                  <ChartItemInLegend>


                    <LegendText>=IIF(Fields!DisplayName.Value &lt;&gt; "Unknown", Fields!DisplayName.Value,


	Code.GetLocTable("LT_Report").GetString("LabelUnknown", "[Unknown]"))</LegendText>


                  </ChartItemInLegend>


                </ChartDataPoint>


              </ChartDataPoints>


              <Type>Shape</Type>


              <Style /></Style>


              <ChartEmptyPoints>


                <Style /></Style>


                <ChartMarker>


                  <Style /></Style>


                </ChartMarker>


                <ChartDataLabel>


                  <Style /></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>


                <ChartAxisScaleBreak>


                  <Style /></Style>


                </ChartAxisScaleBreak>


              </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>


                <ChartAxisScaleBreak>


                  <Style /></Style>


                </ChartAxisScaleBreak>


              </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>


                <ChartAxisScaleBreak>


                  <Style /></Style>


                </ChartAxisScaleBreak>


              </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>


                <ChartAxisScaleBreak>


                  <Style /></Style>


                </ChartAxisScaleBreak>


              </ChartAxis>


            </ChartValueAxes>


            <ChartThreeDProperties>


              <Enabled>true</Enabled>


            </ChartThreeDProperties>


            <Style></Style>


              <BackgroundGradientType>None</BackgroundGradientType>


            </Style>


          </ChartArea>


        </ChartAreas>


        <ChartLegends>


          <ChartLegend Name="Default">


            <Style></Style>


              <BackgroundGradientType>None</BackgroundGradientType>


              <FontSize>8pt</FontSize>


            </Style>


            <Position>TopCenter</Position>


            <ChartLegendTitle>


              <Caption />


              <Style></Style>


                <FontSize>8pt</FontSize>


                <FontWeight>Bold</FontWeight>


                <TextAlign>Center</TextAlign>


              </Style>


            </ChartLegendTitle>


            <HeaderSeparatorColor>Black</HeaderSeparatorColor>


            <ColumnSeparatorColor>Black</ColumnSeparatorColor>


          </ChartLegend>


        </ChartLegends>


        <ChartTitles>


          <ChartTitle Name="Default">


            <Caption>=Code.GetLocTable("LT_Report").GetString("ElementAssetByOrganization", "[Assets By Organization]")</Caption>


            <Style></Style>


              <BackgroundGradientType>None</BackgroundGradientType>


              <FontWeight>Bold</FontWeight>


              <TextAlign>General</TextAlign>


              <VerticalAlign>Top</VerticalAlign>


            </Style>


            <Position>TopLeft</Position>


          </ChartTitle>


        </ChartTitles>


        <Palette>BrightPastel</Palette>


        <ChartBorderSkin>


          <Style></Style>


            <BackgroundColor>Gray</BackgroundColor>


            <BackgroundGradientType>None</BackgroundGradientType>


            <Color>White</Color>


          </Style>


        </ChartBorderSkin>


        <ChartNoDataMessage Name="NoDataMessage">


          <Caption>=Code.GetLocTable("LT_Report").GetString("A", "[No Data Available]")</Caption>


          <Style></Style>


            <BackgroundGradientType>None</BackgroundGradientType>


            <TextAlign>General</TextAlign>


            <VerticalAlign>Top</VerticalAlign>


          </Style>


        </ChartNoDataMessage>


        <DataSetName>AssetsByOrganization</DataSetName>


        <Left>4.975in</Left>


        <Height>2.96875in</Height>


        <Width>2.4in</Width>


        <ZIndex>2</ZIndex>


        <Style></Style>


          <Border>


            <Color>LightGrey</Color>


            <Style></Style>Solid</Style>


          </Border>


          <BackgroundColor>White</BackgroundColor>


          <BackgroundGradientType>None</BackgroundGradientType>


        </Style>


      </Chart>


      <Chart Name="Chart5">


        <ChartCategoryHierarchy>


          <ChartMembers>


            <ChartMember>


              <Group Name="Chart5_CategoryGroup1">


                <GroupExpressions>


                  <GroupExpression>=Fields!AgeGroup.Value</GroupExpression>


                </GroupExpressions>


              </Group>


              <SortExpressions>


                <SortExpression>


                  <Value>=Fields!AgeGroup.Value</Value>


                </SortExpression>


              </SortExpressions>


              <Label>=IIf(Fields!AgeGroup.Value ="IsGreaterFiveYrs",Code.GetLocTable("LT_Report").GetString("LabelGreatherThan5Yrs", "[&gt; 5 years old]"),


	IIF(Fields!AgeGroup.Value = "IsBetweenTwoAndFiveYrs",Code.GetLocTable("LT_Report").GetString("Label2To5Yrs", "[2-5 years old]"),


		IIF(Fields!AgeGroup.Value = "IsLessTwoYrs",Code.GetLocTable("LT_Report").GetString("LabelLessThan2Yrs", "[&lt; 2 years old]"),


			Code.GetLocTable("LT_Report").GetString("LabelUnknown", "[Unknown]"))))</Label>


            </ChartMember>


          </ChartMembers>


        </ChartCategoryHierarchy>


        <ChartSeriesHierarchy>


          <ChartMembers>


            <ChartMember>


              <Group Name="Chart5_SeriesGroup1">


                <GroupExpressions>


                  <GroupExpression>=Fields!AssetCount.Value</GroupExpression>


                </GroupExpressions>


              </Group>


              <Label>=Fields!AssetCount.Value</Label>


            </ChartMember>


          </ChartMembers>


        </ChartSeriesHierarchy>


        <ChartData>


          <ChartSeriesCollection>


            <ChartSeries Name="AssetCount">


              <ChartDataPoints>


                <ChartDataPoint>


                  <ChartDataPointValues>


                    <X>=IIf(Fields!AgeGroup.Value ="IsGreaterFiveYrs",Code.GetLocTable("LT_Report").GetString("LabelGreatherThan5Yrs", "[&gt; 5 years old]"),


	IIF(Fields!AgeGroup.Value = "IsBetweenTwoAndFiveYrs",Code.GetLocTable("LT_Report").GetString("Label2To5Yrs", "[2-5 years old]"),


		IIF(Fields!AgeGroup.Value = "IsLessTwoYrs",Code.GetLocTable("LT_Report").GetString("LabelLessThan2Yrs", "[&lt; 2 years old]"),


			Code.GetLocTable("LT_Report").GetString("LabelUnknown", "[Unknown]"))))</X>


                    <Y>=Sum(Fields!AssetCount.Value)</Y>


                  </ChartDataPointValues>


                  <ChartDataLabel>


                    <Style /></Style>


                    <Label>=FormatPercent(Fields!AssetCount.Value/Fields!TotalAssetCount.Value,0)</Label>


                    <Visible>true</Visible>


                  </ChartDataLabel>


                  <ToolTip>=Fields!AssetCount.Value &amp; " " &amp; Code.GetLocTable("LT_Report").GetString("LabelAssets", "[asset(s)]") &amp; " " &amp;


	IIf(Fields!AgeGroup.Value ="IsGreaterFiveYrs",Code.GetLocTable("LT_Report").GetString("LabelGreatherThan5Yrs", "[&gt; 5 years old]"),


	IIF(Fields!AgeGroup.Value = "IsBetweenTwoAndFiveYrs",Code.GetLocTable("LT_Report").GetString("Label2To5Yrs", "[2-5 years old]"),


		IIF(Fields!AgeGroup.Value = "IsLessTwoYrs",Code.GetLocTable("LT_Report").GetString("LabelLessThan2Yrs", "[&lt; 2 years old]"),


			Code.GetLocTable("LT_Report").GetString("LabelUnknown", "[Unknown]"))))</ToolTip>


                  <ActionInfo>


                    <Actions>


                      <Action>


                        <Drillthrough>


                          <ReportName>Provance.ITAssetManagement.Report.HardwareAssetDetailReport</ReportName>


                          <Parameters>


                            <Parameter Name="AgeRange">


                              <Value>=Fields!AgeGroup.Value</Value>


                            </Parameter>


                            <Parameter Name="ExcludeLeased">


                              <Value>True</Value>


                            </Parameter>


                          </Parameters>


                        </Drillthrough>


                      </Action>


                    </Actions>


                  </ActionInfo>


                  <Style /></Style>


                  <ChartMarker>


                    <Style /></Style>


                  </ChartMarker>


                  <DataElementOutput>Output</DataElementOutput>


                </ChartDataPoint>


              </ChartDataPoints>


              <Type>Shape</Type>


              <Style /></Style>


              <ChartEmptyPoints>


                <Style /></Style>


                <ChartMarker>


                  <Style /></Style>


                </ChartMarker>


                <ChartDataLabel>


                  <Style /></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>


                <ChartAxisScaleBreak>


                  <Style /></Style>


                </ChartAxisScaleBreak>


              </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>


                <ChartAxisScaleBreak>


                  <Style /></Style>


                </ChartAxisScaleBreak>


              </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>


                <ChartAxisScaleBreak>


                  <Style /></Style>


                </ChartAxisScaleBreak>


              </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>


                <ChartAxisScaleBreak>


                  <Style /></Style>


                </ChartAxisScaleBreak>


              </ChartAxis>


            </ChartValueAxes>


            <ChartThreeDProperties>


              <Enabled>true</Enabled>


            </ChartThreeDProperties>


            <Style></Style>


              <BackgroundGradientType>None</BackgroundGradientType>


            </Style>


          </ChartArea>


        </ChartAreas>


        <ChartLegends>


          <ChartLegend Name="Default">


            <Style></Style>


              <BackgroundGradientType>None</BackgroundGradientType>


              <FontSize>8pt</FontSize>


            </Style>


            <Position>TopCenter</Position>


            <ChartLegendTitle>


              <Caption />


              <Style></Style>


                <FontSize>8pt</FontSize>


                <FontWeight>Bold</FontWeight>


                <TextAlign>Center</TextAlign>


              </Style>


            </ChartLegendTitle>


            <HeaderSeparatorColor>Black</HeaderSeparatorColor>


            <ColumnSeparatorColor>Black</ColumnSeparatorColor>


          </ChartLegend>


        </ChartLegends>


        <ChartTitles>


          <ChartTitle Name="Default">


            <Caption>=Code.GetLocTable("LT_Report").GetString("ElementAgeOfAsset", "[Age of Assets (Owned)]")</Caption>


            <Style></Style>


              <BackgroundGradientType>None</BackgroundGradientType>


              <FontWeight>Bold</FontWeight>


              <TextAlign>General</TextAlign>


              <VerticalAlign>Top</VerticalAlign>


            </Style>


            <Position>TopLeft</Position>


          </ChartTitle>


        </ChartTitles>


        <Palette>BrightPastel</Palette>


        <ChartBorderSkin>


          <Style></Style>


            <BackgroundColor>Gray</BackgroundColor>


            <BackgroundGradientType>None</BackgroundGradientType>


            <Color>White</Color>


          </Style>


        </ChartBorderSkin>


        <ChartNoDataMessage Name="NoDataMessage">


          <Caption>=Code.GetLocTable("LT_Report").GetString("A", "[No Data Available]")</Caption>


          <Style></Style>


            <BackgroundGradientType>None</BackgroundGradientType>


            <TextAlign>General</TextAlign>


            <VerticalAlign>Top</VerticalAlign>


          </Style>


        </ChartNoDataMessage>


        <DataSetName>AgeOfAsset</DataSetName>


        <Top>6.11245in</Top>


        <Left>0.025in</Left>


        <Height>2.96875in</Height>


        <Width>2.375in</Width>


        <ZIndex>3</ZIndex>


        <Style></Style>


          <Border>


            <Color>LightGrey</Color>


            <Style></Style>Solid</Style>


          </Border>


          <BackgroundColor>White</BackgroundColor>


          <BackgroundGradientType>None</BackgroundGradientType>


        </Style>


      </Chart>


      <Chart Name="Chart7">


        <ChartCategoryHierarchy>


          <ChartMembers>


            <ChartMember>


              <Group Name="Chart7_CategoryGroup1">


                <GroupExpressions>


                  <GroupExpression>=Fields!ReceivedDate.Value</GroupExpression>


                </GroupExpressions>


              </Group>


              <SortExpressions>


                <SortExpression>


                  <Value>=Fields!ReceivedDate.Value</Value>


                </SortExpression>


              </SortExpressions>


              <Label>=Fields!ReceivedDate.Value</Label>


            </ChartMember>


          </ChartMembers>


        </ChartCategoryHierarchy>


        <ChartSeriesHierarchy>


          <ChartMembers>


            <ChartMember>


              <Group Name="Chart7_SeriesGroup1">


                <GroupExpressions>


                  <GroupExpression>=Fields!DisplayName.Value</GroupExpression>


                </GroupExpressions>


              </Group>


              <SortExpressions>


                <SortExpression>


                  <Value>=Fields!DisplayName.Value</Value>


                </SortExpression>


              </SortExpressions>


              <Label>=Fields!DisplayName.Value</Label>


            </ChartMember>


          </ChartMembers>


        </ChartSeriesHierarchy>


        <ChartData>


          <ChartSeriesCollection>


            <ChartSeries Name="Cost">


              <ChartDataPoints>


                <ChartDataPoint>


                  <ChartDataPointValues>


                    <X>=Fields!ReceivedDate.Value</X>


                    <Y>=Sum(Fields!Cost.Value)</Y>


                  </ChartDataPointValues>


                  <ChartDataLabel>


                    <Style /></Style>


                  </ChartDataLabel>


                  <ActionInfo>


                    <Actions>


                      <Action>


                        <Drillthrough>


                          <ReportName>Provance.ITAssetManagement.Report.HardwareAssetDetailReport</ReportName>


                          <Parameters>


                            <Parameter Name="ManufacturerId">


                              <Value>=Fields!CompanyDimKey.Value</Value>


                            </Parameter>


                            <Parameter Name="IncludeDisposed">


                              <Value>True</Value>


                            </Parameter>


                          </Parameters>


                        </Drillthrough>


                      </Action>


                    </Actions>


                  </ActionInfo>


                  <Style /></Style>


                  <ChartMarker>


                    <Type>Circle</Type>


                    <Size>3pt</Size>


                    <Style></Style>


                      <Border>


                        <Width>0.25pt</Width>


                      </Border>


                    </Style>


                  </ChartMarker>


                  <DataElementOutput>Output</DataElementOutput>


                </ChartDataPoint>


              </ChartDataPoints>


              <Type>Line</Type>


              <Subtype>Smooth</Subtype>


              <Style /></Style>


              <ChartEmptyPoints>


                <Style /></Style>


                <ChartMarker>


                  <Style /></Style>


                </ChartMarker>


                <ChartDataLabel>


                  <Style /></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>MMM yyyy</Format>


                </Style>


                <ChartAxisTitle>


                  <Caption />


                  <Style></Style>


                    <FontSize>8pt</FontSize>


                  </Style>


                </ChartAxisTitle>


                <Interval>=IIF(IsNothing(Fields!ReceivedDate),1,


	IIF (DateDiff("m", 


		DateAdd("m",-1,Min(Fields!ReceivedDate.Value, "InvestmentByManufacturer")),


		DateAdd("m",1,Max(Fields!ReceivedDate.Value, "InvestmentByManufacturer"))) &lt; 4,


			1,2))</Interval>


                <IntervalType>Months</IntervalType>


                <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>


                <ChartMajorTickMarks>


                  <Interval>2</Interval>


                  <IntervalType>Months</IntervalType>


                </ChartMajorTickMarks>


                <ChartMinorTickMarks>


                  <Length>0.5</Length>


                </ChartMinorTickMarks>


                <CrossAt>NaN</CrossAt>


                <Minimum>NaN</Minimum>


                <Maximum>NaN</Maximum>


                <Angle>-90</Angle>


                <IncludeZero>false</IncludeZero>


                <LabelsAutoFitDisabled>true</LabelsAutoFitDisabled>


                <ChartAxisScaleBreak>


                  <Style /></Style>


                </ChartAxisScaleBreak>


              </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>


                <ChartAxisScaleBreak>


                  <Style /></Style>


                </ChartAxisScaleBreak>


              </ChartAxis>


            </ChartCategoryAxes>


            <ChartValueAxes>


              <ChartAxis Name="Primary">


                <Style></Style>


                  <FontSize>8pt</FontSize>


                  <Format>#,0,;(#,0,)</Format>


                </Style>


                <ChartAxisTitle>


                  <Caption>=Fields!CostIsoCurrencyCode.Value &amp; " " &amp; 


	Code.GetLocTable("LT_Report").GetString("LabelInThousands", "[in thousands]")</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>


                <ChartAxisScaleBreak>


                  <Style /></Style>


                </ChartAxisScaleBreak>


              </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>


                <ChartAxisScaleBreak>


                  <Style /></Style>


                </ChartAxisScaleBreak>


              </ChartAxis>


            </ChartValueAxes>


            <Style></Style>


              <BackgroundGradientType>None</BackgroundGradientType>


            </Style>


          </ChartArea>


        </ChartAreas>


        <ChartLegends>


          <ChartLegend Name="Default">


            <Style></Style>


              <BackgroundGradientType>None</BackgroundGradientType>


              <FontSize>8pt</FontSize>


            </Style>


            <Position>TopCenter</Position>


            <ChartLegendTitle>


              <Caption />


              <Style></Style>


                <FontSize>8pt</FontSize>


                <FontWeight>Bold</FontWeight>


                <TextAlign>Center</TextAlign>


              </Style>


            </ChartLegendTitle>


            <HeaderSeparatorColor>Black</HeaderSeparatorColor>


            <ColumnSeparatorColor>Black</ColumnSeparatorColor>


          </ChartLegend>


        </ChartLegends>


        <ChartTitles>


          <ChartTitle Name="Default">


            <Caption>=Code.GetLocTable("LT_Report").GetString("ElementInvestmentByManufacturer", "[Investment by Manufacturer]")</Caption>


            <Style></Style>


              <BackgroundGradientType>None</BackgroundGradientType>


              <FontWeight>Bold</FontWeight>


              <TextAlign>General</TextAlign>


              <VerticalAlign>Top</VerticalAlign>


            </Style>


            <Position>TopLeft</Position>


          </ChartTitle>


        </ChartTitles>


        <Palette>BrightPastel</Palette>


        <ChartBorderSkin>


          <Style></Style>


            <BackgroundColor>Gray</BackgroundColor>


            <BackgroundGradientType>None</BackgroundGradientType>


            <Color>White</Color>


          </Style>


        </ChartBorderSkin>


        <ChartNoDataMessage Name="NoDataMessage">


          <Caption>=Code.GetLocTable("LT_Report").GetString("A", "[No Data Available]")</Caption>


          <Style></Style>


            <BackgroundGradientType>None</BackgroundGradientType>


            <TextAlign>General</TextAlign>


            <VerticalAlign>Top</VerticalAlign>


          </Style>


        </ChartNoDataMessage>


        <DataSetName>InvestmentByManufacturer</DataSetName>


        <Top>3.05625in</Top>


        <Height>2.9687in</Height>


        <Width>3.64375in</Width>


        <ZIndex>4</ZIndex>


        <Style></Style>


          <Border>


            <Color>LightGrey</Color>


            <Style></Style>Solid</Style>


          </Border>


          <BackgroundColor>White</BackgroundColor>


          <BackgroundGradientType>None</BackgroundGradientType>


        </Style>


      </Chart>


      <Chart Name="Chart8">


        <ChartCategoryHierarchy>


          <ChartMembers>


            <ChartMember>


              <Group Name="Chart8_CategoryGroup1">


                <GroupExpressions>


                  <GroupExpression>=Fields!ReceivedDate.Value</GroupExpression>


                </GroupExpressions>


              </Group>


              <SortExpressions>


                <SortExpression>


                  <Value>=Fields!ReceivedDate.Value</Value>


                </SortExpression>


              </SortExpressions>


              <Label>=Fields!ReceivedDate.Value</Label>


            </ChartMember>


          </ChartMembers>


        </ChartCategoryHierarchy>


        <ChartSeriesHierarchy>


          <ChartMembers>


            <ChartMember>


              <Group Name="Chart8_SeriesGroup1">


                <GroupExpressions>


                  <GroupExpression>=Fields!DisplayName.Value</GroupExpression>


                </GroupExpressions>


              </Group>


              <SortExpressions>


                <SortExpression>


                  <Value>=Fields!DisplayName.Value</Value>


                </SortExpression>


              </SortExpressions>


              <Label>=Fields!DisplayName.Value</Label>


            </ChartMember>


          </ChartMembers>


        </ChartSeriesHierarchy>


        <ChartData>


          <ChartSeriesCollection>


            <ChartSeries Name="EmptySeriesName">


              <ChartDataPoints>


                <ChartDataPoint>


                  <ChartDataPointValues />


                  <ChartMarker>


                    <Type>Auto</Type>


                  </ChartMarker>


                </ChartDataPoint>


              </ChartDataPoints>


              <Type>Line</Type>


              <Subtype>Smooth</Subtype>


              <Style /></Style>


            </ChartSeries>


          </ChartSeriesCollection>


        </ChartData>


        <ChartAreas>


          <ChartArea Name="Default">


            <ChartCategoryAxes>


              <ChartAxis Name="Primary">


                <Style></Style>


                  <FontSize>8pt</FontSize>


                  <Format>MMM yyyy</Format>


                </Style>


                <ChartAxisTitle>


                  <Caption />


                  <Style></Style>


                    <FontSize>8pt</FontSize>


                  </Style>


                </ChartAxisTitle>


                <Interval>=IIF(IsNothing(Fields!ReceivedDate),1,


	IIF (DateDiff("m", 


		DateAdd("m",-1,Min(Fields!ReceivedDate.Value, "InvestmentBySupplier")),


		DateAdd("m",1,Max(Fields!ReceivedDate.Value, "InvestmentBySupplier"))) &lt; 4,


			1,2))</Interval>


                <IntervalType>Months</IntervalType>


                <VariableAutoInterval>true</VariableAutoInterval>


                <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>


                <ChartMajorTickMarks>


                  <Interval>2</Interval>


                  <IntervalType>Months</IntervalType>


                </ChartMajorTickMarks>


                <ChartMinorTickMarks>


                  <Length>0.5</Length>


                </ChartMinorTickMarks>


                <CrossAt>NaN</CrossAt>


                <Minimum>NaN</Minimum>


                <Maximum>NaN</Maximum>


                <Angle>-90</Angle>


                <IncludeZero>false</IncludeZero>


                <LabelsAutoFitDisabled>true</LabelsAutoFitDisabled>


                <ChartAxisScaleBreak>


                  <Style /></Style>


                </ChartAxisScaleBreak>


              </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>


                <ChartAxisScaleBreak>


                  <Style /></Style>


                </ChartAxisScaleBreak>


              </ChartAxis>


            </ChartCategoryAxes>


            <ChartValueAxes>


              <ChartAxis Name="Primary">


                <Style></Style>


                  <FontSize>8pt</FontSize>


                  <Format>#,0,;(#,0,)</Format>


                </Style>


                <ChartAxisTitle>


                  <Caption>=Fields!CostIsoCurrencyCode.Value &amp; " " &amp; 


	Code.GetLocTable("LT_Report").GetString("LabelInThousands", "[in thousands]")</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>


                <ChartAxisScaleBreak>


                  <Style /></Style>


                </ChartAxisScaleBreak>


              </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>


                <ChartAxisScaleBreak>


                  <Style /></Style>


                </ChartAxisScaleBreak>


              </ChartAxis>


            </ChartValueAxes>


            <Style></Style>


              <BackgroundGradientType>None</BackgroundGradientType>


            </Style>


          </ChartArea>


        </ChartAreas>


        <ChartLegends>


          <ChartLegend Name="Default">


            <Style></Style>


              <BackgroundGradientType>None</BackgroundGradientType>


              <FontSize>8pt</FontSize>


            </Style>


            <Position>TopCenter</Position>


            <ChartLegendTitle>


              <Caption />


              <Style></Style>


                <FontSize>8pt</FontSize>


                <FontWeight>Bold</FontWeight>


                <TextAlign>Center</TextAlign>


              </Style>


            </ChartLegendTitle>


            <HeaderSeparatorColor>Black</HeaderSeparatorColor>


            <ColumnSeparatorColor>Black</ColumnSeparatorColor>


          </ChartLegend>


        </ChartLegends>


        <ChartTitles>


          <ChartTitle Name="Default">


            <Caption>=Code.GetLocTable("LT_Report").GetString("ElementInvestmentBySupplier", "[Investment by Supplier]")</Caption>


            <Style></Style>


              <BackgroundGradientType>None</BackgroundGradientType>


              <FontWeight>Bold</FontWeight>


              <TextAlign>General</TextAlign>


              <VerticalAlign>Top</VerticalAlign>


            </Style>


            <Position>TopLeft</Position>


          </ChartTitle>


        </ChartTitles>


        <Palette>BrightPastel</Palette>


        <ChartBorderSkin>


          <Style></Style>


            <BackgroundColor>Gray</BackgroundColor>


            <BackgroundGradientType>None</BackgroundGradientType>


            <Color>White</Color>


          </Style>


        </ChartBorderSkin>


        <ChartNoDataMessage Name="NoDataMessage">


          <Caption>=Code.GetLocTable("LT_Report").GetString("A", "[No Data Available]")</Caption>


          <Style></Style>


            <BackgroundGradientType>None</BackgroundGradientType>


            <TextAlign>General</TextAlign>


            <VerticalAlign>Top</VerticalAlign>


          </Style>


        </ChartNoDataMessage>


        <DataSetName>InvestmentBySupplier</DataSetName>


        <Top>3.05625in</Top>


        <Left>3.73125in</Left>


        <Height>2.9687in</Height>


        <Width>3.64375in</Width>


        <ZIndex>5</ZIndex>


        <Style></Style>


          <Border>


            <Color>LightGrey</Color>


            <Style></Style>Solid</Style>


          </Border>


          <BackgroundColor>White</BackgroundColor>


          <BackgroundGradientType>None</BackgroundGradientType>


        </Style>


      </Chart>


      <Chart Name="AssetStatusChart">


        <ChartCategoryHierarchy>


          <ChartMembers>


            <ChartMember>


              <Group Name="AssetStatusChart_CategoryGroup1">


                <GroupExpressions>


                  <GroupExpression>=Fields!HardwareAssetLifecycleStatusValue.Value</GroupExpression>


                </GroupExpressions>


              </Group>


              <SortExpressions>


                <SortExpression>


                  <Value>=Fields!HardwareAssetLifecycleStatusValue.Value</Value>


                  <Direction>Descending</Direction>


                </SortExpression>


              </SortExpressions>


              <Label>=Fields!HardwareAssetLifecycleStatusValue.Value</Label>


            </ChartMember>


          </ChartMembers>


        </ChartCategoryHierarchy>


        <ChartSeriesHierarchy>


          <ChartMembers>


            <ChartMember>


              <Label>Lease Asset Count</Label>


            </ChartMember>


            <ChartMember>


              <Label>Owned Asset Count</Label>


            </ChartMember>


          </ChartMembers>


        </ChartSeriesHierarchy>


        <ChartData>


          <ChartSeriesCollection>


            <ChartSeries Name="LeaseAssetCount">


              <ChartDataPoints>


                <ChartDataPoint>


                  <ChartDataPointValues>


                    <Y>=Sum(Fields!LeaseAssetCount.Value)</Y>


                  </ChartDataPointValues>


                  <ChartDataLabel>


                    <Style /></Style>


                  </ChartDataLabel>


                  <ToolTip>=FormatPercent(Fields!LeaseAssetCount.Value/Fields!TotalAssetCount.Value,0) &amp; " " &amp; Fields!HardwareAssetLifecycleStatusValue.Value &amp; " " &amp; Code.GetLocTable("LT_Report").GetString("LabelLeased ", "[Leased]")</ToolTip>


                  <ActionInfo>


                    <Actions>


                      <Action>


                        <Drillthrough>


                          <ReportName>Provance.ITAssetManagement.Report.HardwareAssetDetailReport</ReportName>


                          <Parameters>


                            <Parameter Name="StatusId">


                              <Value>=Fields!HardwareAssetLifecycleStatusId.Value</Value>


                            </Parameter>


                            <Parameter Name="ExcludeOwned">


                              <Value>True</Value>


                            </Parameter>


                          </Parameters>


                        </Drillthrough>


                      </Action>


                    </Actions>


                  </ActionInfo>


                  <Style /></Style>


                  <ChartMarker>


                    <Style /></Style>


                  </ChartMarker>


                  <DataElementOutput>Output</DataElementOutput>


                </ChartDataPoint>


              </ChartDataPoints>


              <Type>Bar</Type>


              <Style /></Style>


              <ChartEmptyPoints>


                <Style /></Style>


                <ChartMarker>


                  <Style /></Style>


                </ChartMarker>


                <ChartDataLabel>


                  <Style /></Style>


                </ChartDataLabel>


              </ChartEmptyPoints>


              <ChartItemInLegend>


                <LegendText>=Code.GetLocTable("LT_Report").GetString("LabelLeased", "[Leased]")</LegendText>


              </ChartItemInLegend>


              <ValueAxisName>Primary</ValueAxisName>


              <CategoryAxisName>Primary</CategoryAxisName>


              <ChartSmartLabel>


                <CalloutLineColor>Black</CalloutLineColor>


                <MinMovingDistance>0pt</MinMovingDistance>


              </ChartSmartLabel>


            </ChartSeries>


            <ChartSeries Name="OwnedAssetCount1">


              <ChartDataPoints>


                <ChartDataPoint>


                  <ChartDataPointValues>


                    <Y>=Sum(Fields!OwnedAssetCount.Value)</Y>


                  </ChartDataPointValues>


                  <ChartDataLabel>


                    <Style /></Style>


                  </ChartDataLabel>


                  <ToolTip>=FormatPercent(Fields!OwnedAssetCount.Value/Fields!TotalAssetCount.Value,0) &amp; " " &amp; Fields!HardwareAssetLifecycleStatusValue.Value &amp; " " &amp; Code.GetLocTable("LT_Report").GetString("LabelOwned", "[Owned]")</ToolTip>


                  <ActionInfo>


                    <Actions>


                      <Action>


                        <Drillthrough>


                          <ReportName>Provance.ITAssetManagement.Report.HardwareAssetDetailReport</ReportName>


                          <Parameters>


                            <Parameter Name="StatusId">


                              <Value>=Fields!HardwareAssetLifecycleStatusId.Value</Value>


                            </Parameter>


                            <Parameter Name="ExcludeLeased">


                              <Value>True</Value>


                            </Parameter>


                          </Parameters>


                        </Drillthrough>


                      </Action>


                    </Actions>


                  </ActionInfo>


                  <Style /></Style>


                  <ChartMarker>


                    <Style /></Style>


                  </ChartMarker>


                  <DataElementOutput>Output</DataElementOutput>


                </ChartDataPoint>


              </ChartDataPoints>


              <Type>Bar</Type>


              <Style /></Style>


              <ChartEmptyPoints>


                <Style /></Style>


                <ChartMarker>


                  <Style /></Style>


                </ChartMarker>


                <ChartDataLabel>


                  <Style /></Style>


                </ChartDataLabel>


              </ChartEmptyPoints>


              <ChartItemInLegend>


                <LegendText>=Code.GetLocTable("LT_Report").GetString("LabelOwned", "[Owned]")</LegendText>


              </ChartItemInLegend>


              <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>0;(0)</Format>


                </Style>


                <ChartAxisTitle>


                  <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>


                <ChartAxisScaleBreak>


                  <Style /></Style>


                </ChartAxisScaleBreak>


              </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>


                <ChartAxisScaleBreak>


                  <Style /></Style>


                </ChartAxisScaleBreak>


              </ChartAxis>


            </ChartCategoryAxes>


            <ChartValueAxes>


              <ChartAxis Name="Primary">


                <Style></Style>


                  <FontSize>8pt</FontSize>


                  <Format>0;(0)</Format>


                </Style>


                <ChartAxisTitle>


                  <Caption />


                  <Style></Style>


                    <FontSize>8pt</FontSize>


                  </Style>


                </ChartAxisTitle>


                <Interval>=IIf(Sum(Fields!AssetCount.Value) &gt; 5000,5000,


	IIF(Sum(Fields!AssetCount.Value) &gt; 1000,1000,


		IIf(Sum(Fields!AssetCount.Value) &gt;100, 100,


			IIf(Sum(Fields!AssetCount.Value) &gt; 10, 10, 1))))</Interval>


                <IntervalType>Number</IntervalType>


                <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>=0</Minimum>


                <Maximum>NaN</Maximum>


                <ChartAxisScaleBreak>


                  <Style /></Style>


                </ChartAxisScaleBreak>


              </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>


                <ChartAxisScaleBreak>


                  <Style /></Style>


                </ChartAxisScaleBreak>


              </ChartAxis>


            </ChartValueAxes>


            <ChartThreeDProperties>


              <Enabled>true</Enabled>


              <Clustered>true</Clustered>


            </ChartThreeDProperties>


            <Style></Style>


              <BackgroundGradientType>None</BackgroundGradientType>


            </Style>


          </ChartArea>


        </ChartAreas>


        <ChartLegends>


          <ChartLegend Name="Default">


            <Style></Style>


              <BackgroundGradientType>None</BackgroundGradientType>


              <FontSize>8pt</FontSize>


            </Style>


            <Position>TopRight</Position>


            <ChartLegendTitle>


              <Caption />


              <Style></Style>


                <FontSize>8pt</FontSize>


                <FontWeight>Bold</FontWeight>


                <TextAlign>Center</TextAlign>


              </Style>


            </ChartLegendTitle>


            <HeaderSeparatorColor>Black</HeaderSeparatorColor>


            <ColumnSeparatorColor>Black</ColumnSeparatorColor>


          </ChartLegend>


        </ChartLegends>


        <ChartTitles>


          <ChartTitle Name="Default">


            <Caption>=Code.GetLocTable("LT_Report").GetString("ElementAssetStatus", "[Asset Status]")</Caption>


            <Style></Style>


              <BackgroundGradientType>None</BackgroundGradientType>


              <FontWeight>Bold</FontWeight>


              <TextAlign>General</TextAlign>


              <VerticalAlign>Top</VerticalAlign>


            </Style>


            <Position>TopLeft</Position>


          </ChartTitle>


        </ChartTitles>


        <Palette>BrightPastel</Palette>


        <ChartBorderSkin>


          <Style></Style>


            <BackgroundColor>Gray</BackgroundColor>


            <BackgroundGradientType>None</BackgroundGradientType>


            <Color>White</Color>


          </Style>


        </ChartBorderSkin>


        <ChartNoDataMessage Name="NoDataMessage">


          <Caption>=Code.GetLocTable("LT_Report").GetString("A", "[No Data Available]")</Caption>


          <Style></Style>


            <BackgroundGradientType>None</BackgroundGradientType>


            <TextAlign>General</TextAlign>


            <VerticalAlign>Top</VerticalAlign>


          </Style>


        </ChartNoDataMessage>


        <DataSetName>AssetStatus</DataSetName>


        <Top>6.11245in</Top>


        <Left>2.4875in</Left>


        <Height>2.96875in</Height>


        <Width>2.4in</Width>


        <ZIndex>6</ZIndex>


        <Style></Style>


          <Border>


            <Color>LightGrey</Color>


            <Style></Style>Solid</Style>


          </Border>


          <BackgroundColor>White</BackgroundColor>


          <BackgroundGradientType>None</BackgroundGradientType>


        </Style>


      </Chart>


      <Rectangle Name="Rectangle1">


        <ReportItems>


          <Tablix Name="Tablix2">


            <TablixBody>


              <TablixColumns>


                <TablixColumn>


                  <Width>0.575in</Width>


                </TablixColumn>


                <TablixColumn>


                  <Width>0.575in</Width>


                </TablixColumn>


                <TablixColumn>


                  <Width>0.575in</Width>


                </TablixColumn>


                <TablixColumn>


                  <Width>0.575in</Width>


                </TablixColumn>


              </TablixColumns>


              <TablixRows>


                <TablixRow>


                  <Height>0.27082in</Height>


                  <TablixCells>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox8">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Value />


                                  <Style></Style>


                                    <FontSize>9pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox8</rd:DefaultName>


                          <ActionInfo>


                            <Actions>


                              <Action>


                                <Drillthrough>


                                  <ReportName>../Report.ContractManagement.Folder/Provance.ITAssetManagement.Report.EndofContracts</ReportName>


                                  <Parameters>


                                    <Parameter Name="ThresholdContractExpired">


                                      <Value>=Parameters!ThresholdContractExpired.Value</Value>


                                    </Parameter>


                                    <Parameter Name="ThresholdContractCloseToExpired">


                                      <Value>=Parameters!ThresholdContractCloseToExpired.Value</Value>


                                    </Parameter>


                                    <Parameter Name="Threshold">


                                      <Value>AL</Value>


                                    </Parameter>


                                  </Parameters>


                                </Drillthrough>


                              </Action>


                            </Actions>


                          </ActionInfo>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


                              <Style></Style>Solid</Style>


                            </Border>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="txtExpired">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Expired</Label>


                                  <Value>=Code.GetLocTable("LT_Report").GetString("LabelExpired", "[Expired]")</Value>


                                  <Style></Style>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <ActionInfo>


                            <Actions>


                              <Action>


                                <Drillthrough>


                                  <ReportName>../Report.ContractManagement.Folder/Provance.ITAssetManagement.Report.EndofContracts</ReportName>


                                  <Parameters>


                                    <Parameter Name="ContractType">


                                      <Value>AL</Value>


                                    </Parameter>


                                    <Parameter Name="ThresholdContractExpired">


                                      <Value>=Parameters!ThresholdContractExpired.Value</Value>


                                    </Parameter>


                                    <Parameter Name="ThresholdContractCloseToExpired">


                                      <Value>=Parameters!ThresholdContractCloseToExpired.Value</Value>


                                    </Parameter>


                                    <Parameter Name="Threshold">


                                      <Value>EX</Value>


                                    </Parameter>


                                  </Parameters>


                                </Drillthrough>


                              </Action>


                            </Actions>


                          </ActionInfo>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


                              <Style></Style>Solid</Style>


                            </Border>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="txt7Day">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Close</Label>


                                  <Value>=Code.GetLocTable("LT_Report").GetString("C", "[Close]")</Value>


                                  <Style></Style>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <ActionInfo>


                            <Actions>


                              <Action>


                                <Drillthrough>


                                  <ReportName>../Report.ContractManagement.Folder/Provance.ITAssetManagement.Report.EndofContracts</ReportName>


                                  <Parameters>


                                    <Parameter Name="ContractType">


                                      <Value>AL</Value>


                                    </Parameter>


                                    <Parameter Name="ThresholdContractExpired">


                                      <Value>=Parameters!ThresholdContractExpired.Value</Value>


                                    </Parameter>


                                    <Parameter Name="ThresholdContractCloseToExpired">


                                      <Value>=Parameters!ThresholdContractCloseToExpired.Value</Value>


                                    </Parameter>


                                    <Parameter Name="Threshold">


                                      <Value>CL</Value>


                                    </Parameter>


                                  </Parameters>


                                </Drillthrough>


                              </Action>


                            </Actions>


                          </ActionInfo>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


                              <Style></Style>Solid</Style>


                            </Border>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="txt30Day">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Good</Label>


                                  <Value>=Code.GetLocTable("LT_Report").GetString("D", "[Good]")</Value>


                                  <Style></Style>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <ActionInfo>


                            <Actions>


                              <Action>


                                <Drillthrough>


                                  <ReportName>../Report.ContractManagement.Folder/Provance.ITAssetManagement.Report.EndofContracts</ReportName>


                                  <Parameters>


                                    <Parameter Name="ContractType">


                                      <Value>AL</Value>


                                    </Parameter>


                                    <Parameter Name="ThresholdContractExpired">


                                      <Value>=Parameters!ThresholdContractExpired.Value</Value>


                                    </Parameter>


                                    <Parameter Name="ThresholdContractCloseToExpired">


                                      <Value>=Parameters!ThresholdContractCloseToExpired.Value</Value>


                                    </Parameter>


                                    <Parameter Name="Threshold">


                                      <Value>GO</Value>


                                    </Parameter>


                                  </Parameters>


                                </Drillthrough>


                              </Action>


                            </Actions>


                          </ActionInfo>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


                              <Style></Style>Solid</Style>


                            </Border>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                  </TablixCells>


                </TablixRow>


                <TablixRow>


                  <Height>0.16667in</Height>


                  <TablixCells>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox5">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Value />


                                  <Style></Style>


                                    <FontSize>9pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox5</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


                              <Style></Style>Solid</Style>


                            </Border>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox6">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Value />


                                  <Style></Style>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox6</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


                              <Style></Style>Solid</Style>


                            </Border>


                            <BackgroundColor>Red</BackgroundColor>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox7">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Value />


                                  <Style></Style>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox7</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


                              <Style></Style>Solid</Style>


                            </Border>


                            <BackgroundColor>Yellow</BackgroundColor>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox9">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Value />


                                  <Style></Style>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox9</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


                              <Style></Style>Solid</Style>


                            </Border>


                            <BackgroundColor>Green</BackgroundColor>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                  </TablixCells>


                </TablixRow>


                <TablixRow>


                  <Height>0.35in</Height>


                  <TablixCells>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="txtWarranty">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Warranty</Label>


                                  <Value>=Code.GetLocTable("LT_Report").GetString("LabelWarranty", "[Warranty]")</Value>


                                  <Style></Style>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <ActionInfo>


                            <Actions>


                              <Action>


                                <Drillthrough>


                                  <ReportName>../Report.ContractManagement.Folder/Provance.ITAssetManagement.Report.EndofContracts</ReportName>


                                  <Parameters>


                                    <Parameter Name="ContractType">


                                      <Value>WA</Value>


                                    </Parameter>


                                    <Parameter Name="ThresholdContractExpired">


                                      <Value>=Parameters!ThresholdContractExpired.Value</Value>


                                    </Parameter>


                                    <Parameter Name="ThresholdContractCloseToExpired">


                                      <Value>=Parameters!ThresholdContractCloseToExpired.Value</Value>


                                    </Parameter>


                                    <Parameter Name="Threshold">


                                      <Value>AL</Value>


                                    </Parameter>


                                  </Parameters>


                                </Drillthrough>


                              </Action>


                            </Actions>


                          </ActionInfo>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


                              <Style></Style>Solid</Style>


                            </Border>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="txtWarrantyExpired">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Expired</Label>


                                  <Value>=Sum(IIF(Fields!ContractType.Value = "Warranty",Fields!Expired.Value,0))</Value>


                                  <Style /></Style>


                                </TextRun>


                              </TextRuns>


                              <Style></Style>


                                <TextAlign>Center</TextAlign>


                              </Style>


                            </Paragraph>


                          </Paragraphs>


                          <ActionInfo>


                            <Actions>


                              <Action>


                                <Drillthrough>


                                  <ReportName>../Report.ContractManagement.Folder/Provance.ITAssetManagement.Report.EndofContracts</ReportName>


                                  <Parameters>


                                    <Parameter Name="ContractType">


                                      <Value>WA</Value>


                                    </Parameter>


                                    <Parameter Name="ThresholdContractExpired">


                                      <Value>=Parameters!ThresholdContractExpired.Value</Value>


                                    </Parameter>


                                    <Parameter Name="ThresholdContractCloseToExpired">


                                      <Value>=Parameters!ThresholdContractCloseToExpired.Value</Value>


                                    </Parameter>


                                    <Parameter Name="Threshold">


                                      <Value>EX</Value>


                                    </Parameter>


                                  </Parameters>


                                </Drillthrough>


                              </Action>


                            </Actions>


                          </ActionInfo>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


                              <Style></Style>Solid</Style>


                            </Border>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="txtWarranty7Days">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Close</Label>


                                  <Value>=Sum(IIf(Fields!ContractType.Value = "Warranty",Fields!CloseToExpired.Value,0))</Value>


                                  <Style /></Style>


                                </TextRun>


                              </TextRuns>


                              <Style></Style>


                                <TextAlign>Center</TextAlign>


                              </Style>


                            </Paragraph>


                          </Paragraphs>


                          <ActionInfo>


                            <Actions>


                              <Action>


                                <Drillthrough>


                                  <ReportName>../Report.ContractManagement.Folder/Provance.ITAssetManagement.Report.EndofContracts</ReportName>


                                  <Parameters>


                                    <Parameter Name="ContractType">


                                      <Value>WA</Value>


                                    </Parameter>


                                    <Parameter Name="ThresholdContractExpired">


                                      <Value>=Parameters!ThresholdContractExpired.Value</Value>


                                    </Parameter>


                                    <Parameter Name="ThresholdContractCloseToExpired">


                                      <Value>=Parameters!ThresholdContractCloseToExpired.Value</Value>


                                    </Parameter>


                                    <Parameter Name="Threshold">


                                      <Value>CL</Value>


                                    </Parameter>


                                  </Parameters>


                                </Drillthrough>


                              </Action>


                            </Actions>


                          </ActionInfo>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


                              <Style></Style>Solid</Style>


                            </Border>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="txtWarranty30Day">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Good</Label>


                                  <Value>=Sum(IIf(Fields!ContractType.Value = "Warranty",Fields!Good.Value,0))</Value>


                                  <Style /></Style>


                                </TextRun>


                              </TextRuns>


                              <Style></Style>


                                <TextAlign>Center</TextAlign>


                              </Style>


                            </Paragraph>


                          </Paragraphs>


                          <ActionInfo>


                            <Actions>


                              <Action>


                                <Drillthrough>


                                  <ReportName>../Report.ContractManagement.Folder/Provance.ITAssetManagement.Report.EndofContracts</ReportName>


                                  <Parameters>


                                    <Parameter Name="ContractType">


                                      <Value>WA</Value>


                                    </Parameter>


                                    <Parameter Name="ThresholdContractExpired">


                                      <Value>=Parameters!ThresholdContractExpired.Value</Value>


                                    </Parameter>


                                    <Parameter Name="ThresholdContractCloseToExpired">


                                      <Value>=Parameters!ThresholdContractCloseToExpired.Value</Value>


                                    </Parameter>


                                    <Parameter Name="Threshold">


                                      <Value>GO</Value>


                                    </Parameter>


                                  </Parameters>


                                </Drillthrough>


                              </Action>


                            </Actions>


                          </ActionInfo>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


                              <Style></Style>Solid</Style>


                            </Border>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                  </TablixCells>


                </TablixRow>


                <TablixRow>


                  <Height>0.35in</Height>


                  <TablixCells>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="txtLease">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Lease</Label>


                                  <Value>=Code.GetLocTable("LT_Report").GetString("LabelLease", "[Lease]")</Value>


                                  <Style></Style>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <ActionInfo>


                            <Actions>


                              <Action>


                                <Drillthrough>


                                  <ReportName>../Report.ContractManagement.Folder/Provance.ITAssetManagement.Report.EndofContracts</ReportName>


                                  <Parameters>


                                    <Parameter Name="ContractType">


                                      <Value>LE</Value>


                                    </Parameter>


                                    <Parameter Name="ThresholdContractExpired">


                                      <Value>=Parameters!ThresholdContractExpired.Value</Value>


                                    </Parameter>


                                    <Parameter Name="ThresholdContractCloseToExpired">


                                      <Value>=Parameters!ThresholdContractCloseToExpired.Value</Value>


                                    </Parameter>


                                    <Parameter Name="Threshold">


                                      <Value>AL</Value>


                                    </Parameter>


                                  </Parameters>


                                </Drillthrough>


                              </Action>


                            </Actions>


                          </ActionInfo>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


                              <Style></Style>Solid</Style>


                            </Border>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="txtLeaseExpired">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Expired</Label>


                                  <Value>=Sum(IIf(Fields!ContractType.Value = "Lease",Fields!Expired.Value,0))</Value>


                                  <Style /></Style>


                                </TextRun>


                              </TextRuns>


                              <Style></Style>


                                <TextAlign>Center</TextAlign>


                              </Style>


                            </Paragraph>


                          </Paragraphs>


                          <ActionInfo>


                            <Actions>


                              <Action>


                                <Drillthrough>


                                  <ReportName>../Report.ContractManagement.Folder/Provance.ITAssetManagement.Report.EndofContracts</ReportName>


                                  <Parameters>


                                    <Parameter Name="ContractType">


                                      <Value>LE</Value>


                                    </Parameter>


                                    <Parameter Name="ThresholdContractExpired">


                                      <Value>=Parameters!ThresholdContractExpired.Value</Value>


                                    </Parameter>


                                    <Parameter Name="ThresholdContractCloseToExpired">


                                      <Value>=Parameters!ThresholdContractCloseToExpired.Value</Value>


                                    </Parameter>


                                    <Parameter Name="Threshold">


                                      <Value>EX</Value>


                                    </Parameter>


                                  </Parameters>


                                </Drillthrough>


                              </Action>


                            </Actions>


                          </ActionInfo>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


                              <Style></Style>Solid</Style>


                            </Border>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="txtLease7Day">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Close</Label>


                                  <Value>=Sum(IIf(Fields!ContractType.Value = "Lease",Fields!CloseToExpired.Value,0))</Value>


                                  <Style /></Style>


                                </TextRun>


                              </TextRuns>


                              <Style></Style>


                                <TextAlign>Center</TextAlign>


                              </Style>


                            </Paragraph>


                          </Paragraphs>


                          <ActionInfo>


                            <Actions>


                              <Action>


                                <Drillthrough>


                                  <ReportName>../Report.ContractManagement.Folder/Provance.ITAssetManagement.Report.EndofContracts</ReportName>


                                  <Parameters>


                                    <Parameter Name="ContractType">


                                      <Value>LE</Value>


                                    </Parameter>


                                    <Parameter Name="ThresholdContractExpired">


                                      <Value>=Parameters!ThresholdContractExpired.Value</Value>


                                    </Parameter>


                                    <Parameter Name="ThresholdContractCloseToExpired">


                                      <Value>=Parameters!ThresholdContractCloseToExpired.Value</Value>


                                    </Parameter>


                                    <Parameter Name="Threshold">


                                      <Value>CL</Value>


                                    </Parameter>


                                  </Parameters>


                                </Drillthrough>


                              </Action>


                            </Actions>


                          </ActionInfo>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


                              <Style></Style>Solid</Style>


                            </Border>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="txtLease30Day">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Good</Label>


                                  <Value>=Sum(IIf(Fields!ContractType.Value = "Lease",Fields!Good.Value,0))</Value>


                                  <Style /></Style>


                                </TextRun>


                              </TextRuns>


                              <Style></Style>


                                <TextAlign>Center</TextAlign>


                              </Style>


                            </Paragraph>


                          </Paragraphs>


                          <ActionInfo>


                            <Actions>


                              <Action>


                                <Drillthrough>


                                  <ReportName>../Report.ContractManagement.Folder/Provance.ITAssetManagement.Report.EndofContracts</ReportName>


                                  <Parameters>


                                    <Parameter Name="ContractType">


                                      <Value>LE</Value>


                                    </Parameter>


                                    <Parameter Name="ThresholdContractExpired">


                                      <Value>=Parameters!ThresholdContractExpired.Value</Value>


                                    </Parameter>


                                    <Parameter Name="ThresholdContractCloseToExpired">


                                      <Value>=Parameters!ThresholdContractCloseToExpired.Value</Value>


                                    </Parameter>


                                    <Parameter Name="Threshold">


                                      <Value>GO</Value>


                                    </Parameter>


                                  </Parameters>


                                </Drillthrough>


                              </Action>


                            </Actions>


                          </ActionInfo>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


                              <Style></Style>Solid</Style>


                            </Border>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                  </TablixCells>


                </TablixRow>


                <TablixRow>


                  <Height>0.35in</Height>


                  <TablixCells>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="txtSupport">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Support</Label>


                                  <Value>=Code.GetLocTable("LT_Report").GetString("LabelSupport", "[Support]")</Value>


                                  <Style></Style>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <ActionInfo>


                            <Actions>


                              <Action>


                                <Drillthrough>


                                  <ReportName>../Report.ContractManagement.Folder/Provance.ITAssetManagement.Report.EndofContracts</ReportName>


                                  <Parameters>


                                    <Parameter Name="ContractType">


                                      <Value>SV</Value>


                                    </Parameter>


                                    <Parameter Name="ThresholdContractExpired">


                                      <Value>=Parameters!ThresholdContractExpired.Value</Value>


                                    </Parameter>


                                    <Parameter Name="ThresholdContractCloseToExpired">


                                      <Value>=Parameters!ThresholdContractCloseToExpired.Value</Value>


                                    </Parameter>


                                    <Parameter Name="Threshold">


                                      <Value>AL</Value>


                                    </Parameter>


                                  </Parameters>


                                </Drillthrough>


                              </Action>


                            </Actions>


                          </ActionInfo>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


                              <Style></Style>Solid</Style>


                            </Border>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="txtSupportExpired">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Expired</Label>


                                  <Value>=Sum(IIf(Fields!ContractType.Value = "Support",Fields!Expired.Value,0))</Value>


                                  <Style /></Style>


                                </TextRun>


                              </TextRuns>


                              <Style></Style>


                                <TextAlign>Center</TextAlign>


                              </Style>


                            </Paragraph>


                          </Paragraphs>


                          <ActionInfo>


                            <Actions>


                              <Action>


                                <Drillthrough>


                                  <ReportName>../Report.ContractManagement.Folder/Provance.ITAssetManagement.Report.EndofContracts</ReportName>


                                  <Parameters>


                                    <Parameter Name="ContractType">


                                      <Value>SV</Value>


                                    </Parameter>


                                    <Parameter Name="ThresholdContractExpired">


                                      <Value>=Parameters!ThresholdContractExpired.Value</Value>


                                    </Parameter>


                                    <Parameter Name="ThresholdContractCloseToExpired">


                                      <Value>=Parameters!ThresholdContractCloseToExpired.Value</Value>


                                    </Parameter>


                                    <Parameter Name="Threshold">


                                      <Value>EX</Value>


                                    </Parameter>


                                  </Parameters>


                                </Drillthrough>


                              </Action>


                            </Actions>


                          </ActionInfo>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


                              <Style></Style>Solid</Style>


                            </Border>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="txtSupport7Day">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Close</Label>


                                  <Value>=Sum(IIf(Fields!ContractType.Value = "Support",Fields!CloseToExpired.Value,0))</Value>


                                  <Style /></Style>


                                </TextRun>


                              </TextRuns>


                              <Style></Style>


                                <TextAlign>Center</TextAlign>


                              </Style>


                            </Paragraph>


                          </Paragraphs>


                          <ActionInfo>


                            <Actions>


                              <Action>


                                <Drillthrough>


                                  <ReportName>../Report.ContractManagement.Folder/Provance.ITAssetManagement.Report.EndofContracts</ReportName>


                                  <Parameters>


                                    <Parameter Name="ContractType">


                                      <Value>SV</Value>


                                    </Parameter>


                                    <Parameter Name="ThresholdContractExpired">


                                      <Value>=Parameters!ThresholdContractExpired.Value</Value>


                                    </Parameter>


                                    <Parameter Name="ThresholdContractCloseToExpired">


                                      <Value>=Parameters!ThresholdContractCloseToExpired.Value</Value>


                                    </Parameter>


                                    <Parameter Name="Threshold">


                                      <Value>CL</Value>


                                    </Parameter>


                                  </Parameters>


                                </Drillthrough>


                              </Action>


                            </Actions>


                          </ActionInfo>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


                              <Style></Style>Solid</Style>


                            </Border>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="txtSupport30Day">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Good</Label>


                                  <Value>=Sum(IIf(Fields!ContractType.Value = "Support",Fields!Good.Value,0))</Value>


                                  <Style /></Style>


                                </TextRun>


                              </TextRuns>


                              <Style></Style>


                                <TextAlign>Center</TextAlign>


                              </Style>


                            </Paragraph>


                          </Paragraphs>


                          <ActionInfo>


                            <Actions>


                              <Action>


                                <Drillthrough>


                                  <ReportName>../Report.ContractManagement.Folder/Provance.ITAssetManagement.Report.EndofContracts</ReportName>


                                  <Parameters>


                                    <Parameter Name="ContractType">


                                      <Value>SV</Value>


                                    </Parameter>


                                    <Parameter Name="ThresholdContractExpired">


                                      <Value>=Parameters!ThresholdContractExpired.Value</Value>


                                    </Parameter>


                                    <Parameter Name="ThresholdContractCloseToExpired">


                                      <Value>=Parameters!ThresholdContractCloseToExpired.Value</Value>


                                    </Parameter>


                                    <Parameter Name="Threshold">


                                      <Value>GO</Value>


                                    </Parameter>


                                  </Parameters>


                                </Drillthrough>


                              </Action>


                            </Actions>


                          </ActionInfo>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


                              <Style></Style>Solid</Style>


                            </Border>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                  </TablixCells>


                </TablixRow>


                <TablixRow>


                  <Height>0.35in</Height>


                  <TablixCells>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="txtDisposal">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Disposal</Label>


                                  <Value>=Code.GetLocTable("LT_Report").GetString("LabelDisposal", "[Disposal]")</Value>


                                  <Style></Style>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <ActionInfo>


                            <Actions>


                              <Action>


                                <Drillthrough>


                                  <ReportName>../Report.ContractManagement.Folder/Provance.ITAssetManagement.Report.EndofContracts</ReportName>


                                  <Parameters>


                                    <Parameter Name="ContractType">


                                      <Value>DI</Value>


                                    </Parameter>


                                    <Parameter Name="ThresholdContractExpired">


                                      <Value>=Parameters!ThresholdContractExpired.Value</Value>


                                    </Parameter>


                                    <Parameter Name="ThresholdContractCloseToExpired">


                                      <Value>=Parameters!ThresholdContractCloseToExpired.Value</Value>


                                    </Parameter>


                                    <Parameter Name="Threshold">


                                      <Value>AL</Value>


                                    </Parameter>


                                  </Parameters>


                                </Drillthrough>


                              </Action>


                            </Actions>


                          </ActionInfo>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


                              <Style></Style>Solid</Style>


                            </Border>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="txtDisposalExpired">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Expired</Label>


                                  <Value>=Sum(IIf(Fields!ContractType.Value = "Disposal",Fields!Expired.Value,0))</Value>


                                  <Style /></Style>


                                </TextRun>


                              </TextRuns>


                              <Style></Style>


                                <TextAlign>Center</TextAlign>


                              </Style>


                            </Paragraph>


                          </Paragraphs>


                          <ActionInfo>


                            <Actions>


                              <Action>


                                <Drillthrough>


                                  <ReportName>../Report.ContractManagement.Folder/Provance.ITAssetManagement.Report.EndofContracts</ReportName>


                                  <Parameters>


                                    <Parameter Name="ContractType">


                                      <Value>DI</Value>


                                    </Parameter>


                                    <Parameter Name="ThresholdContractExpired">


                                      <Value>=Parameters!ThresholdContractExpired.Value</Value>


                                    </Parameter>


                                    <Parameter Name="ThresholdContractCloseToExpired">


                                      <Value>=Parameters!ThresholdContractCloseToExpired.Value</Value>


                                    </Parameter>


                                    <Parameter Name="Threshold">


                                      <Value>EX</Value>


                                    </Parameter>


                                  </Parameters>


                                </Drillthrough>


                              </Action>


                            </Actions>


                          </ActionInfo>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


                              <Style></Style>Solid</Style>


                            </Border>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="txtDisposal7Day">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Close</Label>


                                  <Value>=Sum(IIf(Fields!ContractType.Value = "Disposal",Fields!CloseToExpired.Value,0))</Value>


                                  <Style /></Style>


                                </TextRun>


                              </TextRuns>


                              <Style></Style>


                                <TextAlign>Center</TextAlign>


                              </Style>


                            </Paragraph>


                          </Paragraphs>


                          <ActionInfo>


                            <Actions>


                              <Action>


                                <Drillthrough>


                                  <ReportName>../Report.ContractManagement.Folder/Provance.ITAssetManagement.Report.EndofContracts</ReportName>


                                  <Parameters>


                                    <Parameter Name="ContractType">


                                      <Value>DI</Value>


                                    </Parameter>


                                    <Parameter Name="ThresholdContractExpired">


                                      <Value>=Parameters!ThresholdContractExpired.Value</Value>


                                    </Parameter>


                                    <Parameter Name="ThresholdContractCloseToExpired">


                                      <Value>=Parameters!ThresholdContractCloseToExpired.Value</Value>


                                    </Parameter>


                                    <Parameter Name="Threshold">


                                      <Value>CL</Value>


                                    </Parameter>


                                  </Parameters>


                                </Drillthrough>


                              </Action>


                            </Actions>


                          </ActionInfo>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


                              <Style></Style>Solid</Style>


                            </Border>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="txtDisposal30Day">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Good</Label>


                                  <Value>=Sum(IIf(Fields!ContractType.Value = "Disposal",Fields!Good.Value,0))</Value>


                                  <Style /></Style>


                                </TextRun>


                              </TextRuns>


                              <Style></Style>


                                <TextAlign>Center</TextAlign>


                              </Style>


                            </Paragraph>


                          </Paragraphs>


                          <ActionInfo>


                            <Actions>


                              <Action>


                                <Drillthrough>


                                  <ReportName>../Report.ContractManagement.Folder/Provance.ITAssetManagement.Report.EndofContracts</ReportName>


                                  <Parameters>


                                    <Parameter Name="ContractType">


                                      <Value>DI</Value>


                                    </Parameter>


                                    <Parameter Name="ThresholdContractExpired">


                                      <Value>=Parameters!ThresholdContractExpired.Value</Value>


                                    </Parameter>


                                    <Parameter Name="ThresholdContractCloseToExpired">


                                      <Value>=Parameters!ThresholdContractCloseToExpired.Value</Value>


                                    </Parameter>


                                    <Parameter Name="Threshold">


                                      <Value>GO</Value>


                                    </Parameter>


                                  </Parameters>


                                </Drillthrough>


                              </Action>


                            </Actions>


                          </ActionInfo>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


                              <Style></Style>Solid</Style>


                            </Border>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                  </TablixCells>


                </TablixRow>


                <TablixRow>


                  <Height>0.25in</Height>


                  <TablixCells>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox1">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>User Defined</Label>


                                  <Value>=Code.GetLocTable("LT_Report").GetString("B", "[User Defined]")</Value>


                                  <Style></Style>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox1</rd:DefaultName>


                          <ActionInfo>


                            <Actions>


                              <Action>


                                <Drillthrough>


                                  <ReportName>../Report.ContractManagement.Folder/Provance.ITAssetManagement.Report.EndofContracts</ReportName>


                                  <Parameters>


                                    <Parameter Name="ContractType">


                                      <Value>UD</Value>


                                    </Parameter>


                                    <Parameter Name="ThresholdContractExpired">


                                      <Value>=Parameters!ThresholdContractExpired.Value</Value>


                                    </Parameter>


                                    <Parameter Name="ThresholdContractCloseToExpired">


                                      <Value>=Parameters!ThresholdContractCloseToExpired.Value</Value>


                                    </Parameter>


                                    <Parameter Name="Threshold">


                                      <Value>AL</Value>


                                    </Parameter>


                                  </Parameters>


                                </Drillthrough>


                              </Action>


                            </Actions>


                          </ActionInfo>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


                              <Style></Style>Solid</Style>


                            </Border>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox2">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Expired</Label>


                                  <Value>=Sum(IIf(Fields!ContractType.Value = "UserDefined",Fields!Expired.Value,0))</Value>


                                  <Style /></Style>


                                </TextRun>


                              </TextRuns>


                              <Style></Style>


                                <TextAlign>Center</TextAlign>


                              </Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox2</rd:DefaultName>


                          <ActionInfo>


                            <Actions>


                              <Action>


                                <Drillthrough>


                                  <ReportName>../Report.ContractManagement.Folder/Provance.ITAssetManagement.Report.EndofContracts</ReportName>


                                  <Parameters>


                                    <Parameter Name="ContractType">


                                      <Value>UD</Value>


                                    </Parameter>


                                    <Parameter Name="ThresholdContractExpired">


                                      <Value>=Parameters!ThresholdContractExpired.Value</Value>


                                    </Parameter>


                                    <Parameter Name="ThresholdContractCloseToExpired">


                                      <Value>=Parameters!ThresholdContractCloseToExpired.Value</Value>


                                    </Parameter>


                                    <Parameter Name="Threshold">


                                      <Value>EX</Value>


                                    </Parameter>


                                  </Parameters>


                                </Drillthrough>


                              </Action>


                            </Actions>


                          </ActionInfo>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


                              <Style></Style>Solid</Style>


                            </Border>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox3">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Close</Label>


                                  <Value>=Sum(IIf(Fields!ContractType.Value = "UserDefined",Fields!CloseToExpired.Value,0))</Value>


                                  <Style /></Style>


                                </TextRun>


                              </TextRuns>


                              <Style></Style>


                                <TextAlign>Center</TextAlign>


                              </Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox3</rd:DefaultName>


                          <ActionInfo>


                            <Actions>


                              <Action>


                                <Drillthrough>


                                  <ReportName>../Report.ContractManagement.Folder/Provance.ITAssetManagement.Report.EndofContracts</ReportName>


                                  <Parameters>


                                    <Parameter Name="ContractType">


                                      <Value>UD</Value>


                                    </Parameter>


                                    <Parameter Name="ThresholdContractExpired">


                                      <Value>=Parameters!ThresholdContractExpired.Value</Value>


                                    </Parameter>


                                    <Parameter Name="ThresholdContractCloseToExpired">


                                      <Value>=Parameters!ThresholdContractCloseToExpired.Value</Value>


                                    </Parameter>


                                    <Parameter Name="Threshold">


                                      <Value>CL</Value>


                                    </Parameter>


                                  </Parameters>


                                </Drillthrough>


                              </Action>


                            </Actions>


                          </ActionInfo>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


                              <Style></Style>Solid</Style>


                            </Border>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox4">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Good</Label>


                                  <Value>=Sum(IIf(Fields!ContractType.Value = "UserDefined",Fields!Good.Value,0))</Value>


                                  <Style /></Style>


                                </TextRun>


                              </TextRuns>


                              <Style></Style>


                                <TextAlign>Center</TextAlign>


                              </Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox4</rd:DefaultName>


                          <ActionInfo>


                            <Actions>


                              <Action>


                                <Drillthrough>


                                  <ReportName>../Report.ContractManagement.Folder/Provance.ITAssetManagement.Report.EndofContracts</ReportName>


                                  <Parameters>


                                    <Parameter Name="ContractType">


                                      <Value>UD</Value>


                                    </Parameter>


                                    <Parameter Name="ThresholdContractExpired">


                                      <Value>=Parameters!ThresholdContractExpired.Value</Value>


                                    </Parameter>


                                    <Parameter Name="ThresholdContractCloseToExpired">


                                      <Value>=Parameters!ThresholdContractCloseToExpired.Value</Value>


                                    </Parameter>


                                    <Parameter Name="Threshold">


                                      <Value>GO</Value>


                                    </Parameter>


                                  </Parameters>


                                </Drillthrough>


                              </Action>


                            </Actions>


                          </ActionInfo>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


                              <Style></Style>Solid</Style>


                            </Border>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                  </TablixCells>


                </TablixRow>


              </TablixRows>


            </TablixBody>


            <TablixColumnHierarchy>


              <TablixMembers>


                <TablixMember />


                <TablixMember />


                <TablixMember />


                <TablixMember />


              </TablixMembers>


            </TablixColumnHierarchy>


            <TablixRowHierarchy>


              <TablixMembers>


                <TablixMember>


                  <KeepWithGroup>After</KeepWithGroup>


                </TablixMember>


                <TablixMember>


                  <KeepWithGroup>After</KeepWithGroup>


                </TablixMember>


                <TablixMember>


                  <Group Name="Details">


                    <GroupExpressions>


                      <GroupExpression>=Fields!GroupingProperty.Value</GroupExpression>


                    </GroupExpressions>


                  </Group>


                  <TablixMembers>


                    <TablixMember />


                    <TablixMember />


                    <TablixMember />


                    <TablixMember />


                    <TablixMember />


                  </TablixMembers>


                </TablixMember>


              </TablixMembers>


            </TablixRowHierarchy>


            <NoRowsMessage>=Code.GetLocTable("LT_Report").GetString("A", "[No Data Available]")</NoRowsMessage>


            <DataSetName>ContractExpiration</DataSetName>


            <Top>0.4in</Top>


            <Left>0.05in</Left>


            <Height>2.08749in</Height>


            <Width>2.3in</Width>


            <Style></Style>


              <Border>


                <Style></Style>None</Style>


              </Border>


            </Style>


          </Tablix>


          <Textbox Name="Textbox29">


            <CanGrow>true</CanGrow>


            <KeepTogether>true</KeepTogether>


            <Paragraphs>


              <Paragraph>


                <TextRuns>


                  <TextRun>


                    <Label>Contract Expiration</Label>


                    <Value>=Code.GetLocTable("LT_Report").GetString("ElementContractExpiration", "[Contract Expiration]")</Value>


                    <Style></Style>


                      <FontWeight>Bold</FontWeight>


                    </Style>


                  </TextRun>


                </TextRuns>


                <Style /></Style>


              </Paragraph>


            </Paragraphs>


            <rd:DefaultName>Textbox29</rd:DefaultName>


            <Top>0.1in</Top>


            <Left>0.05in</Left>


            <Height>0.28806in</Height>


            <Width>2.3in</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>


        </ReportItems>


        <KeepTogether>true</KeepTogether>


        <Top>6.11245in</Top>


        <Left>4.975in</Left>


        <Height>2.96875in</Height>


        <Width>2.4in</Width>


        <ZIndex>7</ZIndex>


        <Style></Style>


          <Border>


            <Color>LightGrey</Color>


            <Style></Style>Solid</Style>


          </Border>


        </Style>


      </Rectangle>


    </ReportItems>


    <Height>9.0812in</Height>


    <Style /></Style>


  </Script></Body>


  <Width>7.375in</Width>


  <Page>


    <PageHeader>


      <Height>0.577in</Height>


      <PrintOnFirstPage>true</PrintOnFirstPage>


      <PrintOnLastPage>true</PrintOnLastPage>


      <ReportItems>


        <Textbox Name="Textbox14">


          <CanGrow>true</CanGrow>


          <KeepTogether>true</KeepTogether>


          <Paragraphs>


            <Paragraph>


              <TextRuns>


                <TextRun>


                  <Value>=Code.GetLocTable("LT_Report").GetString("ReportName", "[ReportName]")</Value>


                  <Style></Style>


                    <FontFamily>Tahoma</FontFamily>


                    <FontSize>11pt</FontSize>


                    <FontWeight>Bold</FontWeight>


                  </Style>


                </TextRun>


              </TextRuns>


              <Style></Style>


                <TextAlign>Left</TextAlign>


              </Style>


            </Paragraph>


          </Paragraphs>


          <rd:DefaultName>Textbox9</rd:DefaultName>


          <Height>0.577in</Height>


          <Width>3.037in</Width>


          <Style></Style>


            <Border>


              <Style></Style>None</Style>


            </Border>


            <VerticalAlign>Bottom</VerticalAlign>


            <PaddingLeft>2pt</PaddingLeft>


            <PaddingRight>2pt</PaddingRight>


            <PaddingTop>2pt</PaddingTop>


            <PaddingBottom>2pt</PaddingBottom>


          </Style>


        </Textbox>


        <Image Name="Image3">


          <Source>External</Source>


          <Value>ReportHeaderR.png</Value>


          <Sizing>FitProportional</Sizing>


          <Left>3.038in</Left>


          <Height>0.577in</Height>


          <Width>4.287in</Width>


          <ZIndex>1</ZIndex>


          <Style></Style>


            <Border>


              <Style></Style>None</Style>


            </Border>


          </Style>


        </Image>


      </ReportItems>


      <Style></Style>


        <Border>


          <Style></Style>None</Style>


        </Border>


        <BackgroundColor>#bfd0ea</BackgroundColor>


      </Style>


    </PageHeader>


    <LeftMargin>0.5in</LeftMargin>


    <RightMargin>0.5in</RightMargin>


    <TopMargin>0.5in</TopMargin>


    <BottomMargin>0.5in</BottomMargin>


    <Style /></Style>


  </Page>


  <AutoRefresh>0</AutoRefresh>


  <DataSources>


    <DataSource Name="DWDataMart">


      <DataSourceReference>DWDataMart</DataSourceReference>


      <rd:SecurityType>None</rd:SecurityType>


      <rd:DataSourceID>17f1ddbd-dd74-4498-be36-12e44eb4ebea</rd:DataSourceID>


    </DataSource>


  </DataSources>


  <DataSets>


    <DataSet Name="LT_Report">


      <Query>


        <DataSourceName>DWDataMart</DataSourceName>


        <QueryParameters>


          <QueryParameter Name="@ManagementPackSystemName">


            <Value>Provance.ServiceManager.Itam.Hardware.Reports</Value>


          </QueryParameter>


          <QueryParameter Name="@ReportSystemName">


            <Value>Provance.ITAssetManagement.Report.HardwareAssetManagementDashboard</Value>


          </QueryParameter>


          <QueryParameter Name="@LanguageCode">


            <Value>=Code.GetReportLocLanguageCode()</Value>


          </QueryParameter>


          <QueryParameter Name="@Scope">


            <Value>%</Value>


          </QueryParameter>


        </QueryParameters>


        <CommandType>StoredProcedure</CommandType>


        <CommandText>ReportDisplayStringGet</CommandText>


        <rd:UseGenericDesigner>true</rd:UseGenericDesigner>


      </Query>


      <Fields>


        <Field Name="XML_F52E2B61_18A1_11d1_B105_00805F49916B">


          <DataField>XML_F52E2B61-18A1-11d1-B105-00805F49916B</DataField>


          <rd:TypeName>System.String</rd:TypeName>


        </Field>


      </Fields>


    </DataSet>


    <DataSet Name="AssetsByLocation">


      <Query>


        <DataSourceName>DWDataMart</DataSourceName>


        <QueryParameters>


          <QueryParameter Name="@LifecycleStatusDisposed">


            <Value>92E2D8B3-38A2-EE18-FD1C-4850CE27691F</Value>


          </QueryParameter>


          <QueryParameter Name="@ObjectStatusPendingDelete">


            <Value>System.ConfigItem.ObjectStatusEnum.PendingDelete</Value>


          </QueryParameter>


          <QueryParameter Name="@LifecycleStatusReturned">


            <Value>EE95CD64-CB09-1FB7-FB74-67AF3B469044</Value>


          </QueryParameter>


        </QueryParameters>


        <CommandText>SELECT  COUNT(X.HardwareAssetDimKey) AS AssetCount, X.DisplayName, X.TotalAssetCount, X.LocationDimKey


FROM (


SELECT A.HardwareAssetDimKey, CASE 


								WHEN (C.HardwareAssetHasLocation_LocationDimKey IS NULL OR D.LocationDimKey IS NULL) THEN 


									'Unknown'


								ELSE


									D.DisplayName


								END As DisplayName, E.TotalAssetCount, 


								IsNull(D.LocationDimKey,-1) AS LocationDimKey


FROM HardwareAssetDim A


INNER JOIN HardwareAssetLifecycleStatusvw B ON (A.LifecycleStatus_HardwareAssetLifecycleStatusId = B.HardwareAssetLifecycleStatusId


											AND B.EnumTypeId NOT IN( @LifecycleStatusDisposed,@LifecycleStatusReturned))


LEFT OUTER JOIN HardwareAssetLocationFactvw C ON (A.HardwareAssetDimKey = C.HardwareAssetDimKey


											AND C.DeletedDate IS NULL)


LEFT OUTER JOIN LocationDimvw D ON D.LocationDimKey = dbo.ProvanceFunc_GetParentLocation(C.HardwareAssetHasLocation_LocationDimKey)


								AND D.IsDeleted = 0


								AND (D.ObjectStatus IS NULL OR D.ObjectStatus &lt;&gt; @ObjectStatusPendingDelete)


INNER JOIN (SELECT COUNT(X.HardwareAssetDimKey) AS TotalAssetCount


			FROM HardwareAssetDimvw X


			INNER JOIN HardwareAssetLifecycleStatusvw Y ON (X.LifecycleStatus_HardwareAssetLifecycleStatusId = Y.HardwareAssetLifecycleStatusId


														AND Y.EnumTypeId NOT IN (@LifecycleStatusDisposed,@LifecycleStatusReturned))


			AND X.IsDeleted = 0


			AND (X.ObjectStatus IS NULL OR X.ObjectStatus &lt;&gt; @ObjectStatusPendingDelete)) E ON 1=1


WHERE A.IsDeleted = 0


AND (A.ObjectStatus IS NULL OR A.ObjectStatus &lt;&gt; @ObjectStatusPendingDelete)


	) X


GROUP BY X.DisplayName, X.TotalAssetCount, X.LocationDimKey</CommandText>


        <rd:UseGenericDesigner>true</rd:UseGenericDesigner>


      </Query>


      <Fields>


        <Field Name="AssetCount">


          <DataField>AssetCount</DataField>


          <rd:TypeName>System.Int32</rd:TypeName>


        </Field>


        <Field Name="DisplayName">


          <DataField>DisplayName</DataField>


          <rd:TypeName>System.String</rd:TypeName>


        </Field>


        <Field Name="TotalAssetCount">


          <DataField>TotalAssetCount</DataField>


          <rd:TypeName>System.Int32</rd:TypeName>


        </Field>


        <Field Name="LocationDimKey">


          <DataField>LocationDimKey</DataField>


          <rd:TypeName>System.Int32</rd:TypeName>


        </Field>


      </Fields>


    </DataSet>


    <DataSet Name="AssetByCostCenter">


      <Query>


        <DataSourceName>DWDataMart</DataSourceName>


        <QueryParameters>


          <QueryParameter Name="@LifecycleStatusDisposed">


            <Value>92E2D8B3-38A2-EE18-FD1C-4850CE27691F</Value>


          </QueryParameter>


          <QueryParameter Name="@ObjectStatusPendingDelete">


            <Value>System.ConfigItem.ObjectStatusEnum.PendingDelete</Value>


          </QueryParameter>


          <QueryParameter Name="@LifecycleStatusReturned">


            <Value>EE95CD64-CB09-1FB7-FB74-67AF3B469044</Value>


          </QueryParameter>


        </QueryParameters>


        <CommandText>SELECT COUNT(X.HardwareAssetDimKey) AS AssetCount, X.DisplayName, X.TotalAssetCount, X.CostCenterDimKey


FROM (


SELECT A.HardwareAssetDimKey, CASE


								WHEN (C.HardwareAssetHasCostCenter_CostCenterDimKey IS NULL OR D.CostCenterDimKey IS NULL) THEN


									'Unknown'


								ELSE


									D.DisplayName


								END As DisplayName, E.TotalAssetCount, IsNull(D.CostCenterDimKey,-1) AS CostCenterDimKey


FROM HardwareAssetDim A


INNER JOIN HardwareAssetLifecycleStatusvw B ON (A.LifecycleStatus_HardwareAssetLifecycleStatusId = B.HardwareAssetLifecycleStatusId


											AND B.EnumTypeId NOT IN (@LifecycleStatusDisposed, @LifecycleStatusReturned))


LEFT OUTER JOIN HardwareAssetCostCenterFactvw C ON (A.HardwareAssetDimKey = C.HardwareAssetDimKey


											AND C.DeletedDate IS NULL)


LEFT OUTER JOIN CostCenterDimvw D ON D.CostCenterDimKey = dbo.ProvanceFunc_GetParentCostCenter(C.HardwareAssetHasCostCenter_CostCenterDimKey)


									AND D.IsDeleted = 0


									AND (D.ObjectStatus IS NULL OR D.ObjectStatus &lt;&gt; @ObjectStatusPendingDelete)


INNER JOIN (SELECT COUNT(X.HardwareAssetDimKey) AS TotalAssetCount


			FROM HardwareAssetDimvw X


			INNER JOIN HardwareAssetLifecycleStatusvw Y ON (X.LifecycleStatus_HardwareAssetLifecycleStatusId = Y.HardwareAssetLifecycleStatusId


														AND Y.EnumTypeId NOT IN (@LifecycleStatusDisposed,@LifecycleStatusReturned))


			AND X.IsDeleted = 0


			AND (X.ObjectStatus IS NULL OR X.ObjectStatus &lt;&gt; @ObjectStatusPendingDelete)) E ON 1=1


WHERE A.IsDeleted = 0


AND (A.ObjectStatus IS NULL OR A.ObjectStatus &lt;&gt; @ObjectStatusPendingDelete)


) X


GROUP BY X.DisplayName, X.TotalAssetCount, X.CostCenterDimKey</CommandText>


        <rd:UseGenericDesigner>true</rd:UseGenericDesigner>


      </Query>


      <Fields>


        <Field Name="AssetCount">


          <DataField>AssetCount</DataField>


          <rd:TypeName>System.Int32</rd:TypeName>


        </Field>


        <Field Name="DisplayName">


          <DataField>DisplayName</DataField>


          <rd:TypeName>System.String</rd:TypeName>


        </Field>


        <Field Name="TotalAssetCount">


          <DataField>TotalAssetCount</DataField>


          <rd:TypeName>System.Int32</rd:TypeName>


        </Field>


        <Field Name="CostCenterDimKey">


          <DataField>CostCenterDimKey</DataField>


          <rd:TypeName>System.Int32</rd:TypeName>


        </Field>


      </Fields>


    </DataSet>


    <DataSet Name="AssetsByOrganization">


      <Query>


        <DataSourceName>DWDataMart</DataSourceName>


        <QueryParameters>


          <QueryParameter Name="@LifecycleStatusDisposed">


            <Value>92E2D8B3-38A2-EE18-FD1C-4850CE27691F</Value>


          </QueryParameter>


          <QueryParameter Name="@ObjectStatusPendingDelete">


            <Value>System.ConfigItem.ObjectStatusEnum.PendingDelete</Value>


          </QueryParameter>


          <QueryParameter Name="@LifecycleStatusReturned">


            <Value>EE95CD64-CB09-1FB7-FB74-67AF3B469044</Value>


          </QueryParameter>


        </QueryParameters>


        <CommandText>SELECT COUNT(X.HardwareAssetDimKey) AS AssetCount, X.DisplayName, X.TotalAssetCount, X.OrganizationDimKey


FROM (


SELECT A.HardwareAssetDimKey, CASE


								WHEN (C.HardwareAssetHasOrganization_OrganizationDimKey IS NULL OR D.OrganizationDimKey IS NULL) THEN


									'Unknown'


								ELSE


									D.DisplayName


								END AS DisplayName, E.TotalAssetCount, IsNull(D.OrganizationDimKey,-1) AS OrganizationDimKey


FROM HardwareAssetDim A


INNER JOIN HardwareAssetLifecycleStatusvw B ON (A.LifecycleStatus_HardwareAssetLifecycleStatusId = B.HardwareAssetLifecycleStatusId


											AND B.EnumTypeId NOT IN (@LifecycleStatusDisposed,@LifecycleStatusReturned))


LEFT OUTER JOIN HardwareAssetOrganizationFactvw C ON (A.HardwareAssetDimKey = C.HardwareAssetDimKey


											AND C.DeletedDate IS NULL)


LEFT OUTER JOIN OrganizationDimvw D ON D.OrganizationDimKey = dbo.ProvanceFunc_GetParentOrganization(C.HardwareAssetHasOrganization_OrganizationDimKey)


									AND D.IsDeleted = 0


									AND (D.ObjectStatus IS NULL OR D.ObjectStatus &lt;&gt; @ObjectStatusPendingDelete)


INNER JOIN (SELECT COUNT(X.HardwareAssetDimKey) AS TotalAssetCount


			FROM HardwareAssetDimvw X


			INNER JOIN HardwareAssetLifecycleStatusvw Y ON (X.LifecycleStatus_HardwareAssetLifecycleStatusId = Y.HardwareAssetLifecycleStatusId


														AND Y.EnumTypeId NOT IN (@LifecycleStatusDisposed,@LifecycleStatusReturned))


			AND X.IsDeleted = 0


			AND (X.ObjectStatus IS NULL OR X.ObjectStatus &lt;&gt; @ObjectStatusPendingDelete)) E ON 1=1


WHERE A.IsDeleted = 0


AND (A.ObjectStatus IS NULL OR A.ObjectStatus &lt;&gt; @ObjectStatusPendingDelete)


) X


GROUP BY X.DisplayName, X.TotalAssetCount, X.OrganizationDimKey</CommandText>


        <rd:UseGenericDesigner>true</rd:UseGenericDesigner>


      </Query>


      <Fields>


        <Field Name="AssetCount">


          <DataField>AssetCount</DataField>


          <rd:TypeName>System.Int32</rd:TypeName>


        </Field>


        <Field Name="DisplayName">


          <DataField>DisplayName</DataField>


          <rd:TypeName>System.String</rd:TypeName>


        </Field>


        <Field Name="TotalAssetCount">


          <DataField>TotalAssetCount</DataField>


          <rd:TypeName>System.Int32</rd:TypeName>


        </Field>


        <Field Name="OrganizationDimKey">


          <DataField>OrganizationDimKey</DataField>


          <rd:TypeName>System.Int32</rd:TypeName>


        </Field>


      </Fields>


    </DataSet>


    <DataSet Name="InvestmentByManufacturer">


      <Query>


        <DataSourceName>DWDataMart</DataSourceName>


        <QueryParameters>


          <QueryParameter Name="@ObjectStatusPendingDelete">


            <Value>System.ConfigItem.ObjectStatusEnum.PendingDelete</Value>


          </QueryParameter>


        </QueryParameters>


        <CommandText>SELECT SUM(Z.Cost) AS Cost, MIN(Z.BaseISOCurrencySymbol) AS CostIsoCurrencyCode, Z.DisplayName, Z.ReceivedDate, Z.CompanyDimKey


FROM 


(


	SELECT A.Cost, DATEADD(MONTH,DATEDIFF(MONTH,0,A.ReceivedDate),0) AS ReceivedDate, E.DisplayName, E.CompanyDimKey, F.ISOCurrencySymbol BaseISOCurrencySymbol


	FROM 


	(


		SELECT	H.HardwareAssetDimKey, H.ObjectStatus, H.IsDeleted, H.ReceivedDate,


				H.Cost*H.AdjustedExchangeRate AS Cost


		FROM


		(


			SELECT  F.*,


					CASE


							WHEN ExchangeRate is null THEN 1


							ELSE ExchangeRate


					END as AdjustedExchangeRate


			FROM	HardwareAssetDimvw  F


			LEFT JOIN	CurrencyDimvw	G ON F.CostIsoCurrencyCode = G.ISOCurrencySymbol


											 AND G.IsDeleted = 0


											 AND G.SourceId =


											 (


												SELECT	MAX(CONVERT(VARCHAR(50),SourceId)) AS SourceId


												FROM	BaseCurrencyDimvw


												WHERE	IsDeleted = 0


											 )


		)	H


	) A


	INNER JOIN HardwareAssetHardwareCatalogItemFactvw B ON A.HardwareAssetDimKey = B.HardwareAssetDimKey


														AND B.DeletedDate IS NULL


	INNER JOIN HardwareCatalogDimvw C ON B.HardwareAssetIsHardwareCatalogItem_HardwareCatalogDimKey = C.HardwareCatalogDimKey


										AND C.IsDeleted = 0


										AND (C.ObjectStatus IS NULL OR C.ObjectStatus &lt;&gt; @ObjectStatusPendingDelete)


	INNER JOIN HardwareCatalogItemManufacturerFactvw D ON C.HardwareCatalogDimKey = D.HardwareCatalogDimKey


														AND D.DeletedDate IS NULL


	INNER JOIN CompanyDimvw E ON D.HardwareCatalogItemHasManufacturer_CompanyDimKey = E.CompanyDimKey


								AND E.IsDeleted = 0


								AND (E.ObjectStatus IS NULL OR E.ObjectStatus &lt;&gt; @ObjectStatusPendingDelete)


	LEFT JOIN 


			( 


				SELECT	* 


				FROM	BaseCurrencyDimvw


				WHERE	SourceId =


				(


					SELECT	MAX(CONVERT(VARCHAR(50),SourceId)) AS SourceId


					FROM	BaseCurrencyDimvw


					WHERE	IsDeleted = 0


				)


			)			F ON F.IsDeleted = 0				


	WHERE A.IsDeleted = 0


	AND (A.ObjectStatus IS NULL OR A.ObjectStatus &lt;&gt; @ObjectStatusPendingDelete)


	AND DATEDIFF(mm,A.ReceivedDate,GetDate()) &lt; 13


) Z


INNER JOIN 


(


	SELECT TOP 10 SUM(A.Cost) AS Cost, E.CompanyDimKey


	FROM 


	(


		SELECT	H.HardwareAssetDimKey, H.ObjectStatus, H.IsDeleted, H.ReceivedDate,


				H.Cost*H.AdjustedExchangeRate AS Cost


		FROM


		(


			SELECT  F.*,


					CASE


							WHEN ExchangeRate is null THEN 1


							ELSE ExchangeRate


					END as AdjustedExchangeRate


			FROM	HardwareAssetDimvw  F


			LEFT JOIN	CurrencyDimvw	G ON F.CostIsoCurrencyCode = G.ISOCurrencySymbol


											 AND G.IsDeleted = 0


											 AND G.SourceId =


											 (


												SELECT	MAX(CONVERT(VARCHAR(50),SourceId)) AS SourceId


												FROM	BaseCurrencyDimvw


												WHERE	IsDeleted = 0


											 )


		)	H


	)A


	INNER JOIN HardwareAssetHardwareCatalogItemFactvw B ON A.HardwareAssetDimKey = B.HardwareAssetDimKey


														AND B.DeletedDate IS NULL


	INNER JOIN HardwareCatalogDimvw C ON B.HardwareAssetIsHardwareCatalogItem_HardwareCatalogDimKey = C.HardwareCatalogDimKey


										AND C.IsDeleted = 0


										AND (C.ObjectStatus IS NULL OR C.ObjectStatus &lt;&gt; @ObjectStatusPendingDelete)


	INNER JOIN HardwareCatalogItemManufacturerFactvw D ON C.HardwareCatalogDimKey = D.HardwareCatalogDimKey


														AND D.DeletedDate IS NULL


	INNER JOIN CompanyDimvw E ON D.HardwareCatalogItemHasManufacturer_CompanyDimKey = E.CompanyDimKey


								AND E.IsDeleted = 0


								AND (E.ObjectStatus IS NULL OR E.ObjectStatus &lt;&gt; @ObjectStatusPendingDelete)


	WHERE A.IsDeleted = 0


	AND (A.ObjectStatus IS NULL OR A.ObjectStatus &lt;&gt; @ObjectStatusPendingDelete)


	AND DATEDIFF(mm,A.ReceivedDate,GetDate()) &lt; 13


	GROUP BY E.CompanyDimKey


	ORDER BY Cost Desc


) Y ON Z.CompanyDimKey = Y.CompanyDimKey


GROUP BY Z.CompanyDimKey, Z.DisplayName, Z.ReceivedDate


ORDER BY Z.DisplayName, Z.ReceivedDate</CommandText>


        <rd:UseGenericDesigner>true</rd:UseGenericDesigner>


      </Query>


      <Fields>


        <Field Name="Cost">


          <DataField>Cost</DataField>


          <rd:TypeName>System.Double</rd:TypeName>


        </Field>


        <Field Name="DisplayName">


          <DataField>DisplayName</DataField>


          <rd:TypeName>System.String</rd:TypeName>


        </Field>


        <Field Name="CostIsoCurrencyCode">


          <DataField>CostIsoCurrencyCode</DataField>


          <rd:TypeName>System.String</rd:TypeName>


        </Field>


        <Field Name="ReceivedDate">


          <DataField>ReceivedDate</DataField>


          <rd:TypeName>System.DateTime</rd:TypeName>


        </Field>


        <Field Name="CompanyDimKey">


          <DataField>CompanyDimKey</DataField>


          <rd:TypeName>System.Int32</rd:TypeName>


        </Field>


      </Fields>


    </DataSet>


    <DataSet Name="InvestmentBySupplier">


      <Query>


        <DataSourceName>DWDataMart</DataSourceName>


        <QueryParameters>


          <QueryParameter Name="@ObjectStatusPendingDelete">


            <Value>System.ConfigItem.ObjectStatusEnum.PendingDelete</Value>


          </QueryParameter>


        </QueryParameters>


        <CommandText>SELECT SUM(Z.Cost) AS Cost, MIN(Z.BaseISOCurrencySymbol) AS CostIsoCurrencyCode, Z.DisplayName, Z.ReceivedDate, Z.CompanyDimKey


FROM (


	SELECT A.Cost, DATEADD(MONTH, DATEDIFF(MONTH, 0, A.ReceivedDate), 0) as ReceivedDate, C.DisplayName, C.CompanyDimKey, D.ISOCurrencySymbol BaseISOCurrencySymbol


	FROM (


		SELECT	H.HardwareAssetDimKey, H.ObjectStatus, H.IsDeleted, H.ReceivedDate, H.Cost*H.AdjustedExchangeRate AS Cost


		FROM


		(


			SELECT  F.*,


					CASE


							WHEN ExchangeRate is null THEN 1


							ELSE ExchangeRate


					END as AdjustedExchangeRate


			FROM	HardwareAssetDimvw  F


			LEFT JOIN	CurrencyDimvw	G ON F.CostIsoCurrencyCode = G.ISOCurrencySymbol


											 AND G.IsDeleted = 0


											 AND G.SourceId =


											 (


												SELECT	MAX(CONVERT(VARCHAR(50),SourceId)) AS SourceId


												FROM	BaseCurrencyDimvw


												WHERE	IsDeleted = 0


											 )


		)	H	


	) A


	INNER JOIN HardwareAssetSupplierFactvw B ON A.HardwareAssetDimKey = B.HardwareAssetDimKey


												AND B.DeletedDate IS NULL


	INNER JOIN CompanyDimvw C ON B.HardwareAssetHasSupplier_CompanyDimKey = C.CompanyDimKey


	LEFT JOIN 


			( 


				SELECT	* 


				FROM	BaseCurrencyDimvw


				WHERE	SourceId =


				(


					SELECT	MAX(CONVERT(VARCHAR(50),SourceId)) AS SourceId


					FROM	BaseCurrencyDimvw


					WHERE	IsDeleted = 0


				)


			) D ON D.IsDeleted = 0


	WHERE A.IsDeleted = 0


	AND (A.ObjectStatus IS NULL OR A.ObjectStatus &lt;&gt; @ObjectStatusPendingDelete)


	AND DATEDIFF(mm,A.ReceivedDate,GetDate()) &lt; 13


	) Z


INNER JOIN (


	SELECT TOP 10 SUM(X.Cost) AS Cost,X.CompanyDimKey


	FROM (


		SELECT A.Cost, C.CompanyDimKey


		FROM 


		(


			SELECT	H.HardwareAssetDimKey, H.ObjectStatus, H.IsDeleted, H.ReceivedDate, H.Cost*H.AdjustedExchangeRate AS Cost


			FROM


			(


				SELECT  F.*,


						CASE


								WHEN ExchangeRate is null THEN 1


								ELSE ExchangeRate


						END as AdjustedExchangeRate


				FROM	HardwareAssetDimvw  F


				LEFT JOIN	CurrencyDimvw	G ON F.CostIsoCurrencyCode = G.ISOCurrencySymbol


												 AND G.IsDeleted = 0


												 AND G.SourceId =


												 (


													SELECT	MAX(CONVERT(VARCHAR(50),SourceId)) AS SourceId


													FROM	BaseCurrencyDimvw


													WHERE	IsDeleted = 0


												 )


			)	H


		) A


		INNER JOIN HardwareAssetSupplierFactvw B ON A.HardwareAssetDimKey = B.HardwareAssetDimKey


													AND B.DeletedDate IS NULL


		INNER JOIN CompanyDimvw C ON B.HardwareAssetHasSupplier_CompanyDimKey = C.CompanyDimKey


		WHERE A.IsDeleted = 0


		AND (A.ObjectStatus IS NULL OR A.ObjectStatus &lt;&gt; @ObjectStatusPendingDelete)


		 AND DATEDIFF(mm,A.ReceivedDate,GetDate()) &lt; 13


		) X


	GROUP BY X.CompanyDimKey


	ORDER BY Cost DESC


) Y ON Y.CompanyDimKey = Z.CompanyDimKey


GROUP BY Z.CompanyDimKey, Z.DisplayName, Z.ReceivedDate


ORDER BY Z.DisplayName, Z.ReceivedDate</CommandText>


        <rd:UseGenericDesigner>true</rd:UseGenericDesigner>


      </Query>


      <Fields>


        <Field Name="Cost">


          <DataField>Cost</DataField>


          <rd:TypeName>System.Double</rd:TypeName>


        </Field>


        <Field Name="DisplayName">


          <DataField>DisplayName</DataField>


          <rd:TypeName>System.String</rd:TypeName>


        </Field>


        <Field Name="CostIsoCurrencyCode">


          <DataField>CostIsoCurrencyCode</DataField>


          <rd:TypeName>System.String</rd:TypeName>


        </Field>


        <Field Name="ReceivedDate">


          <DataField>ReceivedDate</DataField>


          <rd:TypeName>System.DateTime</rd:TypeName>


        </Field>


        <Field Name="CompanyDimKey">


          <DataField>CompanyDimKey</DataField>


          <rd:TypeName>System.Int32</rd:TypeName>


        </Field>


      </Fields>


    </DataSet>


    <DataSet Name="AgeOfAsset">


      <Query>


        <DataSourceName>DWDataMart</DataSourceName>


        <QueryParameters>


          <QueryParameter Name="@LifecycleStatusDisposed">


            <Value>92E2D8B3-38A2-EE18-FD1C-4850CE27691F</Value>


          </QueryParameter>


          <QueryParameter Name="@ObjectStatusPendingDelete">


            <Value>System.ConfigItem.ObjectStatusEnum.PendingDelete</Value>


          </QueryParameter>


          <QueryParameter Name="@LifecycleStatusReturned">


            <Value>EE95CD64-CB09-1FB7-FB74-67AF3B469044</Value>


          </QueryParameter>


        </QueryParameters>


        <CommandText>SELECT SUM(D.AssetCount) AS AssetCount, D.AgeGroup, D.TotalAssetCount


FROM (		


SELECT 1 AS AssetCount, CASE WHEN (DATEDIFF(yy,IsNull(A.ReceivedDate,DATEADD(yy,2,GetDate())),GetDate())) &lt; 0 THEN


								'Unknown'	


							WHEN (DATEDIFF(yy,IsNull(A.ReceivedDate,DATEADD(yy,2,GetDate())),GetDate())) BETWEEN 0 AND 1.9999 THEN


								'IsLessTwoYrs'


							WHEN (DATEDIFF(yy,IsNull(A.ReceivedDate,DATEADD(yy,2,GetDate())),GetDate())) BETWEEN 2 AND 5 THEN


								'IsBetweenTwoAndFiveYrs'


							WHEN (DATEDIFF(yy,IsNull(A.ReceivedDate,DATEADD(yy,2,GetDate())),GetDate()))&gt; 5.0001 THEN


								'IsGreaterFiveYrs'


							END As AgeGroup, E.TotalAssetCount


FROM HardwareAssetDimvw A


	INNER JOIN HardwareAssetLifecycleStatusvw B ON A.LifecycleStatus_HardwareAssetLifecycleStatusId = B.HardwareAssetLifecycleStatusId


												AND B.EnumTypeId NOT IN (@LifecycleStatusDisposed,@LifecycleStatusReturned)


	LEFT OUTER JOIN HardwareAssetLeaseContractFactvw C ON A.HardwareAssetDimKey = C.HardwareAssetDimKey


														AND C.DeletedDate IS NULL


	INNER JOIN (SELECT COUNT(X.HardwareAssetDimKey) AS TotalAssetCount


			FROM HardwareAssetDimvw X


			INNER JOIN HardwareAssetLifecycleStatusvw Y ON (X.LifecycleStatus_HardwareAssetLifecycleStatusId = Y.HardwareAssetLifecycleStatusId


														AND Y.EnumTypeId NOT IN (@LifecycleStatusDisposed,@LifecycleStatusReturned))


			LEFT OUTER JOIN HardwareAssetLeaseContractFactvw Z ON X.HardwareAssetDimKey = Z.HardwareAssetDimKey


														AND Z.DeletedDate IS NULL	


			WHERE Z.HardwareAssetDimKey IS NULL


			AND X.IsDeleted=0


			AND (X.ObjectStatus IS NULL OR X.ObjectStatus &lt;&gt; @ObjectStatusPendingDelete)) E ON 1=1


WHERE A.IsDeleted = 0


AND (A.ObjectStatus IS NULL OR A.ObjectStatus &lt;&gt; @ObjectStatusPendingDelete)


AND C.HardwareAssetDimKey IS NULL --only want owned assets, not leased


) D


GROUP BY D.AgeGroup, D.TotalAssetCount</CommandText>


        <rd:UseGenericDesigner>true</rd:UseGenericDesigner>


      </Query>


      <Fields>


        <Field Name="AssetCount">


          <DataField>AssetCount</DataField>


          <rd:TypeName>System.Int32</rd:TypeName>


        </Field>


        <Field Name="AgeGroup">


          <DataField>AgeGroup</DataField>


          <rd:TypeName>System.String</rd:TypeName>


        </Field>


        <Field Name="TotalAssetCount">


          <DataField>TotalAssetCount</DataField>


          <rd:TypeName>System.Int32</rd:TypeName>


        </Field>


      </Fields>


    </DataSet>


    <DataSet Name="AssetStatus">


      <Query>


        <DataSourceName>DWDataMart</DataSourceName>


        <QueryParameters>


          <QueryParameter Name="@LifecycleStatusDisposed">


            <Value>92E2D8B3-38A2-EE18-FD1C-4850CE27691F</Value>


          </QueryParameter>


          <QueryParameter Name="@ObjectStatusPendingDelete">


            <Value>System.ConfigItem.ObjectStatusEnum.PendingDelete</Value>


          </QueryParameter>


          <QueryParameter Name="@LifecycleStatusReturned">


            <Value>EE95CD64-CB09-1FB7-FB74-67AF3B469044</Value>


          </QueryParameter>


          <QueryParameter Name="@UserLanguage">


            <Value>=Code.GetReportLocLanguageCode()</Value>


            <rd:UserDefined>true</rd:UserDefined>


          </QueryParameter>


        </QueryParameters>


        <CommandText>SELECT C.HardwareAssetLifecycleStatusValue, C.HardwareAssetLifecycleStatusId,


	COUNT(A.HardwareAssetDimKey) AS AssetCount,


	COUNT(B.HardwareAssetHasLease_LeaseContractDimKey) As LeaseAssetCount,


	COUNT(A.HardwareAssetDimKey)-COUNT(B.HardwareAssetHasLease_LeaseContractDimKey) AS OwnedAssetCount,


	D.TotalAssetCount


FROM HardwareAssetDimvw A


INNER JOIN (SELECT COUNT(HardwareAssetDimKey) AS TotalAssetCount


			FROM HardwareAssetDimvw X


			INNER JOIN HardwareAssetLifecycleStatusvw Y ON (X.LifecycleStatus_HardwareAssetLifecycleStatusId = Y.HardwareAssetLifecycleStatusId


														AND Y.EnumTypeId NOT IN (@LifecycleStatusDisposed,@LifecycleStatusReturned))


			AND IsDeleted=0


			AND (ObjectStatus IS NULL OR ObjectStatus &lt;&gt; @ObjectStatusPendingDelete)) D ON 1=1


LEFT OUTER JOIN HardwareAssetLeaseContractFactvw B ON A.HardwareAssetDimKey = B.HardwareAssetDimKey


													AND B.DeletedDate IS NULL


INNER JOIN (SELECT A.HardwareAssetLifecycleStatusId, 


				ISNULL(B.DisplayName, A.HardwareAssetLifecycleStatusValue) AS HardwareAssetLifecycleStatusValue


			FROM HardwareAssetLifecycleStatusvw A


			LEFT OUTER JOIN DisplayStringDim B ON A.EnumTypeId = B.BaseManagedEntityId


												AND B.LanguageCode = @UserLanguage


			WHERE A.EnumTypeId NOT IN (@LifecycleStatusDisposed, @LifecycleStatusReturned)


										)	C ON A.LifecycleStatus_HardwareAssetLifecycleStatusId = C.HardwareAssetLifecycleStatusId


												


WHERE A.IsDeleted = 0


AND (A.ObjectStatus IS NULL OR A.ObjectStatus &lt;&gt; @ObjectStatusPendingDelete)


GROUP BY C.HardwareAssetLifecycleStatusId, C.HardwareAssetLifecycleStatusValue, D.TotalAssetCount


ORDER BY C.HardwareAssetLifecycleStatusValue</CommandText>


        <rd:UseGenericDesigner>true</rd:UseGenericDesigner>


      </Query>


      <Fields>


        <Field Name="HardwareAssetLifecycleStatusValue">


          <DataField>HardwareAssetLifecycleStatusValue</DataField>


          <rd:UserDefined>true</rd:UserDefined>


        </Field>


        <Field Name="HardwareAssetLifecycleStatusId">


          <DataField>HardwareAssetLifecycleStatusId</DataField>


          <rd:TypeName>System.Int32</rd:TypeName>


        </Field>


        <Field Name="AssetCount">


          <DataField>AssetCount</DataField>


          <rd:UserDefined>true</rd:UserDefined>


        </Field>


        <Field Name="LeaseAssetCount">


          <DataField>LeaseAssetCount</DataField>


          <rd:UserDefined>true</rd:UserDefined>


        </Field>


        <Field Name="OwnedAssetCount">


          <DataField>OwnedAssetCount</DataField>


          <rd:UserDefined>true</rd:UserDefined>


        </Field>


        <Field Name="TotalAssetCount">


          <DataField>TotalAssetCount</DataField>


          <rd:TypeName>System.Int32</rd:TypeName>


        </Field>


      </Fields>


    </DataSet>


    <DataSet Name="ContractExpiration">


      <Query>


        <DataSourceName>DWDataMart</DataSourceName>


        <QueryParameters>


          <QueryParameter Name="@ThresholdContractExpired">


            <Value>=Parameters!ThresholdContractExpired.Value</Value>


          </QueryParameter>


          <QueryParameter Name="@ThresholdContractCloseToExpired">


            <Value>=Parameters!ThresholdContractCloseToExpired.Value</Value>


          </QueryParameter>


        </QueryParameters>


        <CommandText>declare @objectStatusPendingDelete varchar(255),


	@EntityStatusActive varchar(255)


	


select @objectStatusPendingDelete = 'System.ConfigItem.ObjectStatusEnum.PendingDelete',


	@EntityStatusActive = 'EntityStatus.Active'











SELECT	1 As GroupingProperty,


	Z.ContractType,


	Sum(Case when datediff(d,GETDATE(),Z.ExpirationDate) &lt;= @ThresholdContractExpired		THEN 1	ELSE 0 END) AS Expired,


	Sum(Case WHen datediff(d,GETDATE(),Z.ExpirationDate)  &gt; @ThresholdContractExpired 


	          and datediff(d,GETDATE(),Z.ExpirationDate) &lt;= @ThresholdContractCloseToExpired	THEN 1	Else 0 END) AS CloseToExpired,


	Sum(Case When datediff(d,GETDATE(),Z.ExpirationDate)  &gt; @ThresholdContractCloseToExpired	THEN 1	Else 0 END) AS Good


FROM


(


SELECT 'Lease' AS ContractType, C.ExpirationDate


FROM	LeaseAgreementDimvw		A 


JOIN	LeaseAgreementContractFactvw	B ON A.LeaseAgreementDimKey					= B.LeaseAgreementDimKey	AND B.DeletedDate IS NULL


JOIN	LeaseContractDimvw		C ON B.LeaseAgreementContainsLeaseContract_LeaseContractDimKey	= C.LeaseContractDimKey 	AND C.IsDeleted=0 AND ISNULL(c.ObjectStatus,'') &lt;&gt; @objectStatusPendingDelete


WHERE A.IsDeleted = 0


AND ISNULL(a.ObjectStatus,'') &lt;&gt; @objectStatusPendingDelete


AND A.Status	= @EntityStatusActive


UNION ALL


SELECT	'Warranty' AS ContractType, C.ExpirationDate


FROM	WarrantyAgreementDimvw		A


JOIN	WarrantyAgreementContractFactvw B ON A.WarrantyAgreementDimKey						= B.WarrantyAgreementDimKey	AND B.DeletedDate IS Null


JOIN	WarrantyContractDimvw		C ON B.WarrantyAgreementContainsWarrantyContract_WarrantyContractDimKey = C.WarrantyContractDimKey	AND C.IsDeleted = 0 AND ISNULL(c.ObjectStatus,'') &lt;&gt; @objectStatusPendingDelete


WHERE	A.IsDeleted = 0


AND	ISNULL(a.ObjectStatus,'') &lt;&gt; @objectStatusPendingDelete


AND	A.Status = @EntityStatusActive


UNION ALL


SELECT	'Support' AS ContractType, C.ExpirationDate


FROM	SupportAgreementDimvw		A


JOIN	SupportAgreementContractFactvw	B ON A.SupportAgreementDimKey						= B.SupportAgreementDimKey	AND B.DeletedDate IS Null


JOIN	SupportContractDimvw		C ON B.SupportAgreementContainsSupportContract_SupportContractDimKey	= C.SupportContractDimKey	AND C.IsDeleted = 0 AND ISNULL(c.ObjectStatus,'') &lt;&gt; @objectStatusPendingDelete


WHERE	A.IsDeleted = 0


AND	ISNULL(a.ObjectStatus,'') &lt;&gt; @objectStatusPendingDelete


AND	A.Status = @EntityStatusActive


UNION ALL


SELECT	'Disposal' AS ContractType, C.ExpirationDate


FROM	DisposalAgreementDimvw		A


JOIN	DisposalAgreementContractFactvw B ON A.DisposalAgreementDimKey						= B.DisposalAgreementDimKey	AND B.DeletedDate IS Null


JOIN	DisposalContractDimvw		C ON B.DisposalAgreementContainsDisposalContract_DisposalContractDimKey = C.DisposalContractDimKey	AND C.IsDeleted = 0 AND ISNULL(c.ObjectStatus,'') &lt;&gt; @objectStatusPendingDelete


WHERE	A.IsDeleted = 0


AND	ISNULL(a.ObjectStatus,'') &lt;&gt; @objectStatusPendingDelete


AND	A.Status = @EntityStatusActive


UNION ALL


SELECT	'UserDefined' AS ContractType, A.ExpirationDate


FROM	UserDefinedAgreementDimvw		A


WHERE	A.IsDeleted = 0


AND	ISNULL(a.ObjectStatus,'') &lt;&gt; @objectStatusPendingDelete


AND	A.Status = @EntityStatusActive) Z


GROUP BY Z.ContractType</CommandText>


        <rd:UseGenericDesigner>true</rd:UseGenericDesigner>


      </Query>


      <Fields>


        <Field Name="ContractType">


          <DataField>ContractType</DataField>


          <rd:TypeName>System.String</rd:TypeName>


        </Field>


        <Field Name="GroupingProperty">


          <DataField>GroupingProperty</DataField>


          <rd:TypeName>System.Int32</rd:TypeName>


        </Field>


        <Field Name="Expired">


          <DataField>Expired</DataField>


          <rd:TypeName>System.Int32</rd:TypeName>


        </Field>


        <Field Name="CloseToExpired">


          <DataField>CloseToExpired</DataField>


          <rd:TypeName>System.Int32</rd:TypeName>


        </Field>


        <Field Name="Good">


          <DataField>Good</DataField>


          <rd:TypeName>System.Int32</rd:TypeName>


        </Field>


      </Fields>


    </DataSet>


    <DataSet Name="ContractAdminSettings">


      <Query>


        <DataSourceName>DWDataMart</DataSourceName>


        <CommandText>SELECT DISTINCT TOP 1 ExpiredThresholdDays, CloseToExpiredThresholdDays


FROM ContractAdminSettingsDim


WHERE IsDeleted = 0


--AND SourceId = @SourceId</CommandText>


      </Query>


      <Fields>


        <Field Name="ExpiredThresholdDays">


          <DataField>ExpiredThresholdDays</DataField>


          <rd:TypeName>System.Int32</rd:TypeName>


        </Field>


        <Field Name="CloseToExpiredThresholdDays">


          <DataField>CloseToExpiredThresholdDays</DataField>


          <rd:TypeName>System.Int32</rd:TypeName>


        </Field>


      </Fields>


    </DataSet>


  </DataSets>


  <ReportParameters>


    <ReportParameter Name="LT_Report">


      <DataType>String</DataType>


      <DefaultValue>


        <DataSetReference>


          <DataSetName>LT_Report</DataSetName>


          <ValueField>XML_F52E2B61_18A1_11d1_B105_00805F49916B</ValueField>


        </DataSetReference>


      </DefaultValue>


      <Hidden>true</Hidden>


    </ReportParameter>


    <ReportParameter Name="ThresholdContractExpired">


      <DataType>Integer</DataType>


      <DefaultValue>


        <DataSetReference>


          <DataSetName>ContractAdminSettings</DataSetName>


          <ValueField>ExpiredThresholdDays</ValueField>


        </DataSetReference>


      </DefaultValue>


      <Prompt>Threshold Contract Expired</Prompt>


    </ReportParameter>


    <ReportParameter Name="ThresholdContractCloseToExpired">


      <DataType>String</DataType>


      <DefaultValue>


        <DataSetReference>


          <DataSetName>ContractAdminSettings</DataSetName>


          <ValueField>CloseToExpiredThresholdDays</ValueField>


        </DataSetReference>


      </DefaultValue>


      <Prompt>Threshold Contract Close To Expired</Prompt>


    </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 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


Dim TargetList As String





Protected Overrides Sub OnInit()


  LocTables = new System.Collections.Generic.Dictionary(Of String, Microsoft.EnterpriseManagement.Reporting.XmlStringTable)()


  ReportTimeZone = Microsoft.EnterpriseManagement.Reporting.TimeZoneInformation.Current


  ReportStartDate = DateTime.MinValue


  ReportEndDate = DateTime.MinValue


  ReportTime = Nothing


  ReportCulture = System.Globalization.CultureInfo.GetCultureInfo(Report.User("Language"))


  ParameterProcessor = New Microsoft.EnterpriseManagement.Reporting.ParameterProcessor(ReportCulture)


  TargetList =Nothing


End Sub





'Public Function GetCallingManagementGroupId() As String


'   Return 'Microsoft.EnterpriseManagement.Reporting.ReportingConfiguration.M'anagementGroupId


'End Function





Public Function GetReportLocLanguageCode() As String


   Return ReportCulture.ThreeLetterWindowsLanguageName


End Function





Public Function GetReportLCID() As Integer


    Return ReportCulture.LCID


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








REM -------------------------------------------------





Dim ReportFormatList As System.Collections.Generic.Dictionary(Of String, IDataFormatter)


Const FormatListParameterName As String = "DataFormat"





REM -------------------------------------------------





    Public Interface IDataFormatter


        Function FormatData(ByVal Value As String) As String


    End Interface





    Public Class RankDataFormatter


        Implements IDataFormatter





        Private Series As System.Collections.Generic.SortedDictionary(Of Decimal, String)


        Private Culture As System.Globalization.CultureInfo





        Public Sub New(ByVal Config As System.Xml.XmlNode, ByVal ReportCulture As System.Globalization.CultureInfo)


            Culture = ReportCulture


            Series = New System.Collections.Generic.SortedDictionary(Of Decimal, String)()





            For Each SeriesXml As System.Xml.XmlNode In Config.ChildNodes


                Series.Add(Decimal.Parse(SeriesXml.Attributes("Rank").Value), SeriesXml.Attributes("Format").Value)


            Next


        End Sub





        Public Function FormatData(ByVal Value As String) As String Implements IDataFormatter.FormatData


            Dim Result As String = CDec(Value).ToString("G", Culture)





            For Each FormatItem As System.Collections.Generic.KeyValuePair(Of Decimal, String) In Series


                Dim RunningValue As Decimal = Math.Round(Value / FormatItem.Key)


                If RunningValue &gt; 0 Then


                    Result = String.Format(Culture, FormatItem.Value, RunningValue.ToString("G", Culture))


                Else


                    Exit For


                End If


            Next





            Return Result


        End Function


    End Class





    Public Class LookupDataFormatter


        Implements IDataFormatter





        Private MappingTable As System.Collections.Generic.IDictionary(Of String, String)





        Public Sub New(ByVal Config As System.Xml.XmlNode)


            MappingTable = New System.Collections.Generic.Dictionary(Of String, String)(StringComparer.OrdinalIgnoreCase)


            For Each SeriesXml As System.Xml.XmlNode In Config.ChildNodes


                MappingTable.Add(Decimal.Parse(SeriesXml.Attributes("Value").Value), SeriesXml.Attributes("Label").Value)


            Next


        End Sub





        Public Function FormatData(ByVal Value As String) As String Implements IDataFormatter.FormatData


            Dim Result As String


            If MappingTable.ContainsKey(Value) Then


                Result = MappingTable(Value)


            Else


                Result = Value


            End If


            Return Result


        End Function


    End Class





    Public Function GetReportFormatList() As System.Collections.Generic.Dictionary(Of String, IDataFormatter)


        If IsNothing(ReportFormatList) Then


            Dim Xml As System.Xml.XmlDocument = New System.Xml.XmlDocument()


            Xml.LoadXml(Report.Parameters(FormatListParameterName).Value)





            ReportFormatList = New System.Collections.Generic.Dictionary(Of String, IDataFormatter)(StringComparer.OrdinalIgnoreCase)


            For Each Node As System.Xml.XmlNode In Xml.DocumentElement.ChildNodes


                Dim Formatter As IDataFormatter = Nothing





                Select Case Node.Attributes("Type").Value.ToUpper()


                    Case "RANK"


                        Formatter = New RankDataFormatter(Node, ReportCulture)


                    Case "LOOKUP"


                        Formatter = New LookupDataFormatter(Node)


                End Select





                If Not IsNothing(Formatter) Then


                    ReportFormatList.Add(Node.Attributes("Name").Value, Formatter)


                End If


            Next


        End If


        Return ReportFormatList


    End Function





    Public Function FormatData(ByVal FormatName As String, ByVal DataType As String, ByVal Value As String)


        Dim FormatList As System.Collections.Generic.Dictionary(Of String, IDataFormatter) = GetReportFormatList()


        If Not String.IsNullOrEmpty(FormatName) And Not IsNothing(FormatList) Then


            If FormatList.ContainsKey(FormatName) Then


                Return FormatList(FormatName).FormatData(Value)


            End If


        End If





        If Not String.IsNullOrEmpty(DataType) Then


            If DataType = "DateTime" Then


                Return FormatDateTime("g", CDate(Value))


            ElseIf DataType.StartsWith("UInt") Then


                Return FormatNumber("G", Value)


            End If


        End If





        Return Value


    End Function





REM ----------------------------------------





Public Dim CurrentObjectList As String





    Public Function InitList(ByRef List As String) As String


        List  = String.Empty


        Return List


    End Function





    Public Function AddListItem(ByRef List As String, Item as String) As String


        List = List + Item


        Return List


    End Function





    Public Function GetObjectList(ByVal OptionsXml As String) As String()


        Dim Xml As System.Xml.XmlDocument


        Xml = New System.Xml.XmlDocument()


        Xml.LoadXml(OptionsXml)





        Dim Result As System.Collections.Generic.List(Of String)


        Result = New System.Collections.Generic.List(Of String)


        For Each ObjectNode As System.Xml.XmlNode In Xml.SelectNodes("/Value/Object")


            If Not Result.Contains(ObjectNode.InnerText) Then


                Result.Add(ObjectNode.InnerText)


            End If


        Next





        Return Result.ToArray()


    End Function


</Script></Code>


  <CodeModules>


    <CodeModule>Microsoft.EnterpriseManagement.Reporting.Code, Version=7.0.5000.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35</CodeModule>


    <CodeModule>System.Xml, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</CodeModule>


  </CodeModules>


  <rd:ReportUnitType>Inch</rd:ReportUnitType>


  <rd:ReportID>4ccfd6e4-92f8-4ee4-92f3-e474fef0feb6</rd:ReportID>


</Report>