Cireson.AssetManagement.SoftwareAssetListReport.Definition (ReportResource)

Element properties:

Source Code:

<ReportResource ID="Cireson.AssetManagement.SoftwareAssetListReport.Definition" Accessibility="Public" FileName="Cireson.AssetManagement.SoftwareAssetListReport.rdl" HasNullStream="false" MIMEType="application/octet-stream"/>

File Content: Cireson.AssetManagement.SoftwareAssetListReport.rdl

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


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


  <AutoRefresh>0</AutoRefresh>


  <DataSources>


    <DataSource Name="DWDataMart">


      <DataSourceReference>DWDataMart</DataSourceReference>


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


      <rd:DataSourceID>0b7ddcdf-6de6-423d-ba78-8263202b8ca2</rd:DataSourceID>


    </DataSource>


  </DataSources>


  <DataSets>


    <DataSet Name="SoftwareAssets">


      <Query>


        <DataSourceName>DWDataMart</DataSourceName>


        <QueryParameters>


          <QueryParameter Name="@Name">


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


          </QueryParameter>


          <QueryParameter Name="@LanguageCode">


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


          </QueryParameter>


          <QueryParameter Name="@Status">


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


          </QueryParameter>


          <QueryParameter Name="@LicenceStatus">


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


          </QueryParameter>


          <QueryParameter Name="@CostCenter">


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


          </QueryParameter>


          <QueryParameter Name="@Type">


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


          </QueryParameter>


          <QueryParameter Name="@Vendor">


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


          </QueryParameter>


          <QueryParameter Name="@ContractStatus">


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


          </QueryParameter>


          <QueryParameter Name="@ShowExceeded">


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


          </QueryParameter>


        </QueryParameters>


        <CommandType>StoredProcedure</CommandType>


        <CommandText>Cireson_AssetManagement_GetSoftwareAssetList</CommandText>


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


      </Query>


      <Fields>


        <Field Name="Software_Asset_Name">


          <DataField>Software Asset Name</DataField>


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


        </Field>


        <Field Name="Purchase_Count">


          <DataField>Purchase Count</DataField>


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


        </Field>


        <Field Name="Install_Count">


          <DataField>Install Count</DataField>


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


        </Field>


        <Field Name="Manufacturer">


          <DataField>Manufacturer</DataField>


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


        </Field>


        <Field Name="Available_Count">


          <DataField>Available Count</DataField>


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


        </Field>


        <Field Name="Cost_Center">


          <DataField>Cost Center</DataField>


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


        </Field>


        <Field Name="UsageCount">


          <DataField>UsageCount</DataField>


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


        </Field>


        <Field Name="Cost">


          <DataField>Cost</DataField>


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


        </Field>


        <Field Name="PurchasesCost">


          <DataField>PurchasesCost</DataField>


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


        </Field>


        <Field Name="CiresonSoftwareAssetDimKey">


          <DataField>CiresonSoftwareAssetDimKey</DataField>


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


        </Field>


        <Field Name="Vendor">


          <DataField>Vendor</DataField>


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


        </Field>


        <Field Name="Software_Asset_Status">


          <DataField>Software Asset Status</DataField>


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


        </Field>


        <Field Name="Software_Asset_License_Status">


          <DataField>Software Asset License Status</DataField>


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


        </Field>


        <Field Name="Currency">


          <DataField>Currency</DataField>


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


        </Field>


        <Field Name="TotalPurchaseCount">


          <DataField>TotalPurchaseCount</DataField>


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


        </Field>


        <Field Name="DowngradeLicences">


          <DataField>DowngradeLicences</DataField>


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


        </Field>


        <Field Name="DowngradesAvailable">


          <DataField>DowngradesAvailable</DataField>


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


        </Field>


        <Field Name="UpgradeLicences">


          <DataField>UpgradeLicences</DataField>


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


        </Field>


        <Field Name="UpgradesAvailable">


          <DataField>UpgradesAvailable</DataField>


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


        </Field>


        <Field Name="AuthorizedComputerCount">


          <DataField>AuthorizedComputerCount</DataField>


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


        </Field>


        <Field Name="UnauthorizedComputerCount">


          <DataField>UnauthorizedComputerCount</DataField>


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


        </Field>


        <Field Name="AuthorizedInstallCount">


          <DataField>AuthorizedInstallCount</DataField>


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


        </Field>


        <Field Name="IsNamed">


          <DataField>IsNamed</DataField>


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


        </Field>


        <Field Name="CountLicenceSeats">


          <DataField>CountLicenceSeats</DataField>


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


        </Field>


        <Field Name="CPUMode">


          <DataField>CPUMode</DataField>


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


        </Field>


        <Field Name="CountAllMatches">


          <DataField>CountAllMatches</DataField>


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


        </Field>


        <Field Name="IsUnlimited">


          <DataField>IsUnlimited</DataField>


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


        </Field>


        <Field Name="IsOS">


          <DataField>IsOS</DataField>


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


        </Field>


        <Field Name="Software_Asset_Type">


          <DataField>Software Asset Type</DataField>


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


        </Field>


      </Fields>


    </DataSet>


    <DataSet Name="LT_Report">


      <Query>


        <DataSourceName>DWDataMart</DataSourceName>


        <QueryParameters>


          <QueryParameter Name="@ManagementPackSystemName">


            <Value>Cireson.AssetManagement.DataWarehouse.Reports</Value>


          </QueryParameter>


          <QueryParameter Name="@ReportSystemName">


            <Value>Cireson.AssetManagement.SoftwareAssetListReport</Value>


          </QueryParameter>


          <QueryParameter Name="@LanguageCode">


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


          </QueryParameter>


          <QueryParameter Name="@Scope">


            <Value>%</Value>


          </QueryParameter>


        </QueryParameters>


        <CommandType>StoredProcedure</CommandType>


        <CommandText>ReportDisplayStringGet</CommandText>


      </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="List_SoftwareAssetStatus">


      <Query>


        <DataSourceName>DWDataMart</DataSourceName>


        <QueryParameters>


          <QueryParameter Name="@AllLabel">


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


          </QueryParameter>


          <QueryParameter Name="@LangCode">


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


          </QueryParameter>


        </QueryParameters>


        <CommandText>SELECT    


  @AllLabel AS Label, 


   -1 AS Value


UNION


SELECT DISTINCT 


	ISNULL (D.DisplayName, E.CiresonSoftwareAssetStatusValue) AS Label, 


	E.CiresonSoftwareAssetStatusId AS Value


FROM dbo.CiresonSoftwareAssetStatusvw E


LEFT OUTER JOIN dbo.DisplayStringDimvw D


ON D.BaseManagedEntityId = E.EnumTypeId


AND D.LanguageCode = @LangCode


WHERE ParentId IS NOT NULL


ORDER BY Label</CommandText>


      </Query>


      <Fields>


        <Field Name="Label">


          <DataField>Label</DataField>


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


        </Field>


        <Field Name="Value">


          <DataField>Value</DataField>


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


        </Field>


      </Fields>


    </DataSet>


    <DataSet Name="List_LicenceSatus">


      <Query>


        <DataSourceName>DWDataMart</DataSourceName>


        <QueryParameters>


          <QueryParameter Name="@AllLabel">


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


          </QueryParameter>


          <QueryParameter Name="@LangCode">


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


          </QueryParameter>


        </QueryParameters>


        <CommandText>SELECT    


  @AllLabel AS Label, 


   -1 AS Value


UNION


SELECT DISTINCT 


	ISNULL (D.DisplayName, E.CiresonSoftwareAssetLicenceStatusValue) AS Label, 


	E.CiresonSoftwareAssetLicenceStatusId AS Value


FROM dbo.CiresonSoftwareAssetLicenceStatusvw E


LEFT OUTER JOIN dbo.DisplayStringDimvw D


ON D.BaseManagedEntityId = E.EnumTypeId


AND D.LanguageCode = @LangCode


WHERE ParentId IS NOT NULL


ORDER BY Label</CommandText>


      </Query>


      <Fields>


        <Field Name="Label">


          <DataField>Label</DataField>


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


        </Field>


        <Field Name="Value">


          <DataField>Value</DataField>


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


        </Field>


      </Fields>


    </DataSet>


    <DataSet Name="List_SoftwareAssetType">


      <Query>


        <DataSourceName>DWDataMart</DataSourceName>


        <QueryParameters>


          <QueryParameter Name="@AllLabel">


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


          </QueryParameter>


          <QueryParameter Name="@LangCode">


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


          </QueryParameter>


        </QueryParameters>


        <CommandText>SELECT    


  @AllLabel AS Label, 


   -1 AS Value


UNION


SELECT DISTINCT 


	ISNULL (D.DisplayName, E.CiresonSoftwareAssetTypeValue) AS Label, 


	E.CiresonSoftwareAssetTypeId AS Value


FROM dbo.CiresonSoftwareAssetTypevw E


LEFT OUTER JOIN dbo.DisplayStringDimvw D


ON D.BaseManagedEntityId = E.EnumTypeId


AND D.LanguageCode = @LangCode


WHERE ParentId IS NOT NULL


ORDER BY Label</CommandText>


      </Query>


      <Fields>


        <Field Name="Label">


          <DataField>Label</DataField>


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


        </Field>


        <Field Name="Value">


          <DataField>Value</DataField>


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


        </Field>


      </Fields>


    </DataSet>


    <DataSet Name="List_ContractStatus">


      <Query>


        <DataSourceName>DWDataMart</DataSourceName>


        <QueryParameters>


          <QueryParameter Name="@LangCode">


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


          </QueryParameter>


        </QueryParameters>


        <CommandText>SELECT    


  '(All)' AS Label, 


   -1 AS Value,''


UNION


SELECT DISTINCT 


	ISNULL (D.DisplayName, E.CiresonWarrantyContractStatusValue) AS Label, 


	E.CiresonWarrantyContractStatusId AS Value, e.ID


FROM dbo.CiresonWarrantyContractStatusvw E


LEFT OUTER JOIN dbo.DisplayStringDimvw D


ON D.BaseManagedEntityId = E.EnumTypeId


AND D.LanguageCode = @LangCode


WHERE ParentId IS NOT NULL


AND E.ID &lt;&gt; 'Cireson.AssetManagement.ContractStatusEnum.Master'


ORDER BY Label</CommandText>


      </Query>


      <Fields>


        <Field Name="Label">


          <DataField>Label</DataField>


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


        </Field>


        <Field Name="Value">


          <DataField>Value</DataField>


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


        </Field>


        <Field Name="ID">


          <DataField />


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


        </Field>


      </Fields>


    </DataSet>


  </DataSets>


  <ReportSections>


    <ReportSection>


      <Body><Script>


        <ReportItems>


          <Image Name="CiresonBanner">


            <Source>External</Source>


            <Value>CiresonBannerWide.png</Value>


            <MIMEType>image/*</MIMEType>


            <Top>0.07145in</Top>


            <Left>0.15in</Left>


            <Height>2.17046cm</Height>


            <Width>28.08364cm</Width>


            <Style></Style>


              <Border>


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


              </Border>


            </Style>


          </Image>


          <Tablix Name="table_softwareassets">


            <TablixBody>


              <TablixColumns>


                <TablixColumn>


                  <Width>0.3in</Width>


                </TablixColumn>


                <TablixColumn>


                  <Width>1.25706in</Width>


                </TablixColumn>


                <TablixColumn>


                  <Width>1.10236in</Width>


                </TablixColumn>


                <TablixColumn>


                  <Width>1.10236in</Width>


                </TablixColumn>


                <TablixColumn>


                  <Width>1.10236in</Width>


                </TablixColumn>


                <TablixColumn>


                  <Width>1.10236in</Width>


                </TablixColumn>


                <TablixColumn>


                  <Width>1.07154in</Width>


                </TablixColumn>


                <TablixColumn>


                  <Width>1.05in</Width>


                </TablixColumn>


                <TablixColumn>


                  <Width>1.27917in</Width>


                </TablixColumn>


                <TablixColumn>


                  <Width>1.34884in</Width>


                </TablixColumn>


                <TablixColumn>


                  <Width>1.27917in</Width>


                </TablixColumn>


                <TablixColumn>


                  <Width>1.16458in</Width>


                </TablixColumn>


              </TablixColumns>


              <TablixRows>


                <TablixRow>


                  <Height>0.24583in</Height>


                  <TablixCells>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="textbox3">


                          <CanGrow>true</CanGrow>


                          <UserSort>


                            <SortExpression>=Fields!Software_Asset_Name.Value</SortExpression>


                          </UserSort>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Value>=Code.GetLocTable("LT_Report").GetString("SoftwareAssetName", "[Software Asset Name]")</Value>


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                    <FontWeight>Bold</FontWeight>


                                    <Color>White</Color>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>textbox3</rd:DefaultName>


                          <ZIndex>17</ZIndex>


                          <DataElementOutput>NoOutput</DataElementOutput>


                          <Style></Style>


                            <Border>


                              <Color>Gray</Color>


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


                            </Border>


                            <BackgroundColor>#de871d</BackgroundColor>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>4pt</PaddingLeft>


                            <PaddingRight>4pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                        <ColSpan>2</ColSpan>


                      </CellContents>


                    </TablixCell>


                    <TablixCell />


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox7">


                          <CanGrow>true</CanGrow>


                          <UserSort>


                            <SortExpression>=Fields!Purchase_Count.Value</SortExpression>


                          </UserSort>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


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


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                    <FontWeight>Bold</FontWeight>


                                    <Color>White</Color>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


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


                          <Style></Style>


                            <Border>


                              <Color>Gray</Color>


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


                            </Border>


                            <BackgroundColor>#de871d</BackgroundColor>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>4pt</PaddingLeft>


                            <PaddingRight>4pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox12">


                          <CanGrow>true</CanGrow>


                          <UserSort>


                            <SortExpression>=Fields!Install_Count.Value</SortExpression>


                          </UserSort>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


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


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                    <FontWeight>Bold</FontWeight>


                                    <Color>White</Color>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox12</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>Gray</Color>


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


                            </Border>


                            <BackgroundColor>#de871d</BackgroundColor>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>4pt</PaddingLeft>


                            <PaddingRight>4pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox8">


                          <CanGrow>true</CanGrow>


                          <UserSort>


                            <SortExpression>=Fields!Available_Count.Value</SortExpression>


                          </UserSort>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


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


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                    <FontWeight>Bold</FontWeight>


                                    <Color>White</Color>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


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


                          <Style></Style>


                            <Border>


                              <Color>Gray</Color>


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


                            </Border>


                            <BackgroundColor>#de871d</BackgroundColor>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>4pt</PaddingLeft>


                            <PaddingRight>4pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox14">


                          <CanGrow>true</CanGrow>


                          <UserSort>


                            <SortExpression>=Fields!UsageCount.Value</SortExpression>


                          </UserSort>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


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


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                    <FontWeight>Bold</FontWeight>


                                    <Color>White</Color>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox14</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>Gray</Color>


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


                            </Border>


                            <BackgroundColor>#de871d</BackgroundColor>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>4pt</PaddingLeft>


                            <PaddingRight>4pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="textbox20">


                          <CanGrow>true</CanGrow>


                          <UserSort>


                            <SortExpression>=Fields!Cost_Center.Value</SortExpression>


                          </UserSort>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


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


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                    <FontWeight>Bold</FontWeight>


                                    <Color>White</Color>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>textbox20</rd:DefaultName>


                          <ZIndex>14</ZIndex>


                          <DataElementOutput>NoOutput</DataElementOutput>


                          <Style></Style>


                            <Border>


                              <Color>Gray</Color>


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


                            </Border>


                            <BackgroundColor>#de871d</BackgroundColor>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>4pt</PaddingLeft>


                            <PaddingRight>4pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox9">


                          <CanGrow>true</CanGrow>


                          <UserSort>


                            <SortExpression>=Fields!Vendor.Value</SortExpression>


                          </UserSort>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


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


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                    <FontWeight>Bold</FontWeight>


                                    <Color>White</Color>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


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


                          <Style></Style>


                            <Border>


                              <Color>Gray</Color>


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


                            </Border>


                            <BackgroundColor>#de871d</BackgroundColor>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>4pt</PaddingLeft>


                            <PaddingRight>4pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox2">


                          <CanGrow>true</CanGrow>


                          <UserSort>


                            <SortExpression>=Fields!Software_Asset_Status.Value</SortExpression>


                          </UserSort>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


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


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                    <FontWeight>Bold</FontWeight>


                                    <Color>White</Color>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


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


                          <Style></Style>


                            <Border>


                              <Color>Gray</Color>


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


                            </Border>


                            <BackgroundColor>#de871d</BackgroundColor>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>4pt</PaddingLeft>


                            <PaddingRight>4pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox13">


                          <CanGrow>true</CanGrow>


                          <UserSort>


                            <SortExpression>=Fields!Software_Asset_Type.Value</SortExpression>


                          </UserSort>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


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


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                    <FontWeight>Bold</FontWeight>


                                    <Color>White</Color>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox13</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>Gray</Color>


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


                            </Border>


                            <BackgroundColor>#de871d</BackgroundColor>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>4pt</PaddingLeft>


                            <PaddingRight>4pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox11">


                          <CanGrow>true</CanGrow>


                          <UserSort>


                            <SortExpression>=Fields!Software_Asset_License_Status.Value</SortExpression>


                          </UserSort>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


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


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                    <FontWeight>Bold</FontWeight>


                                    <Color>White</Color>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox11</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>Gray</Color>


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


                            </Border>


                            <BackgroundColor>#de871d</BackgroundColor>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>4pt</PaddingLeft>


                            <PaddingRight>4pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox10">


                          <CanGrow>true</CanGrow>


                          <UserSort>


                            <SortExpression>=Fields!Cost.Value</SortExpression>


                          </UserSort>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


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


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                    <FontWeight>Bold</FontWeight>


                                    <Color>White</Color>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox10</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>Gray</Color>


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


                            </Border>


                            <BackgroundColor>#de871d</BackgroundColor>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>4pt</PaddingLeft>


                            <PaddingRight>4pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                  </TablixCells>


                </TablixRow>


                <TablixRow>


                  <Height>0.25in</Height>


                  <TablixCells>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Software_Asset_Name">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


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


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                    <Color>Blue</Color>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Software_Asset_Name</rd:DefaultName>


                          <ActionInfo>


                            <Actions>


                              <Action>


                                <Drillthrough>


                                  <ReportName>Cireson.AssetManagement.SoftwareAssetDetailsReport</ReportName>


                                  <Parameters>


                                    <Parameter Name="SoftwareAssetDimKey">


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


                                    </Parameter>


                                  </Parameters>


                                </Drillthrough>


                              </Action>


                            </Actions>


                          </ActionInfo>


                          <ZIndex>8</ZIndex>


                          <DataElementName>DNSName</DataElementName>


                          <Style></Style>


                            <Border>


                              <Color>Gray</Color>


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


                            </Border>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>4pt</PaddingLeft>


                            <PaddingRight>4pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                        <ColSpan>2</ColSpan>


                      </CellContents>


                    </TablixCell>


                    <TablixCell />


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Purchase_Count">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


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


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Purchase_Count</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>Gray</Color>


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


                            </Border>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>4pt</PaddingLeft>


                            <PaddingRight>4pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Install_Count">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


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


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Install_Count</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>Gray</Color>


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


                            </Border>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>4pt</PaddingLeft>


                            <PaddingRight>4pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="UsageCount1">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


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


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>UsageCount1</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>Gray</Color>


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


                            </Border>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>4pt</PaddingLeft>


                            <PaddingRight>4pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Available_Count">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


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


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Available_Count</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>Gray</Color>


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


                            </Border>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>4pt</PaddingLeft>


                            <PaddingRight>4pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Cost_Center1">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


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


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Cost_Center1</rd:DefaultName>


                          <ZIndex>5</ZIndex>


                          <DataElementName>OSVersionDisplayName</DataElementName>


                          <Style></Style>


                            <Border>


                              <Color>Gray</Color>


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


                            </Border>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>4pt</PaddingLeft>


                            <PaddingRight>4pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Vendor1">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


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


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Vendor1</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>Gray</Color>


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


                            </Border>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>4pt</PaddingLeft>


                            <PaddingRight>4pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Software_Asset_Status">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


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


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Software_Asset_Status</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>Gray</Color>


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


                            </Border>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>4pt</PaddingLeft>


                            <PaddingRight>4pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Software_Asset_Type">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


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


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Software_Asset_Type</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>Gray</Color>


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


                            </Border>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>4pt</PaddingLeft>


                            <PaddingRight>4pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Software_Asset_License_Status">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


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


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Software_Asset_License_Status</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>Gray</Color>


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


                            </Border>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>4pt</PaddingLeft>


                            <PaddingRight>4pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Cost">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


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


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Cost</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>Gray</Color>


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


                            </Border>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>4pt</PaddingLeft>


                            <PaddingRight>4pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                  </TablixCells>


                </TablixRow>


                <TablixRow>


                  <Height>0.23622in</Height>


                  <TablixCells>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox59">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Value />


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                    <Color>Blue</Color>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox59</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>Gray</Color>


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


                            </Border>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>4pt</PaddingLeft>


                            <PaddingRight>4pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                        <ColSpan>2</ColSpan>


                      </CellContents>


                    </TablixCell>


                    <TablixCell />


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox61">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Value />


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox61</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>Gray</Color>


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


                            </Border>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>4pt</PaddingLeft>


                            <PaddingRight>4pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox62">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Value />


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox62</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>Gray</Color>


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


                            </Border>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>4pt</PaddingLeft>


                            <PaddingRight>4pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox63">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Value />


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox63</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>Gray</Color>


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


                            </Border>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>4pt</PaddingLeft>


                            <PaddingRight>4pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox64">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Value />


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox64</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>Gray</Color>


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


                            </Border>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>4pt</PaddingLeft>


                            <PaddingRight>4pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox65">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Value />


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox65</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>Gray</Color>


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


                            </Border>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>4pt</PaddingLeft>


                            <PaddingRight>4pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox66">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Value />


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox66</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>Gray</Color>


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


                            </Border>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>4pt</PaddingLeft>


                            <PaddingRight>4pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox67">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Value />


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox67</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>Gray</Color>


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


                            </Border>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>4pt</PaddingLeft>


                            <PaddingRight>4pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox16">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Value />


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox16</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>Gray</Color>


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


                            </Border>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>4pt</PaddingLeft>


                            <PaddingRight>4pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox68">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Value />


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox68</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>Gray</Color>


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


                            </Border>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>4pt</PaddingLeft>


                            <PaddingRight>4pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox69">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Value>=Code.GetLocTable("LT_Report").GetString("TotalCost", "[Total Cost:]")</Value>


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                                <TextRun>


                                  <Value xml:space="preserve"> </Value>


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                                <TextRun>


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


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox69</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>Gray</Color>


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


                            </Border>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>4pt</PaddingLeft>


                            <PaddingRight>4pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                  </TablixCells>


                </TablixRow>


              </TablixRows>


            </TablixBody>


            <TablixColumnHierarchy>


              <TablixMembers>


                <TablixMember />


                <TablixMember />


                <TablixMember />


                <TablixMember />


                <TablixMember />


                <TablixMember />


                <TablixMember />


                <TablixMember />


                <TablixMember />


                <TablixMember />


                <TablixMember />


                <TablixMember />


              </TablixMembers>


            </TablixColumnHierarchy>


            <TablixRowHierarchy>


              <TablixMembers>


                <TablixMember>


                  <TablixHeader>


                    <Size>0.99326in</Size>


                    <CellContents>


                      <Textbox Name="Textbox4">


                        <CanGrow>true</CanGrow>


                        <UserSort>


                          <SortExpression>=Fields!Currency.Value</SortExpression>


                          <SortExpressionScope>Currency</SortExpressionScope>


                        </UserSort>


                        <KeepTogether>true</KeepTogether>


                        <Paragraphs>


                          <Paragraph>


                            <TextRuns>


                              <TextRun>


                                <Value>Currency</Value>


                                <Style></Style>


                                  <FontFamily>Tahoma</FontFamily>


                                  <FontSize>8pt</FontSize>


                                  <FontWeight>Bold</FontWeight>


                                  <Color>White</Color>


                                </Style>


                              </TextRun>


                            </TextRuns>


                            <Style /></Style>


                          </Paragraph>


                        </Paragraphs>


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


                        <Style></Style>


                          <Border>


                            <Color>Gray</Color>


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


                          </Border>


                          <BackgroundColor>#de871d</BackgroundColor>


                          <VerticalAlign>Middle</VerticalAlign>


                          <PaddingLeft>4pt</PaddingLeft>


                          <PaddingRight>4pt</PaddingRight>


                          <PaddingTop>2pt</PaddingTop>


                          <PaddingBottom>2pt</PaddingBottom>


                        </Style>


                      </Textbox>


                    </CellContents>


                  </TablixHeader>


                  <TablixMembers>


                    <TablixMember>


                      <FixedData>true</FixedData>


                      <KeepTogether>true</KeepTogether>


                    </TablixMember>


                  </TablixMembers>


                  <KeepWithGroup>After</KeepWithGroup>


                  <RepeatOnNewPage>true</RepeatOnNewPage>


                </TablixMember>


                <TablixMember>


                  <Group Name="Currency">


                    <GroupExpressions>


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


                    </GroupExpressions>


                  </Group>


                  <SortExpressions>


                    <SortExpression>


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


                    </SortExpression>


                  </SortExpressions>


                  <TablixHeader>


                    <Size>0.99326in</Size>


                    <CellContents>


                      <Textbox Name="Currency">


                        <CanGrow>true</CanGrow>


                        <KeepTogether>true</KeepTogether>


                        <Paragraphs>


                          <Paragraph>


                            <TextRuns>


                              <TextRun>


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


                                <Style></Style>


                                  <FontFamily>Tahoma</FontFamily>


                                  <FontSize>8pt</FontSize>


                                  <Color>Blue</Color>


                                </Style>


                              </TextRun>


                            </TextRuns>


                            <Style /></Style>


                          </Paragraph>


                        </Paragraphs>


                        <rd:DefaultName>Currency</rd:DefaultName>


                        <Style></Style>


                          <Border>


                            <Color>Gray</Color>


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


                          </Border>


                          <VerticalAlign>Middle</VerticalAlign>


                          <PaddingLeft>4pt</PaddingLeft>


                          <PaddingRight>4pt</PaddingRight>


                          <PaddingTop>2pt</PaddingTop>


                          <PaddingBottom>2pt</PaddingBottom>


                        </Style>


                      </Textbox>


                    </CellContents>


                  </TablixHeader>


                  <TablixMembers>


                    <TablixMember>


                      <Group Name="table_softwareassets_Details_Group">


                        <DataElementName>Detail</DataElementName>


                      </Group>


                      <TablixMembers>


                        <TablixMember />


                      </TablixMembers>


                      <DataElementName>Detail_Collection</DataElementName>


                      <DataElementOutput>Output</DataElementOutput>


                      <KeepTogether>true</KeepTogether>


                    </TablixMember>


                    <TablixMember>


                      <KeepWithGroup>Before</KeepWithGroup>


                    </TablixMember>


                  </TablixMembers>


                </TablixMember>


              </TablixMembers>


            </TablixRowHierarchy>


            <RepeatColumnHeaders>true</RepeatColumnHeaders>


            <RepeatRowHeaders>true</RepeatRowHeaders>


            <NoRowsMessage>There is no data available for this report.</NoRowsMessage>


            <DataSetName>SoftwareAssets</DataSetName>


            <Top>1.60124in</Top>


            <Left>0.15208in</Left>


            <Height>0.73205in</Height>


            <Width>14.15306in</Width>


            <ZIndex>1</ZIndex>


            <Style></Style>


              <FontFamily>Tahoma</FontFamily>


              <FontSize>8pt</FontSize>


              <TextAlign>Center</TextAlign>


            </Style>


          </Tablix>


          <Textbox Name="Textbox1">


            <CanGrow>true</CanGrow>


            <KeepTogether>true</KeepTogether>


            <Paragraphs>


              <Paragraph>


                <TextRuns>


                  <TextRun>


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


                    <Style></Style>


                      <FontFamily>Verdana</FontFamily>


                      <FontSize>14pt</FontSize>


                      <FontWeight>Bold</FontWeight>


                      <Color>DimGray</Color>


                    </Style>


                  </TextRun>


                  <TextRun>


                    <Value> at </Value>


                    <Style></Style>


                      <FontFamily>Verdana</FontFamily>


                      <FontSize>14pt</FontSize>


                      <FontWeight>Bold</FontWeight>


                      <Color>DimGray</Color>


                    </Style>


                  </TextRun>


                  <TextRun>


                    <Value>=Code.FormatDateTime("g", CStr(Now()))</Value>


                    <Style></Style>


                      <FontFamily>Verdana</FontFamily>


                      <FontSize>14pt</FontSize>


                      <FontWeight>Bold</FontWeight>


                      <Color>DimGray</Color>


                    </Style>


                  </TextRun>


                </TextRuns>


                <Style /></Style>


              </Paragraph>


            </Paragraphs>


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


            <Top>1.07083in</Top>


            <Left>0.15208in</Left>


            <Height>0.32292in</Height>


            <Width>14.15306in</Width>


            <ZIndex>2</ZIndex>


            <Style></Style>


              <Border>


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


              </Border>


              <PaddingLeft>2pt</PaddingLeft>


              <PaddingRight>2pt</PaddingRight>


              <PaddingTop>2pt</PaddingTop>


              <PaddingBottom>2pt</PaddingBottom>


            </Style>


          </Textbox>


        </ReportItems>


        <Height>6.25891cm</Height>


        <Style /></Style>


      </Script></Body>


      <Width>36.72665cm</Width>


      <Page>


        <PageFooter>


          <Height>1.4605cm</Height>


          <PrintOnFirstPage>true</PrintOnFirstPage>


          <PrintOnLastPage>true</PrintOnLastPage>


          <ReportItems>


            <Textbox Name="textbox5">


              <CanGrow>true</CanGrow>


              <KeepTogether>true</KeepTogether>


              <Paragraphs>


                <Paragraph>


                  <TextRuns>


                    <TextRun>


                      <Value>=Globals!PageNumber &amp; "/" &amp; Globals!TotalPages</Value>


                      <Style></Style>


                        <FontFamily>Tahoma</FontFamily>


                        <FontSize>8pt</FontSize>


                        <Color>DimGray</Color>


                      </Style>


                    </TextRun>


                  </TextRuns>


                  <Style /></Style>


                </Paragraph>


              </Paragraphs>


              <rd:DefaultName>textbox5</rd:DefaultName>


              <Top>0.175in</Top>


              <Left>13.37621in</Left>


              <Height>0.24792in</Height>


              <Width>0.92893in</Width>


              <Style></Style>


                <Border>


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


                </Border>


                <PaddingLeft>2pt</PaddingLeft>


                <PaddingRight>2pt</PaddingRight>


                <PaddingTop>2pt</PaddingTop>


                <PaddingBottom>2pt</PaddingBottom>


              </Style>


            </Textbox>


            <Textbox Name="textbox6">


              <CanGrow>true</CanGrow>


              <KeepTogether>true</KeepTogether>


              <Paragraphs>


                <Paragraph>


                  <TextRuns>


                    <TextRun>


                      <Value>=Code.GetLocTable("LT_Report").GetString("TotalSoftwareAssets", "[Total Software Assets:]") + " " + Cstr(CountRows("SoftwareAssets"))</Value>


                      <Style></Style>


                        <FontFamily>Tahoma</FontFamily>


                        <FontSize>8pt</FontSize>


                        <Color>DimGray</Color>


                      </Style>


                    </TextRun>


                  </TextRuns>


                  <Style /></Style>


                </Paragraph>


              </Paragraphs>


              <rd:DefaultName>textbox5</rd:DefaultName>


              <Top>0.175in</Top>


              <Left>0.15208in</Left>


              <Height>0.24792in</Height>


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


          <Style /></Style>


        </PageFooter>


        <PageHeight>21.59cm</PageHeight>


        <PageWidth>27.94cm</PageWidth>


        <InteractiveHeight>11in</InteractiveHeight>


        <InteractiveWidth>8.5in</InteractiveWidth>


        <LeftMargin>1.27cm</LeftMargin>


        <RightMargin>1.27cm</RightMargin>


        <TopMargin>1.27cm</TopMargin>


        <BottomMargin>1.27cm</BottomMargin>


        <ColumnSpacing>1.27cm</ColumnSpacing>


        <Style /></Style>


      </Page>


    </ReportSection>


  </ReportSections>


  <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="AllLabel">


      <DataType>String</DataType>


      <DefaultValue>


        <Values>


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


        </Values>


      </DefaultValue>


      <Prompt>AllLabel</Prompt>


      <Hidden>true</Hidden>


    </ReportParameter>


    <ReportParameter Name="TimeZone">


      <DataType>String</DataType>


      <Nullable>true</Nullable>


      <DefaultValue>


        <Values>


          <Value xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />


        </Values>


      </DefaultValue>


      <Hidden>true</Hidden>


    </ReportParameter>


    <ReportParameter Name="LangCode">


      <DataType>String</DataType>


      <DefaultValue>


        <Values>


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


        </Values>


      </DefaultValue>


      <Prompt>LangCode</Prompt>


      <Hidden>true</Hidden>


    </ReportParameter>


    <ReportParameter Name="Name">


      <DataType>String</DataType>


      <AllowBlank>true</AllowBlank>


      <Prompt>Software Asset Name:</Prompt>


    </ReportParameter>


    <ReportParameter Name="Status">


      <DataType>String</DataType>


      <DefaultValue>


        <Values>


          <Value>-1</Value>


        </Values>


      </DefaultValue>


      <AllowBlank>true</AllowBlank>


      <Prompt>Software Asset Status:</Prompt>


      <ValidValues>


        <DataSetReference>


          <DataSetName>List_SoftwareAssetStatus</DataSetName>


          <ValueField>Value</ValueField>


          <LabelField>Label</LabelField>


        </DataSetReference>


      </ValidValues>


      <MultiValue>true</MultiValue>


    </ReportParameter>


    <ReportParameter Name="LicenceStatus">


      <DataType>String</DataType>


      <DefaultValue>


        <Values>


          <Value>-1</Value>


        </Values>


      </DefaultValue>


      <AllowBlank>true</AllowBlank>


      <Prompt>Software Asset License Status:</Prompt>


      <ValidValues>


        <DataSetReference>


          <DataSetName>List_LicenceSatus</DataSetName>


          <ValueField>Value</ValueField>


          <LabelField>Label</LabelField>


        </DataSetReference>


      </ValidValues>


      <MultiValue>true</MultiValue>


    </ReportParameter>


    <ReportParameter Name="CostCenter">


      <DataType>String</DataType>


      <DefaultValue>


        <Values>


          <Value>-1</Value>


        </Values>


      </DefaultValue>


      <AllowBlank>true</AllowBlank>


      <Prompt>Cost Center</Prompt>


      <MultiValue>true</MultiValue>


    </ReportParameter>


    <ReportParameter Name="Type">


      <DataType>String</DataType>


      <DefaultValue>


        <Values>


          <Value>-1</Value>


        </Values>


      </DefaultValue>


      <AllowBlank>true</AllowBlank>


      <Prompt>Type:</Prompt>


      <ValidValues>


        <DataSetReference>


          <DataSetName>List_SoftwareAssetType</DataSetName>


          <ValueField>Value</ValueField>


          <LabelField>Label</LabelField>


        </DataSetReference>


      </ValidValues>


      <MultiValue>true</MultiValue>


    </ReportParameter>


    <ReportParameter Name="Vendor">


      <DataType>String</DataType>


      <DefaultValue>


        <Values>


          <Value>-1</Value>


        </Values>


      </DefaultValue>


      <AllowBlank>true</AllowBlank>


      <Prompt>Vendor:</Prompt>


      <MultiValue>true</MultiValue>


    </ReportParameter>


    <ReportParameter Name="ContractStatus">


      <DataType>String</DataType>


      <DefaultValue>


        <Values>


          <Value>-1</Value>


        </Values>


      </DefaultValue>


      <AllowBlank>true</AllowBlank>


      <Prompt>Contract Status:</Prompt>


      <ValidValues>


        <DataSetReference>


          <DataSetName>List_ContractStatus</DataSetName>


          <ValueField>Value</ValueField>


          <LabelField>Label</LabelField>


        </DataSetReference>


      </ValidValues>


      <MultiValue>true</MultiValue>


    </ReportParameter>


    <ReportParameter Name="ShowExceeded">


      <DataType>Boolean</DataType>


      <DefaultValue>


        <Values>


          <Value>false</Value>


        </Values>


      </DefaultValue>


      <Prompt>Show Exceeded:</Prompt>


      <UsedInQuery>False</UsedInQuery>


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


    


    Public Function GetReportLocLanguageCodeTwoLetter() As String


    Return ReportCulture.TwoLetterISOLanguageName


    End Function





  </Script></Code>


  <Language>=Code.GetReportLocLanguageCodeTwoLetter()</Language>


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


  <ConsumeContainerWhitespace>true</ConsumeContainerWhitespace>


  <rd:ReportUnitType>Cm</rd:ReportUnitType>  


  <rd:ReportID>5d143ebe-3bed-467a-990d-793412d30006</rd:ReportID>


</Report>