Home
  •  

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

Element properties:

TypeReportResource
File NameProvance.ITAssetManagement.Report.ContractDetail.rdl
AccessibilityPublic

Source Code:

<ReportResource ID="Provance.ITAssetManagement.Report.ContractDetail.ReportRdl" Accessibility="Public" FileName="Provance.ITAssetManagement.Report.ContractDetail.rdl" HasNullStream="false" MIMEType="application/octet-stream"/>

File Content: Provance.ITAssetManagement.Report.ContractDetail.rdl

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


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


  <Body><Script>


    <ReportItems>


      <Rectangle Name="rectangle2">


        <ReportItems>


          <Tablix Name="Tablix8">


            <TablixBody>


              <TablixColumns>


                <TablixColumn>


                  <Width>1.1in</Width>


                </TablixColumn>


                <TablixColumn>


                  <Width>8.575in</Width>


                </TablixColumn>


              </TablixColumns>


              <TablixRows>


                <TablixRow>


                  <Height>0.2in</Height>


                  <TablixCells>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="textbox52">


                          <CanGrow>true</CanGrow>


                          <CanShrink>true</CanShrink>


                          <DataElementStyle>Element</DataElementStyle>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Report Generated</Label>


                                  <Value>=Code.GetLocTable("LT_Report").GetString("RG", "[ReportGenerated]") &amp; " :"</Value>


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <ZIndex>1</ZIndex>


                          <DataElementName>Severity</DataElementName>


                          <DataElementOutput>NoOutput</DataElementOutput>


                          <Style></Style>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="textboxDescription2">


                          <CanGrow>true</CanGrow>


                          <CanShrink>true</CanShrink>


                          <DataElementStyle>Element</DataElementStyle>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Value>=Now()</Value>


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style></Style>


                                <TextAlign>Left</TextAlign>


                              </Style>


                            </Paragraph>


                          </Paragraphs>


                          <ZIndex>2</ZIndex>


                          <DataElementName>ActualStartDate</DataElementName>


                          <DataElementOutput>Output</DataElementOutput>


                          <Style></Style>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                  </TablixCells>


                </TablixRow>


                <TablixRow>


                  <Height>0.2in</Height>


                  <TablixCells>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox5">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Base Currency</Label>


                                  <Value>=Code.GetLocTable("LT_Report").GetString("U", "[Base Currency]") &amp; " :"</Value>


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


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


                          <Style></Style>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox19">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Value>=First(Fields!ISOCurrencySymbol.Value, "BaseCurrency")</Value>


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style></Style>


                                <TextAlign>Left</TextAlign>


                              </Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox19</rd:DefaultName>


                          <Style></Style>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                  </TablixCells>


                </TablixRow>


              </TablixRows>


            </TablixBody>


            <TablixColumnHierarchy>


              <TablixMembers>


                <TablixMember />


                <TablixMember />


              </TablixMembers>


            </TablixColumnHierarchy>


            <TablixRowHierarchy>


              <TablixMembers>


                <TablixMember>


                  <Group Name="Details7" />


                  <TablixMembers>


                    <TablixMember />


                    <TablixMember />


                  </TablixMembers>


                </TablixMember>


              </TablixMembers>


            </TablixRowHierarchy>


            <KeepTogether>true</KeepTogether>


            <DataSetName>LT_Report</DataSetName>


            <Top>0.05in</Top>


            <Left>0.05in</Left>


            <Height>0.4in</Height>


            <Width>9.675in</Width>


            <Style></Style>


              <Border>


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


              </Border>


            </Style>


          </Tablix>


        </ReportItems>


        <DataElementOutput>ContentsOnly</DataElementOutput>


        <Top>0.55in</Top>


        <Left>0.05in</Left>


        <Height>0.5in</Height>


        <Width>9.775in</Width>


        <Style></Style>


          <Border>


            <Color>LightGrey</Color>


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


          </Border>


          <BottomBorder>


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


          </BottomBorder>


        </Style>


      </Rectangle>


      <Rectangle Name="Rectangle9">


        <ReportItems>


          <Textbox Name="Data_AgeementNumber">


            <CanGrow>true</CanGrow>


            <KeepTogether>true</KeepTogether>


            <Paragraphs>


              <Paragraph>


                <TextRuns>


                  <TextRun>


                    <Label>Agreement Number</Label>


                    <Value>=Code.GetLocTable("LT_Report").GetString("A", "[Agreement Number]") &amp; " - " &amp; First(Fields!AgreementNumber.Value, "Agreement")</Value>


                    <Style></Style>


                      <FontFamily>Tahoma</FontFamily>


                      <FontWeight>Bold</FontWeight>


                    </Style>


                  </TextRun>


                </TextRuns>


                <Style /></Style>


              </Paragraph>


            </Paragraphs>


            <Height>0.4in</Height>


            <Width>9.88195in</Width>


            <Style></Style>


              <Border>


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


              </Border>


              <BackgroundColor>#bfd0ea</BackgroundColor>


              <VerticalAlign>Bottom</VerticalAlign>


              <PaddingLeft>2pt</PaddingLeft>


              <PaddingRight>2pt</PaddingRight>


              <PaddingTop>2pt</PaddingTop>


              <PaddingBottom>2pt</PaddingBottom>


            </Style>


          </Textbox>


          <Textbox Name="Textbox128">


            <CanGrow>true</CanGrow>


            <KeepTogether>true</KeepTogether>


            <Paragraphs>


              <Paragraph>


                <TextRuns>


                  <TextRun>


                    <Label>Cost Events</Label>


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


                    <Style></Style>


                      <FontFamily>Tahoma</FontFamily>


                      <FontWeight>Bold</FontWeight>


                    </Style>


                  </TextRun>


                </TextRuns>


                <Style /></Style>


              </Paragraph>


            </Paragraphs>


            <rd:DefaultName>Textbox79</rd:DefaultName>


            <Top>4.49444in</Top>


            <Left>0.2126in</Left>


            <Height>0.25in</Height>


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


          <Tablix Name="Tablix14">


            <TablixBody>


              <TablixColumns>


                <TablixColumn>


                  <Width>1.4in</Width>


                </TablixColumn>


                <TablixColumn>


                  <Width>1in</Width>


                </TablixColumn>


                <TablixColumn>


                  <Width>0.78125in</Width>


                </TablixColumn>


                <TablixColumn>


                  <Width>0.96712in</Width>


                </TablixColumn>


                <TablixColumn>


                  <Width>1.16899in</Width>


                </TablixColumn>


                <TablixColumn>


                  <Width>1.2in</Width>


                </TablixColumn>


                <TablixColumn>


                  <Width>0.90833in</Width>


                </TablixColumn>


                <TablixColumn>


                  <Width>0.81458in</Width>


                </TablixColumn>


                <TablixColumn>


                  <Width>1.16458in</Width>


                </TablixColumn>


              </TablixColumns>


              <TablixRows>


                <TablixRow>


                  <Height>0.4in</Height>


                  <TablixCells>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox131">


                          <CanGrow>true</CanGrow>


                          <UserSort>


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


                          </UserSort>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Type</Label>


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


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                    <FontWeight>Bold</FontWeight>


                                    <Color>White</Color>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style></Style>


                                <TextAlign>Left</TextAlign>


                              </Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox131</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <BackgroundColor>DimGray</BackgroundColor>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox147">


                          <CanGrow>true</CanGrow>


                          <UserSort>


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


                          </UserSort>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Effective Date</Label>


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


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                    <FontWeight>Bold</FontWeight>


                                    <Color>White</Color>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style></Style>


                                <TextAlign>Left</TextAlign>


                              </Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox147</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <BackgroundColor>DimGray</BackgroundColor>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox145">


                          <CanGrow>true</CanGrow>


                          <UserSort>


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


                          </UserSort>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Amount</Label>


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


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                    <FontWeight>Bold</FontWeight>


                                    <Color>White</Color>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style></Style>


                                <TextAlign>Left</TextAlign>


                              </Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox145</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <BackgroundColor>DimGray</BackgroundColor>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox143">


                          <CanGrow>true</CanGrow>


                          <UserSort>


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


                          </UserSort>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Supplier</Label>


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


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                    <FontWeight>Bold</FontWeight>


                                    <Color>White</Color>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style></Style>


                                <TextAlign>Left</TextAlign>


                              </Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox143</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <BackgroundColor>DimGray</BackgroundColor>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox141">


                          <CanGrow>true</CanGrow>


                          <UserSort>


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


                          </UserSort>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Organization</Label>


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


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                    <FontWeight>Bold</FontWeight>


                                    <Color>White</Color>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style></Style>


                                <TextAlign>Left</TextAlign>


                              </Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox141</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <BackgroundColor>DimGray</BackgroundColor>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox139">


                          <CanGrow>true</CanGrow>


                          <UserSort>


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


                          </UserSort>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Cost Center</Label>


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


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                    <FontWeight>Bold</FontWeight>


                                    <Color>White</Color>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style></Style>


                                <TextAlign>Left</TextAlign>


                              </Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox139</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <BackgroundColor>DimGray</BackgroundColor>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox137">


                          <CanGrow>true</CanGrow>


                          <UserSort>


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


                          </UserSort>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Location</Label>


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


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                    <FontWeight>Bold</FontWeight>


                                    <Color>White</Color>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style></Style>


                                <TextAlign>Left</TextAlign>


                              </Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox137</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <BackgroundColor>DimGray</BackgroundColor>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox149">


                          <CanGrow>true</CanGrow>


                          <UserSort>


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


                          </UserSort>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>User</Label>


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


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                    <FontWeight>Bold</FontWeight>


                                    <Color>White</Color>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style></Style>


                                <TextAlign>Left</TextAlign>


                              </Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox149</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <BackgroundColor>DimGray</BackgroundColor>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</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>


                                  <Label>Associated Milestone</Label>


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


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                    <FontWeight>Bold</FontWeight>


                                    <Color>White</Color>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style></Style>


                                <TextAlign>Left</TextAlign>


                              </Style>


                            </Paragraph>


                          </Paragraphs>


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


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <BackgroundColor>DimGray</BackgroundColor>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                  </TablixCells>


                </TablixRow>


                <TablixRow>


                  <Height>0.25in</Height>


                  <TablixCells>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="CostEventType">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


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


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>CostEventType</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="EffectiveDate">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


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


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                    <Format>=FormatDateTime(Fields!EffectiveDate.Value,DateFormat.ShortDate)</Format>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>EffectiveDate</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="AMOUNT">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Amount</Label>


                                  <Value>=FormatNumber(Fields!AMOUNT.Value,2)</Value>


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style></Style>


                                <TextAlign>Right</TextAlign>


                              </Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>AMOUNT</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>6pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Supplier">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


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


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Supplier</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Organization">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


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


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Organization</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="CostCenter">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


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


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>CostCenter</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Location">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


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


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Location</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="UserName">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


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


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>UserName</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox68">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Value>=Fields!MileStone_DisplayName.Value</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>LightGrey</Color>


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


                            </Border>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                  </TablixCells>


                </TablixRow>


              </TablixRows>


            </TablixBody>


            <TablixColumnHierarchy>


              <TablixMembers>


                <TablixMember />


                <TablixMember />


                <TablixMember />


                <TablixMember />


                <TablixMember />


                <TablixMember />


                <TablixMember />


                <TablixMember />


                <TablixMember />


              </TablixMembers>


            </TablixColumnHierarchy>


            <TablixRowHierarchy>


              <TablixMembers>


                <TablixMember>


                  <KeepWithGroup>After</KeepWithGroup>


                  <RepeatOnNewPage>true</RepeatOnNewPage>


                </TablixMember>


                <TablixMember>


                  <Group Name="Details12" />


                </TablixMember>


              </TablixMembers>


            </TablixRowHierarchy>


            <RepeatColumnHeaders>true</RepeatColumnHeaders>


            <NoRowsMessage>=Code.GetLocTable("LT_Report").GetString("X", "[No data available.]")</NoRowsMessage>


            <DataSetName>CostEvents</DataSetName>


            <Top>4.77222in</Top>


            <Left>0.30083in</Left>


            <Height>0.65in</Height>


            <Width>9.40485in</Width>


            <ZIndex>2</ZIndex>


            <Style></Style>


              <Border>


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


              </Border>


              <FontFamily>Tahoma</FontFamily>


              <FontSize>8pt</FontSize>


            </Style>


          </Tablix>


          <Textbox Name="Textbox129">


            <CanGrow>true</CanGrow>


            <KeepTogether>true</KeepTogether>


            <Paragraphs>


              <Paragraph>


                <TextRuns>


                  <TextRun>


                    <Label>MileStones</Label>


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


                    <Style></Style>


                      <FontFamily>Tahoma</FontFamily>


                      <FontWeight>Bold</FontWeight>


                    </Style>


                  </TextRun>


                </TextRuns>


                <Style /></Style>


              </Paragraph>


            </Paragraphs>


            <rd:DefaultName>Textbox79</rd:DefaultName>


            <Top>3.45451in</Top>


            <Left>0.13898in</Left>


            <Height>0.25in</Height>


            <Width>9.69435in</Width>


            <ZIndex>3</ZIndex>


            <Style></Style>


              <Border>


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


              </Border>


              <PaddingLeft>2pt</PaddingLeft>


              <PaddingRight>2pt</PaddingRight>


              <PaddingTop>2pt</PaddingTop>


              <PaddingBottom>2pt</PaddingBottom>


            </Style>


          </Textbox>


          <Tablix Name="Tablix15">


            <TablixBody>


              <TablixColumns>


                <TablixColumn>


                  <Width>1.68823in</Width>


                </TablixColumn>


                <TablixColumn>


                  <Width>1in</Width>


                </TablixColumn>


                <TablixColumn>


                  <Width>1in</Width>


                </TablixColumn>


                <TablixColumn>


                  <Width>1.67153in</Width>


                </TablixColumn>


                <TablixColumn>


                  <Width>4.10681in</Width>


                </TablixColumn>


              </TablixColumns>


              <TablixRows>


                <TablixRow>


                  <Height>0.4in</Height>


                  <TablixCells>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="MilestoneType_label">


                          <CanGrow>true</CanGrow>


                          <UserSort>


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


                          </UserSort>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Milestone Type</Label>


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


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                    <FontWeight>Bold</FontWeight>


                                    <Color>White</Color>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style></Style>


                                <TextAlign>Left</TextAlign>


                              </Style>


                            </Paragraph>


                          </Paragraphs>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <BackgroundColor>DimGray</BackgroundColor>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox192">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Effective Date</Label>


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


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                    <FontWeight>Bold</FontWeight>


                                    <Color>White</Color>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style></Style>


                                <TextAlign>Left</TextAlign>


                              </Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox192</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <BackgroundColor>DimGray</BackgroundColor>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox188">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Id</Label>


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


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                    <FontWeight>Bold</FontWeight>


                                    <Color>White</Color>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style></Style>


                                <TextAlign>Left</TextAlign>


                              </Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox188</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <BackgroundColor>DimGray</BackgroundColor>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Name_Label">


                          <CanGrow>true</CanGrow>


                          <UserSort>


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


                          </UserSort>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Name</Label>


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


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                    <FontWeight>Bold</FontWeight>


                                    <Color>White</Color>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style></Style>


                                <TextAlign>Left</TextAlign>


                              </Style>


                            </Paragraph>


                          </Paragraphs>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <BackgroundColor>DimGray</BackgroundColor>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox144">


                          <CanGrow>true</CanGrow>


                          <UserSort>


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


                          </UserSort>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Description</Label>


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


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                    <FontWeight>Bold</FontWeight>


                                    <Color>White</Color>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style></Style>


                                <TextAlign>Left</TextAlign>


                              </Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox143</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <BackgroundColor>DimGray</BackgroundColor>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                  </TablixCells>


                </TablixRow>


                <TablixRow>


                  <Height>0.25in</Height>


                  <TablixCells>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="MilestoneType_Data">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


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


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox193">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


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


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                    <Format>=FormatDateTime(Fields!EffectiveDate.Value, DateFormat.ShortDate)</Format>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox193</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox189">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


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


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox189</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Name_Data">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


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


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Supplier2">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


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


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Supplier</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                  </TablixCells>


                </TablixRow>


              </TablixRows>


            </TablixBody>


            <TablixColumnHierarchy>


              <TablixMembers>


                <TablixMember />


                <TablixMember />


                <TablixMember />


                <TablixMember />


                <TablixMember />


              </TablixMembers>


            </TablixColumnHierarchy>


            <TablixRowHierarchy>


              <TablixMembers>


                <TablixMember>


                  <KeepWithGroup>After</KeepWithGroup>


                  <RepeatOnNewPage>true</RepeatOnNewPage>


                </TablixMember>


                <TablixMember>


                  <Group Name="Details13" />


                  <SortExpressions>


                    <SortExpression>


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


                    </SortExpression>


                  </SortExpressions>


                </TablixMember>


              </TablixMembers>


            </TablixRowHierarchy>


            <RepeatColumnHeaders>true</RepeatColumnHeaders>


            <NoRowsMessage>=Code.GetLocTable("LT_Report").GetString("X", "[No data available.]")</NoRowsMessage>


            <DataSetName>MileStone</DataSetName>


            <Top>3.7184in</Top>


            <Left>0.25843in</Left>


            <Height>0.65in</Height>


            <Width>9.46657in</Width>


            <ZIndex>4</ZIndex>


            <Style></Style>


              <Border>


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


              </Border>


              <FontFamily>Tahoma</FontFamily>


              <FontSize>8pt</FontSize>


            </Style>


          </Tablix>


          <Tablix Name="Tablix9">


            <TablixBody>


              <TablixColumns>


                <TablixColumn>


                  <Width>1.3798in</Width>


                </TablixColumn>


                <TablixColumn>


                  <Width>1.9916in</Width>


                </TablixColumn>


                <TablixColumn>


                  <Width>0.25in</Width>


                </TablixColumn>


                <TablixColumn>


                  <Width>1in</Width>


                </TablixColumn>


                <TablixColumn>


                  <Width>1.6243in</Width>


                </TablixColumn>


                <TablixColumn>


                  <Width>0.25in</Width>


                </TablixColumn>


                <TablixColumn>


                  <Width>1in</Width>


                </TablixColumn>


                <TablixColumn>


                  <Width>1.9916in</Width>


                </TablixColumn>


              </TablixColumns>


              <TablixRows>


                <TablixRow>


                  <Height>0.2in</Height>


                  <TablixCells>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox69">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Display Name:</Label>


                                  <Value>=Code.GetLocTable("LT_Report").GetString("V", "[Display Name]") &amp; ":"</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>LightGrey</Color>


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


                            </Border>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="AssetType">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Display Name</Label>


                                  <Value>=First(Fields!DisplayName.Value, "Agreement")</Value>


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>AssetType</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox340">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Value />


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                    <FontWeight>Bold</FontWeight>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox340</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox45">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Status:</Label>


                                  <Value>=Code.GetLocTable("LT_Report").GetString("C", "[Status]")  &amp; ":"</Value>


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox43</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="LifecycleStatus">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Status</Label>


                                  <Value>=First(Fields!Status.Value, "Agreement")</Value>


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>LifecycleStatus</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox3">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Value />


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


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


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox9">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Life Cycle Status:</Label>


                                  <Value>=Code.GetLocTable("LT_Report").GetString("D", "[Life Cycle Status]")  &amp; ":"</Value>


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


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


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox14">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Life Cycle Status</Label>


                                  <Value>=First(Fields!LifecycleStatus.Value, "Agreement")</Value>


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


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


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                  </TablixCells>


                </TablixRow>


                <TablixRow>


                  <Height>0.19792in</Height>


                  <TablixCells>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox198">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Contract Name:</Label>


                                  <Value>=iif(IsNothing(Parameters!ContractID.Value),"", Code.GetLocTable("LT_Report").GetString("ZF", "[Contract Name]") &amp; ":")</Value>


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox198</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox4">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Value>=iif(IsNothing(Parameters!ContractID.Value),"", First(Fields!Conract_DisplayName.Value, "Agreement"))</Value>


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style></Style>


                                <TextAlign>Left</TextAlign>


                              </Style>


                            </Paragraph>


                          </Paragraphs>


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


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox200">


                          <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>Textbox200</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox201">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Effective Date:</Label>


                                  <Value>=Code.GetLocTable("LT_Report").GetString("F", "[Effective Date]") &amp; ":"</Value>


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox201</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox199">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Value>=First(Fields!EffectiveDate.Value, "Agreement")</Value>


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                    <Format>MMM dd, yyyy</Format>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style></Style>


                                <TextAlign>Left</TextAlign>


                              </Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox199</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox203">


                          <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>Textbox203</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox204">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Expiration Date:</Label>


                                  <Value>=Code.GetLocTable("LT_Report").GetString("G", "[Effective Date]") &amp; ":"</Value>


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox204</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox205">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Value>=First(Fields!ExpirationDate.Value, "Agreement")</Value>


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                    <Format>MMM dd, yyyy</Format>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style></Style>


                                <TextAlign>Left</TextAlign>


                              </Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox205</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                  </TablixCells>


                </TablixRow>


                <TablixRow>


                  <Height>0.2in</Height>


                  <TablixCells>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox61">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Contract Manager:</Label>


                                  <Value>=Code.GetLocTable("LT_Report").GetString("B", "[Contract Manager]") &amp; ":"</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>LightGrey</Color>


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


                            </Border>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="MakeModel">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Contract Manager</Label>


                                  <Value>=First(Fields!DisplayName.Value, "AgreementContractManager")</Value>


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>MakeModel</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                        <ColSpan>7</ColSpan>


                      </CellContents>


                    </TablixCell>


                    <TablixCell />


                    <TablixCell />


                    <TablixCell />


                    <TablixCell />


                    <TablixCell />


                    <TablixCell />


                  </TablixCells>


                </TablixRow>


                <TablixRow>


                  <Height>0.2in</Height>


                  <TablixCells>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox56">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Description:</Label>


                                  <Value>=Code.GetLocTable("LT_Report").GetString("L", "[Description]") &amp; ":"</Value>


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox56</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="SerialNumber">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Description</Label>


                                  <Value>=First(Fields!Description.Value, "Agreement")</Value>


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>SerialNumber</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                        <ColSpan>7</ColSpan>


                      </CellContents>


                    </TablixCell>


                    <TablixCell />


                    <TablixCell />


                    <TablixCell />


                    <TablixCell />


                    <TablixCell />


                    <TablixCell />


                  </TablixCells>


                </TablixRow>


                <TablixRow>


                  <Height>0.2in</Height>


                  <TablixCells>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox280">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Terms and Conditions:</Label>


                                  <Value>=Code.GetLocTable("LT_Report").GetString("E", "[Terms and Conditions]") &amp; ":"</Value>


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox280</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox282">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Terms And Conditions</Label>


                                  <Value>=First(Fields!TermsAndConditions.Value, "Agreement")</Value>


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox282</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                        <ColSpan>7</ColSpan>


                      </CellContents>


                    </TablixCell>


                    <TablixCell />


                    <TablixCell />


                    <TablixCell />


                    <TablixCell />


                    <TablixCell />


                    <TablixCell />


                  </TablixCells>


                </TablixRow>


                <TablixRow>


                  <Height>0.2in</Height>


                  <TablixCells>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox70">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Supplier:</Label>


                                  <Value>=Code.GetLocTable("LT_Report").GetString("H", "[Supplier]") &amp; ":"</Value>


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox70</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox72">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Supplier</Label>


                                  <Value>=First(Fields!DisplayName.Value, "AgreementSupplier")</Value>


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox72</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                        <ColSpan>7</ColSpan>


                      </CellContents>


                    </TablixCell>


                    <TablixCell />


                    <TablixCell />


                    <TablixCell />


                    <TablixCell />


                    <TablixCell />


                    <TablixCell />


                  </TablixCells>


                </TablixRow>


                <TablixRow>


                  <Height>0.25in</Height>


                  <TablixCells>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox118">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Contact:</Label>


                                  <Value>=Code.GetLocTable("LT_Report").GetString("I", "[Contact]")  &amp; ":"</Value>


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox118</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox119">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Contact</Label>


                                  <Value>=First(Fields!Contact.Value, "Agreement")</Value>


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox119</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                        <ColSpan>7</ColSpan>


                      </CellContents>


                    </TablixCell>


                    <TablixCell />


                    <TablixCell />


                    <TablixCell />


                    <TablixCell />


                    <TablixCell />


                    <TablixCell />


                  </TablixCells>


                </TablixRow>


                <TablixRow>


                  <Height>0.25in</Height>


                  <TablixCells>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox126">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Cost Center:</Label>


                                  <Value>=Code.GetLocTable("LT_Report").GetString("R", "[Cost Center]")  &amp; ":"</Value>


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox126</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox127">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Cost Center</Label>


                                  <Value>=First(Fields!CostCenter.Value, "Agreement")</Value>


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox127</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                        <ColSpan>7</ColSpan>


                      </CellContents>


                    </TablixCell>


                    <TablixCell />


                    <TablixCell />


                    <TablixCell />


                    <TablixCell />


                    <TablixCell />


                    <TablixCell />


                  </TablixCells>


                </TablixRow>


                <TablixRow>


                  <Height>0.25in</Height>


                  <TablixCells>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox138">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Organization:</Label>


                                  <Value>=Code.GetLocTable("LT_Report").GetString("Q", "[Organization]") &amp; ":"</Value>


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox138</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox140">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Organization</Label>


                                  <Value>=First(Fields!Organization.Value, "Agreement")</Value>


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox140</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                        <ColSpan>7</ColSpan>


                      </CellContents>


                    </TablixCell>


                    <TablixCell />


                    <TablixCell />


                    <TablixCell />


                    <TablixCell />


                    <TablixCell />


                    <TablixCell />


                  </TablixCells>


                </TablixRow>


                <TablixRow>


                  <Height>0.25in</Height>


                  <TablixCells>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox154">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Location:</Label>


                                  <Value>=Code.GetLocTable("LT_Report").GetString("J", "[Location]") &amp; ":"</Value>


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox154</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox155">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Location</Label>


                                  <Value>=First(Fields!Location.Value, "Agreement")</Value>


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox155</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                        <ColSpan>7</ColSpan>


                      </CellContents>


                    </TablixCell>


                    <TablixCell />


                    <TablixCell />


                    <TablixCell />


                    <TablixCell />


                    <TablixCell />


                    <TablixCell />


                  </TablixCells>


                </TablixRow>


                <TablixRow>


                  <Height>0.25in</Height>


                  <TablixCells>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox162">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Notes:</Label>


                                  <Value>=Code.GetLocTable("LT_Report").GetString("ZD", "[Notes]") &amp; ":"</Value>


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox162</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox163">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Value>=First(Fields!Notes.Value, "Agreement")</Value>


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox163</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                        <ColSpan>7</ColSpan>


                      </CellContents>


                    </TablixCell>


                    <TablixCell />


                    <TablixCell />


                    <TablixCell />


                    <TablixCell />


                    <TablixCell />


                    <TablixCell />


                  </TablixCells>


                </TablixRow>


              </TablixRows>


            </TablixBody>


            <TablixColumnHierarchy>


              <TablixMembers>


                <TablixMember />


                <TablixMember />


                <TablixMember />


                <TablixMember />


                <TablixMember />


                <TablixMember />


                <TablixMember />


                <TablixMember />


              </TablixMembers>


            </TablixColumnHierarchy>


            <TablixRowHierarchy>


              <TablixMembers>


                <TablixMember>


                  <Group Name="Details" />


                  <TablixMembers>


                    <TablixMember />


                    <TablixMember />


                    <TablixMember />


                    <TablixMember />


                    <TablixMember />


                    <TablixMember />


                    <TablixMember />


                    <TablixMember />


                    <TablixMember />


                    <TablixMember />


                    <TablixMember />


                  </TablixMembers>


                </TablixMember>


              </TablixMembers>


            </TablixRowHierarchy>


            <DataSetName>LT_Report</DataSetName>


            <Top>0.69236in</Top>


            <Left>0.2502in</Left>


            <Height>2.44792in</Height>


            <Width>9.4873in</Width>


            <ZIndex>5</ZIndex>


            <Style></Style>


              <Border>


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


              </Border>


            </Style>


          </Tablix>


          <Tablix Name="AssociatedAgreement_tablix">


            <TablixBody>


              <TablixColumns>


                <TablixColumn>


                  <Width>1.42059in</Width>


                </TablixColumn>


                <TablixColumn>


                  <Width>1in</Width>


                </TablixColumn>


                <TablixColumn>


                  <Width>1in</Width>


                </TablixColumn>


                <TablixColumn>


                  <Width>2.18687in</Width>


                </TablixColumn>


                <TablixColumn>


                  <Width>2.00012in</Width>


                </TablixColumn>


                <TablixColumn>


                  <Width>0.76817in</Width>


                </TablixColumn>


                <TablixColumn>


                  <Width>1.18238in</Width>


                </TablixColumn>


              </TablixColumns>


              <TablixRows>


                <TablixRow>


                  <Height>0.4in</Height>


                  <TablixCells>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox190">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Type</Label>


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


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                    <FontWeight>Bold</FontWeight>


                                    <Color>White</Color>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style></Style>


                                <TextAlign>Left</TextAlign>


                              </Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox190</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


                            </Border>


                            <BackgroundColor>DimGray</BackgroundColor>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox194">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Effective Date</Label>


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


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                    <FontWeight>Bold</FontWeight>


                                    <Color>White</Color>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style></Style>


                                <TextAlign>Left</TextAlign>


                              </Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox194</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


                            </Border>


                            <BackgroundColor>DimGray</BackgroundColor>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox196">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Expiration Date</Label>


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


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                    <FontWeight>Bold</FontWeight>


                                    <Color>White</Color>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style></Style>


                                <TextAlign>Left</TextAlign>


                              </Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox196</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


                            </Border>


                            <BackgroundColor>DimGray</BackgroundColor>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox46">


                          <CanGrow>true</CanGrow>


                          <UserSort>


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


                          </UserSort>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Agreement Number</Label>


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


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                    <FontWeight>Bold</FontWeight>


                                    <Color>White</Color>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style></Style>


                                <TextAlign>Left</TextAlign>


                              </Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox44</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


                            </Border>


                            <BackgroundColor>DimGray</BackgroundColor>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox71">


                          <CanGrow>true</CanGrow>


                          <UserSort>


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


                          </UserSort>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Name</Label>


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


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                    <FontWeight>Bold</FontWeight>


                                    <Color>White</Color>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style></Style>


                                <TextAlign>Left</TextAlign>


                              </Style>


                            </Paragraph>


                          </Paragraphs>


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


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


                            </Border>


                            <BackgroundColor>DimGray</BackgroundColor>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox181">


                          <CanGrow>true</CanGrow>


                          <UserSort>


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


                          </UserSort>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Status</Label>


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


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                    <FontWeight>Bold</FontWeight>


                                    <Color>White</Color>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style></Style>


                                <TextAlign>Left</TextAlign>


                              </Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox181</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


                            </Border>


                            <BackgroundColor>DimGray</BackgroundColor>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox183">


                          <CanGrow>true</CanGrow>


                          <UserSort>


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


                          </UserSort>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


                                  <Label>Life Cycle Status</Label>


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


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                    <FontWeight>Bold</FontWeight>


                                    <Color>White</Color>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style></Style>


                                <TextAlign>Left</TextAlign>


                              </Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox183</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


                            </Border>


                            <BackgroundColor>DimGray</BackgroundColor>


                            <VerticalAlign>Middle</VerticalAlign>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                  </TablixCells>


                </TablixRow>


                <TablixRow>


                  <Height>0.25in</Height>


                  <TablixCells>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox191">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


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


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox191</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox195">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


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


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                    <Format>MMM dd, yyyy</Format>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox195</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox197">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


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


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                    <Format>MMM dd, yyyy</Format>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox197</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="AgreementNumber2">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


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


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>AgreementNumber</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="DisplayName">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


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


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox182">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


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


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox182</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                    <TablixCell>


                      <CellContents>


                        <Textbox Name="Textbox184">


                          <CanGrow>true</CanGrow>


                          <KeepTogether>true</KeepTogether>


                          <Paragraphs>


                            <Paragraph>


                              <TextRuns>


                                <TextRun>


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


                                  <Style></Style>


                                    <FontFamily>Tahoma</FontFamily>


                                    <FontSize>8pt</FontSize>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style></Style>


                                <TextAlign>Center</TextAlign>


                              </Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>Textbox184</rd:DefaultName>


                          <Style></Style>


                            <Border>


                              <Color>LightGrey</Color>


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


                            </Border>


                            <PaddingLeft>2pt</PaddingLeft>


                            <PaddingRight>2pt</PaddingRight>


                            <PaddingTop>2pt</PaddingTop>


                            <PaddingBottom>2pt</PaddingBottom>


                          </Style>


                        </Textbox>


                      </CellContents>


                    </TablixCell>


                  </TablixCells>


                </TablixRow>


              </TablixRows>


            </TablixBody>


            <TablixColumnHierarchy>


              <TablixMembers>


                <TablixMember />


                <TablixMember />


                <TablixMember />


                <TablixMember />


                <TablixMember />


                <TablixMember />


                <TablixMember />


              </TablixMembers>


            </TablixColumnHierarchy>


            <TablixRowHierarchy>


              <TablixMembers>


                <TablixMember>


                  <FixedData>true</FixedData>


                  <KeepWithGroup>After</KeepWithGroup>


                  <RepeatOnNewPage>true</RepeatOnNewPage>


                </TablixMember>


                <TablixMember>


                  <Group Name="Details8" />


                </TablixMember>


              </TablixMembers>


            </TablixRowHierarchy>


            <RepeatColumnHeaders>true</RepeatColumnHeaders>


            <NoRowsMessage>=Code.GetLocTable("LT_Report").GetString("X", "[No data available.]")</NoRowsMessage>


            <DataSetName>AssociatedAgreement</DataSetName>


            <Top>5.85139in</Top>


            <Left>0.2502in</Left>


            <Height>0.65in</Height>


            <Width>9.55813in</Width>


            <ZIndex>6</ZIndex>


            <Style></Style>


              <Border>


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


              </Border>


            </Style>


          </Tablix>


          <Textbox Name="Textbox130">


            <CanGrow>true</CanGrow>


            <KeepTogether>true</KeepTogether>


            <Paragraphs>


              <Paragraph>


                <TextRuns>


                  <TextRun>


                    <Label>Associated Agreements</Label>


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


                    <Style></Style>


                      <FontFamily>Tahoma</FontFamily>


                      <FontWeight>Bold</FontWeight>


                    </Style>


                  </TextRun>


                </TextRuns>


                <Style /></Style>


              </Paragraph>


            </Paragraphs>


            <rd:DefaultName>Textbox79</rd:DefaultName>


            <Top>5.54583in</Top>


            <Left>0.15148in</Left>


            <Height>0.25in</Height>


            <Width>9.69435in</Width>


            <ZIndex>7</ZIndex>


            <Style></Style>


              <Border>


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


              </Border>


              <PaddingLeft>2pt</PaddingLeft>


              <PaddingRight>2pt</PaddingRight>


              <PaddingTop>2pt</PaddingTop>


              <PaddingBottom>2pt</PaddingBottom>


            </Style>


          </Textbox>


        </ReportItems>


        <KeepTogether>true</KeepTogether>


        <Top>1.01667in</Top>


        <Left>0.05in</Left>


        <Height>6.68681in</Height>


        <Width>9.90695in</Width>


        <ZIndex>1</ZIndex>


        <Style></Style>


          <Border>


            <Color>LightGrey</Color>


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


          </Border>


        </Style>


      </Rectangle>


      <Rectangle Name="Description_rectangle">


        <ReportItems>


          <Rectangle Name="rectReportDescription">


            <ReportItems>


              <Textbox Name="Textbox2">


                <CanGrow>true</CanGrow>


                <KeepTogether>true</KeepTogether>


                <Paragraphs>


                  <Paragraph>


                    <TextRuns>


                      <TextRun>


                        <Label>Report description</Label>


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


                        <Style></Style>


                          <FontFamily>Tahoma</FontFamily>


                          <FontSize>8pt</FontSize>


                        </Style>


                      </TextRun>


                    </TextRuns>


                    <Style /></Style>


                  </Paragraph>


                </Paragraphs>


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


                <Top>0.05in</Top>


                <Left>0.05in</Left>


                <Height>0.2in</Height>


                <Width>9.85695in</Width>


                <Style></Style>


                  <Border>


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


                  </Border>


                  <PaddingLeft>2pt</PaddingLeft>


                  <PaddingRight>2pt</PaddingRight>


                  <PaddingTop>2pt</PaddingTop>


                  <PaddingBottom>2pt</PaddingBottom>


                </Style>


              </Textbox>


            </ReportItems>


            <KeepTogether>true</KeepTogether>


            <Top>0.22347in</Top>


            <Left>0.05in</Left>


            <Height>0.3in</Height>


            <Width>9.90695in</Width>


            <Visibility>


              <Hidden>true</Hidden>


              <ToggleItem>txtDescriptionToggle</ToggleItem>


            </Visibility>


            <Style></Style>


              <Border>


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


              </Border>


            </Style>


          </Rectangle>


          <Textbox Name="txtDescriptionToggle">


            <CanGrow>true</CanGrow>


            <KeepTogether>true</KeepTogether>


            <Paragraphs>


              <Paragraph>


                <TextRuns>


                  <TextRun>


                    <Label>Expand this section to see a full description of this report.</Label>


                    <Value>=Code.GetLocTable("LT_Report").GetString("RDL", "[Expand this section to see a full description of this report.]")</Value>


                    <Style></Style>


                      <FontFamily>Tahoma</FontFamily>


                      <FontSize>8pt</FontSize>


                    </Style>


                  </TextRun>


                </TextRuns>


                <Style /></Style>


              </Paragraph>


            </Paragraphs>


            <Top>0.00347in</Top>


            <Left>0.05in</Left>


            <Height>0.2in</Height>


            <Width>9.88195in</Width>


            <ZIndex>1</ZIndex>


            <Style></Style>


              <Border>


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


              </Border>


              <PaddingLeft>2pt</PaddingLeft>


              <PaddingRight>2pt</PaddingRight>


              <PaddingTop>2pt</PaddingTop>


              <PaddingBottom>2pt</PaddingBottom>


            </Style>


          </Textbox>


        </ReportItems>


        <KeepTogether>true</KeepTogether>


        <Height>0.52694in</Height>


        <Width>9.95695in</Width>


        <ZIndex>2</ZIndex>


        <Style></Style>


          <Border>


            <Color>Silver</Color>


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


          </Border>


          <BottomBorder>


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


          </BottomBorder>


          <BackgroundColor>Gainsboro</BackgroundColor>


        </Style>


      </Rectangle>


    </ReportItems>


    <Height>7.73125in</Height>


    <Style /></Style>


  </Script></Body>


  <Width>9.95695in</Width>


  <Page>


    <PageHeader>


      <Height>0.64297in</Height>


      <PrintOnFirstPage>true</PrintOnFirstPage>


      <PrintOnLastPage>true</PrintOnLastPage>


      <ReportItems>


        <Image Name="Image1">


          <Source>External</Source>


          <Value>ReportHeaderR.png</Value>


          <Sizing>FitProportional</Sizing>


          <Left>5.538in</Left>


          <Height>0.577in</Height>


          <Width>4.287in</Width>


          <ToolTip>V002</ToolTip>


          <Style></Style>


            <Border>


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


            </Border>


          </Style>


        </Image>


        <Textbox Name="Textbox1">


          <CanGrow>true</CanGrow>


          <KeepTogether>true</KeepTogether>


          <Paragraphs>


            <Paragraph>


              <TextRuns>


                <TextRun>


                  <Label>Contract Detail</Label>


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


                  <Style></Style>


                    <FontFamily>Tahoma</FontFamily>


                    <FontSize>11pt</FontSize>


                    <FontWeight>Bold</FontWeight>


                  </Style>


                </TextRun>


              </TextRuns>


              <Style></Style>


                <TextAlign>Left</TextAlign>


              </Style>


            </Paragraph>


          </Paragraphs>


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


          <Top>0.06597in</Top>


          <Height>0.577in</Height>


          <Width>5.587in</Width>


          <ZIndex>1</ZIndex>


          <Style></Style>


            <Border>


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


            </Border>


            <VerticalAlign>Bottom</VerticalAlign>


            <PaddingLeft>2pt</PaddingLeft>


            <PaddingRight>2pt</PaddingRight>


            <PaddingTop>2pt</PaddingTop>


            <PaddingBottom>2pt</PaddingBottom>


          </Style>


        </Textbox>


      </ReportItems>


      <Style></Style>


        <Border>


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


        </Border>


        <BackgroundColor>#bfd0ea</BackgroundColor>


      </Style>


    </PageHeader>


    <PageFooter>


      <Height>0.38541in</Height>


      <PrintOnFirstPage>true</PrintOnFirstPage>


      <PrintOnLastPage>true</PrintOnLastPage>


      <ReportItems>


        <Textbox Name="textbox25">


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


                  </Style>


                </TextRun>


              </TextRuns>


              <Style></Style>


                <TextAlign>Right</TextAlign>


              </Style>


            </Paragraph>


          </Paragraphs>


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


          <Top>0.05in</Top>


          <Left>8.85in</Left>


          <Height>0.2in</Height>


          <Width>0.95in</Width>


          <Style></Style>


            <PaddingLeft>2pt</PaddingLeft>


            <PaddingRight>2pt</PaddingRight>


            <PaddingTop>2pt</PaddingTop>


            <PaddingBottom>2pt</PaddingBottom>


          </Style>


        </Textbox>


      </ReportItems>


      <Style></Style>


        <Border>


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


        </Border>


      </Style>


    </PageFooter>


    <PageHeight>8.5in</PageHeight>


    <PageWidth>11in</PageWidth>


    <LeftMargin>0.5in</LeftMargin>


    <RightMargin>0.5in</RightMargin>


    <TopMargin>0.5in</TopMargin>


    <BottomMargin>0.5in</BottomMargin>


    <Style /></Style>


  </Page>


  <AutoRefresh>0</AutoRefresh>


  <DataSources>


    <DataSource Name="DWDataMart">


      <DataSourceReference>DWDataMart</DataSourceReference>


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


      <rd:DataSourceID>9671bad6-9c4c-452a-8464-24e286f5be25</rd:DataSourceID>


    </DataSource>


  </DataSources>


  <DataSets>


    <DataSet Name="LT_Report">


      <Query>


        <DataSourceName>DWDataMart</DataSourceName>


        <QueryParameters>


          <QueryParameter Name="@ManagementPackSystemName">


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


          </QueryParameter>


          <QueryParameter Name="@ReportSystemName">


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


          </QueryParameter>


          <QueryParameter Name="@LanguageCode">


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


          </QueryParameter>


          <QueryParameter Name="@Scope">


            <Value>%</Value>


          </QueryParameter>


        </QueryParameters>


        <CommandType>StoredProcedure</CommandType>


        <CommandText>ReportDisplayStringGet</CommandText>


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


      </Query>


      <Fields>


        <Field Name="XML_F52E2B61_18A1_11d1_B105_00805F49916B">


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


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


        </Field>


      </Fields>


    </DataSet>


    <DataSet Name="ContractAdminSettings">


      <Query>


        <DataSourceName>DWDataMart</DataSourceName>


        <CommandText>SELECT DISTINCT TOP 1 ExpiredThresholdDays, CloseToExpiredThresholdDays


FROM ContractAdminSettingsDim


WHERE IsDeleted = 0


--AND SourceId = @SourceId</CommandText>


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


      </Query>


      <Fields>


        <Field Name="ExpiredThresholdDays">


          <DataField>ExpiredThresholdDays</DataField>


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


        </Field>


        <Field Name="CloseToExpiredThresholdDays">


          <DataField>CloseToExpiredThresholdDays</DataField>


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


        </Field>


      </Fields>


    </DataSet>


    <DataSet Name="CostEvents">


      <Query>


        <DataSourceName>DWDataMart</DataSourceName>


        <QueryParameters>


          <QueryParameter Name="@ObjectStatusPendingDelete">


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


          </QueryParameter>


          <QueryParameter Name="@AgreementDimKey">


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


          </QueryParameter>


          <QueryParameter Name="@UserLanguage">


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


          </QueryParameter>


        </QueryParameters>


        <CommandText>;WITH vAgreementCostEventTypevw as (


	SELECT A.AgreementCostEventTypeId, 


		ISNULL(B.DisplayName, A.AgreementCostEventTypeValue) AS AgreementCostEventType


	FROM 	  AgreementCostEventTypevw  A


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


				    AND B.LanguageCode	= @UserLanguage)


SELECT	d.Id,


	a.AgreementNumber,


	P.AgreementCostEventType, 


	D.EffectiveDate, 


	Round(D.Amount * E.ExchangeRate,2)	AS AMOUNT,


	G.DisplayName				AS Supplier, 


	I.DisplayName				AS Organization, 


	K.DisplayName				AS CostCenter,


	M.DisplayName				AS Location, 


	O.DisplayName				AS UserName,


	R.DisplayName				AS MileStone_DisplayName


FROM	   AgreementDimvw 		A


INNER JOIN ConfigItemDimvw		B ON A.EntityDimKey				  	= B.EntityDimKey	 AND B.IsDeleted = 0		AND ISNULL(B.ObjectStatus,'') &lt;&gt; @ObjectStatusPendingDelete


INNER JOIN ConfigItemCostEventFactvw	C ON B.ConfigItemDimKey 			  	= C.ConfigItemDimKey	 AND C.DeletedDate IS NULL


INNER JOIN CostEventDimvw		D ON C.ConfigItemHasCostEvents_CostEventDimKey	  	= D.CostEventDimKey	 AND D.IsDeleted = 0


INNER JOIN AgreementCostEventDimvw	Z ON D.BaseManagedEntityId				= Z.BaseManagedEntityId  AND Z.IsDeleted = 0		


INNER JOIN CurrencyDimvw		E ON D.AmountCurrency 				  	= E.ISOCurrencySymbol	 AND E.IsDeleted = 0


LEFT  JOIN CostEventSupplierFactvw	F ON D.CostEventDimKey 				  	= F.CostEventDimKey	 AND F.DeletedDate IS NULL


LEFT  JOIN CompanyDimvw			G ON F.CostEventHasSupplier_CompanyDimKey 	  	= G.CompanyDimKey	 AND G.IsDeleted = 0		AND ISNULL(G.ObjectStatus,'') &lt;&gt; @ObjectStatusPendingDelete


LEFT  JOIN CostEventOrganizationFactvw	H ON D.CostEventDimKey 				  	= H.CostEventDimKey	 AND H.DeletedDate IS NULL


LEFT  JOIN OrganizationDimvw		I ON H.CostEventHasOrganization_OrganizationDimKey	= I.OrganizationDimKey   AND I.IsDeleted = 0		AND ISNULL(I.ObjectStatus,'') &lt;&gt; @ObjectStatusPendingDelete


LEFT  JOIN CostEventCostCenterFactvw	J ON D.CostEventDimKey 				  	= J.CostEventDimKey	 AND J.DeletedDate IS NULL


LEFT  JOIN CostCenterDimvw		K ON J.CostEventHasCostCenter_CostCenterDimKey 	  	= K.CostCenterDimKey	 AND K.IsDeleted = 0		AND ISNULL(K.ObjectStatus,'') &lt;&gt; @ObjectStatusPendingDelete


LEFT  JOIN CostEventLocationFactvw	L ON D.CostEventDimKey 				  	= L.CostEventDimKey	 AND L.DeletedDate IS NULL


LEFT  JOIN LocationDimvw		M ON L.CostEventHasLocation_LocationDimKey 	  	= M.LocationDimKey	 AND M.IsDeleted = 0		AND ISNULL(M.ObjectStatus,'') &lt;&gt; @ObjectStatusPendingDelete


LEFT  JOIN CostEventUserFactvw		N ON D.CostEventDimKey 				  	= N.CostEventDimKey	 AND N.DeletedDate IS NULL


LEFT  JOIN UserDimvw			O ON N.CostEventHasUser_UserDimKey 		  	= O.UserDimKey		 AND O.IsDeleted = 0		AND ISNULL(O.ObjectStatus,'') &lt;&gt; @ObjectStatusPendingDelete





LEFT  JOIN vAgreementCostEventTypevw	P ON Z.Type_AgreementCostEventTypeId 		  	= P.AgreementCostEventTypeId


LEFT  JOIN AgreementCostEventMilestoneFactvw


					Q ON Z.AgreementCostEventDimKey				= Q.AgreementCostEventDimKey AND Q.DeletedDate IS NULL


LEFT  JOIN MilestoneDimvw		R ON Q.AgreementCostEventHasMilestone_MilestoneDimKey	= R.MilestoneDimKey	AND R.IsDeleted = 0		AND ISNULL(R.ObjectStatus,'') &lt;&gt; @ObjectStatusPendingDelete


												


WHERE	A.IsDeleted = 0


AND	ISNULL(A.ObjectStatus,'') &lt;&gt; @ObjectStatusPendingDelete


 AND	A.AgreementDimKey =   @AgreementDimKey


 </CommandText>


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


      </Query>


      <Fields>


        <Field Name="Id">


          <DataField>Id</DataField>


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


        </Field>


        <Field Name="EffectiveDate">


          <DataField>EffectiveDate</DataField>


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


        </Field>


        <Field Name="AMOUNT">


          <DataField>AMOUNT</DataField>


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


        </Field>


        <Field Name="AgreementNumber">


          <DataField>AgreementNumber</DataField>


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


        </Field>


        <Field Name="Supplier">


          <DataField>Supplier</DataField>


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


        </Field>


        <Field Name="Organization">


          <DataField>Organization</DataField>


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


        </Field>


        <Field Name="CostCenter">


          <DataField>CostCenter</DataField>


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


        </Field>


        <Field Name="Location">


          <DataField>Location</DataField>


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


        </Field>


        <Field Name="AgreementCostEventType">


          <DataField>AgreementCostEventType</DataField>


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


        </Field>


        <Field Name="UserName">


          <DataField>UserName</DataField>


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


        </Field>


        <Field Name="MileStone_DisplayName">


          <DataField>MileStone_DisplayName</DataField>


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


        </Field>


      </Fields>


    </DataSet>


    <DataSet Name="BaseCurrency">


      <Query>


        <DataSourceName>DWDataMart</DataSourceName>


        <CommandText>SELECT DISTINCT TOP 1 ISOCurrencySymbol


FROM BaseCurrencyDimvw


WHERE IsDeleted = 0</CommandText>


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


      </Query>


      <Fields>


        <Field Name="ISOCurrencySymbol">


          <DataField>ISOCurrencySymbol</DataField>


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


        </Field>


      </Fields>


    </DataSet>


    <DataSet Name="Agreement">


      <Query>


        <DataSourceName>DWDataMart</DataSourceName>


        <QueryParameters>


          <QueryParameter Name="@AgreementDimKey">


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


          </QueryParameter>


          <QueryParameter Name="@ObjectStatusPendingDelete">


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


          </QueryParameter>


          <QueryParameter Name="@UserLanguage">


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


          </QueryParameter>


          <QueryParameter Name="@ContractID">


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


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


          </QueryParameter>


        </QueryParameters>


        <CommandText>--Query Agreement


declare


	@BaseManagedEntityID UNIQUEIDENTIFIER,


	@LocationDimKey		INT,


	@OrganizationDimKey	INT,


	@CostCenterDimKey	INT,


	@Location		VARCHAR(255),


	@Organization		VARCHAR(255),


	@CostCenter		VARCHAR(255),


	@Row_count		int,


	@pContractID		VARCHAR(255)


	


select @BaseManagedEntityID	= A.BaseManagedEntityId,


	@OrganizationDimKey	= B.AgreementHasOrganization_OrganizationDimKey,


	@CostCenterDimKey	= C.AgreementHasCostCenter_CostCenterDimKey,


	@LocationDimKey		= D.AgreementHasLocation_LocationDimKey	


from AgreementDimvw			A


LEFT JOIN AgreementOrganizationFactvw	B ON A.AgreementDimKey = B.AgreementDimKey AND B.DeletedDate IS NULL


LEFT JOIN AgreementCostCenterFactvw	C ON A.AgreementDimKey = C.AgreementDimKey AND C.DeletedDate IS NULL


LEFT JOIN AgreementLocationFactvw	D ON A.AgreementDimKey = D.AgreementDimKey AND D.DeletedDate IS NULL


where a.AgreementDimKey = @AgreementDimKey





-- When called as a Contract Detail the @ContractID will be null


-- When called from the End Of Contract report it will be null for agreements that do not have a contract


-- When called as a Contract Detail we use Like '%' to select the contract


-- When called from the End of Contract it will use the Contact id if apppropriate


SELECT @pContractID = ISNULL(NULLIF(rtrim(ltrim(@ContractID)),''),'%')














select	@Organization = '',


	@Row_count = 1	


WHILE @OrganizationDimKey IS NOT NULL AND @Row_count &lt;&gt; 0


BEGIN


	SELECT	@Organization		= A.DisplayName + ' \ ' + @Organization, 


		@OrganizationDimKey	= B.OrganizationDimKey


	FROM OrganizationDimvw A


	LEFT JOIN OrganizationChildOrganizationFactvw	B ON A.OrganizationDimKey = B.OrganizationContainsChildOrganization_OrganizationDimKey


							 AND B.DeletedDate is null


	where	A.OrganizationDimKey		= @OrganizationDimKey


	AND	ISNULL(A.ObjectStatus,'')	&lt;&gt; @ObjectStatusPendingDelete


	SELECT @Row_count = @@Rowcount


END


select @Organization = left(@Organization,ABS(LEN(@Organization)-2))








select	@Location = '',


	@Row_count = 1	


WHILE @LocationDimKey IS NOT NULL AND @Row_count &lt;&gt; 0


BEGIN





	SELECT	@Location	= A.DisplayName + ' \ ' + @Location, 


		@LocationDimKey	= B.LocationDimKey


	FROM LocationDimvw A


	LEFT JOIN LocationChildLocationFactvw	B ON A.LocationDimKey = B.LocationContainsChildLocation_LocationDimKey


						 AND B.DeletedDate is null


	where	A.LocationDimKey		= @LocationDimKey


	AND	ISNULL(A.ObjectStatus,'')	&lt;&gt; @ObjectStatusPendingDelete


	SELECT @Row_count = @@Rowcount


END


select @Location = left(@Location,ABS(LEN(@Location)-2))











select	@CostCenter = '',


	@Row_count = 1	


WHILE @CostCenterDimKey IS NOT NULL AND @Row_count &lt;&gt; 0


BEGIN





	SELECT	@CostCenter	= A.DisplayName + ' \ ' + @CostCenter, 


		@CostCenterDimKey	= B.CostCenterDimKey


	FROM CostCenterDimvw A


	LEFT JOIN CostCenterChildCostCenterFactvw	B ON A.CostCenterDimKey = B.CostCenterContainsChildCostCenter_CostCenterDimKey


							 AND B.DeletedDate is null


	where	A.CostCenterDimKey		= @CostCenterDimKey


	AND	ISNULL(A.ObjectStatus,'')	&lt;&gt; @ObjectStatusPendingDelete


	SELECT @Row_count = @@Rowcount


END





select @CostCenter = left(@CostCenter,ABS(LEN(@CostCenter)-2))








;with vDisplayStringDimvw AS (


	SELECT A.DisplayName,A.BaseManagedEntityId 


	FROM  DisplayStringDimvw	A  


	WHERE A.LanguageCode	= @UserLanguage)


select	C.LifecycleStatus,


	d.Status,


	E.Program,


	F.ContractTimeUnit,


	g.ContractTransferability,


	H.UserDefinedAgreementType,


	I.DisplayName Contact,


	@CostCenter		CostCenter,


	@Organization		Organization,


	@Location		Location,


	B.AgreementNumber,


	B.Amount,


	B.AmountIsoCurrencyCode,


	B.Ceiling,


	B.CeilingIsoCurrencyCode,


	B.Coverage,


	B.Description,


	B.DisplayName,


	B.Duration,


	B.EffectiveDate,


	B.ExpirationDate,


	B.Notes,


	B.TermsAndConditions,


	B.Conract_DisplayName,


	B.Contract_Id


from (


	-- User Defined Agreement


	select 	a.AgreementNumber				AgreementNumber,


		NULL						Amount,


		NULL						AmountIsoCurrencyCode,


		NULL						Ceiling,


		NULL						CeilingIsoCurrencyCode,


		NULL						Coverage,


		a.Description					Description,


		a.DisplayName					DisplayName,


		NULL						Duration,


		NULL						DurationUnit_ContractTimeUnitId,


		a.EffectiveDate					EffectiveDate,


		a.ExpirationDate				ExpirationDate,


		a.LifeCycleStatus_AgreementLifeCycleStatusId	LifeCycleStatus_AgreementLifeCycleStatusId,


		a.Notes						Notes,


		NULL						Program_LicensingProgramId,


		a.Status_EntityStatusId				Status_EntityStatusId,


		a.TermsAndConditions				TermsAndConditions,


		NULL						Transferability_ContractTransferabilityId,


		a.Type_UserDefinedAgreementTypeId		Type_UserDefinedAgreementTypeId,


		b.UserDefinedAgreementHasContact_ContactDimKey  ContactDimkKey,


		null						Conract_DisplayName,


		null						Contract_Id


	from	  UserDefinedAgreementDimvw         a


	left join UserDefinedAgreementContactFactvw b on a.UserDefinedAgreementDimKey = b.UserDefinedAgreementDimKey


						     and b.DeletedDate		      is null	


	WHERE	a.BaseManagedEntityId	  = @BaseManagedEntityID


	AND	a.IsDeleted		  = 0


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


	UNION ALL


	-- Lease Agreement


	select	a.AgreementNumber				AgreementNumber,


		NULL						Amount,


		NULL						AmountIsoCurrencyCode,


		a.Ceiling					Ceiling,


		a.CeilingIsoCurrencyCode			CeilingIsoCurrencyCode,


		NULL						Coverage,


		a.Description					Description,


		a.DisplayName					DisplayName,


		NULL						Duration,


		NULL						DurationUnit_ContractTimeUnitId,


		f.EffectiveDate					EffectiveDate,


		f.ExpirationDate				ExpirationDate,


		a.LifeCycleStatus_AgreementLifeCycleStatusId	LifeCycleStatus_AgreementLifeCycleStatusId,


		a.Notes						Notes,


		NULL						Program_LicensingProgramId,


		a.Status_EntityStatusId				Status_EntityStatusId,


		a.TermsAndConditions				TermsAndConditions,


		a.Transferability_ContractTransferabilityId	Transferability_ContractTransferabilityId,


		NULL						Type_UserDefinedAgreementTypeId,


		b.LeaseAgreementContainsContact_ContactDimKey	ContactDimKey,


		f.DisplayName					Conract_DisplayName,


		f.Id						Contract_Id


	from	  LeaseAgreementDimvw	      a


	left join LeaseAgreementContactFactvw b on a.LeaseAgreementDimKey = b.LeaseAgreementDimKey


					       and b.DeletedDate          is null						       


	LEFT JOIN ( 


		select 


			d.DisplayName,


			d.EffectiveDate,


			d.ExpirationDate,


			d.Id,


			e.LeaseAgreementDimKey


		from LeaseContractDimvw	d 


		join LeaseAgreementContractFactvw e ON d.LeaseContractDimKey = e.LeaseAgreementContainsLeaseContract_LeaseContractDimKey


		where	d.Id			= @pContractID


		AND	d.IsDeleted		= 0


		AND	ISNULL(d.ObjectStatus,'') &lt;&gt; @ObjectStatusPendingDelete


		)


						f on a.LeaseAgreementDimKey = f.LeaseAgreementDimKey	           					       					       					       


	WHERE	a.BaseManagedEntityId	  = @BaseManagedEntityID


	AND	a.IsDeleted		  = 0


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


	UNION ALL


	-- Disposal Agreement


	select 	a.AgreementNumber				AgreementNumber,


		NULL						Amount,


		NULL						AmountIsoCurrencyCode,


		NULL						Ceiling,


		NULL						CeilingIsoCurrencyCode,


		NULL						Coverage,


		a.Description					Description,


		a.DisplayName					DisplayName,


		NULL						Duration,


		NULL						DurationUnit_ContractTimeUnitId,


		c.EffectiveDate					EffectiveDate,


		c.ExpirationDate				ExpirationDate,


		a.LifeCycleStatus_AgreementLifeCycleStatusId	LifeCycleStatus_AgreementLifeCycleStatusId,


		a.Notes						Notes,


		NULL						Program_LicensingProgramId,


		a.Status_EntityStatusId				Status_EntityStatusId,


		a.TermsAndConditions				TermsAndConditions,


		NULL						Transferability_ContractTransferabilityId,


		NULL						Type_UserDefinedAgreementTypeId,


		e.ContractHasContact_ContactDimKey		ContactDimKey,


		c.DisplayName					Conract_DisplayName,


		c.Id						Contract_Id


	from	DisposalAgreementDimvw	a


	left join DisposalAgreementContractFactvw b on a.DisposalAgreementDimKey					= b.DisposalAgreementDimKey and b.DeletedDate is null


	left join DisposalContractDimvw		c on b.DisposalAgreementContainsDisposalContract_DisposalContractDimKey	= c.DisposalContractDimKey  and ISNULL(c.ObjectStatus,'') &lt;&gt; @ObjectStatusPendingDelete and c.IsDeleted = 0


						 AND c.Id								like @pContractID


	left join ContractDimvw			d on c.EntityDimKey							= d.EntityDimKey	   and ISNULL(d.ObjectStatus,'') &lt;&gt; @ObjectStatusPendingDelete and d.IsDeleted = 0


	left join ContractContactFactvw		e on d.ContractDimKey							= e.ContractDimKey	   and e.DeletedDate is null


	WHERE	a.BaseManagedEntityId	  = @BaseManagedEntityID


	AND	a.IsDeleted		  = 0


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


	UNION ALL


	-- Support Agreement


	select


		a.AgreementNumber				AgreementNumber,


		a.Amount					Amount,


		a.AmountIsoCurrencyCode				AmountIsoCurrencyCode,


		NULL						Ceiling,


		NULL						CeilingIsoCurrencyCode,


		a.Coverage					Coverage,


		a.Description					Description,


		a.DisplayName					DisplayName,


		NULL						Duration,


		NULL						DurationUnit_ContractTimeUnitId,


		c.EffectiveDate					EffectiveDate,


		c.ExpirationDate				ExpirationDate,


		a.LifeCycleStatus_AgreementLifeCycleStatusId	LifeCycleStatus_AgreementLifeCycleStatusId,


		a.Notes						Notes,


		NULL						Program_LicensingProgramId,


		a.Status_EntityStatusId				Status_EntityStatusId,


		a.TermsAndConditions				TermsAndConditions,


		NULL						Transferability_ContractTransferabilityId,


		NULL						Type_UserDefinedAgreementTypeId,


		e.ContractHasContact_ContactDimKey		ContactDimKey,


		c.DisplayName					Conract_DisplayName,


		c.Id						Contract_Id


	from	SupportAgreementDimvw		a


	left join SupportAgreementContractFactvw b on a.SupportAgreementDimKey						= b.SupportAgreementDimKey and b.DeletedDate is null


	left join SupportContractDimvw		c on b.SupportAgreementContainsSupportContract_SupportContractDimKey	= c.SupportContractDimKey  and ISNULL(c.ObjectStatus,'') &lt;&gt; @ObjectStatusPendingDelete and c.IsDeleted = 0


						 AND c.Id								like @pContractID


	left join ContractDimvw			d on c.EntityDimKey							= d.EntityDimKey	   and ISNULL(d.ObjectStatus,'') &lt;&gt; @ObjectStatusPendingDelete and d.IsDeleted = 0


	left join ContractContactFactvw		e on d.ContractDimKey							= e.ContractDimKey	   and e.DeletedDate is null


	WHERE	a.BaseManagedEntityId	  = @BaseManagedEntityID


	AND	a.IsDeleted		  = 0


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


	UNION ALL


	-- Warranty Agreement


		select 	


		a.AgreementNumber				AgreementNumber,


		NULL						Amount,


		NULL						AmountIsoCurrencyCode,


		NULL						Ceiling,


		NULL						CeilingIsoCurrencyCode,


		NULL						Coverage,


		a.Description					Description,


		a.DisplayName					DisplayName,


		a.Duration					Duration,


		a.DurationUnit_ContractTimeUnitId		DurationUnit_ContractTimeUnitId,


		f.EffectiveDate					EffectiveDate,


		f.ExpirationDate				ExpirationDate,


		a.LifeCycleStatus_AgreementLifeCycleStatusId	LifeCycleStatus_AgreementLifeCycleStatusId,


		a.Notes						Notes,


		NULL						Program_LicensingProgramId,


		a.Status_EntityStatusId				Status_EntityStatusId,


		a.TermsAndConditions				TermsAndConditions,


		NULL						Transferability_ContractTransferabilityId,


		NULL						Type_UserDefinedAgreementTypeId,


		b.WarrantyAgreementContainsContact_ContactDimKey ContacctDimKey,


		f.DisplayName					Conract_DisplayName,


		f.Id						Contract_Id


	from	WarrantyAgreementDimvw	         a


	left join WarrantyAgreementContactFactvw b on a.WarrantyAgreementDimKey = b.WarrantyAgreementDimKey


					          and b.DeletedDate             is null


	LEFT JOIN ( select d.DisplayName,


			d.EffectiveDate,


			d.ExpirationDate,


			d.Id,


			e.WarrantyAgreementDimKey


		from WarrantyContractDimvw	d 


		join WarrantyAgreementContractFactvw e ON d.WarrantyContractDimKey = e.WarrantyAgreementContainsWarrantyContract_WarrantyContractDimKey


		where d.Id like @pContractID


		AND	d.IsDeleted		  = 0


		AND	ISNULL(d.ObjectStatus,'') &lt;&gt; @ObjectStatusPendingDelete)


						f on a.WarrantyAgreementDimKey = f.WarrantyAgreementDimKey	          


	WHERE	a.BaseManagedEntityId	  = @BaseManagedEntityID


	AND	a.IsDeleted		  = 0


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


	UNION ALL


	-- Software License Agreement


	select 	a.AgreementNumber				AgreementNumber,


		NULL						Amount,


		NULL						AmountIsoCurrencyCode,


		NULL						Ceiling,


		NULL						CeilingIsoCurrencyCode,


		NULL						Coverage,


		a.Description					Description,


		a.DisplayName					DisplayName,


		NULL						Duration,


		NULL						DurationUnit_ContractTimeUnitId,


		a.EffectiveDate					EffectiveDate,


		a.ExpirationDate				ExpirationDate,


		a.LifeCycleStatus_AgreementLifeCycleStatusId	LifeCycleStatus_AgreementLifeCycleStatusId,


		a.Notes						Notes,


		a.Program_LicensingProgramId			Program_LicensingProgramId,


		a.Status_EntityStatusId				Status_EntityStatusId,


		a.TermsAndConditions				TermsAndConditions,


		NULL						Transferability_ContractTransferabilityId,


		NULL						Type_UserDefinedAgreementTypeId,


		B.SoftwareLicenseAgreementContainsContact_ContactDimKey ContactDimKey,


		null						Conract_DisplayName,


		null						Contract_Id


	from	  SWLicenseAgtDimvw	   a


	left join SWAgreementContactFactvw b on a.SWLicenseAgtDimKey = b.SWLicenseAgtDimKey


					    and b.DeletedDate        is null


	WHERE	a.BaseManagedEntityId	  = @BaseManagedEntityID


	AND	a.IsDeleted		  = 0


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


	UNION ALL


	-- Software Maintenance and Support Agreements


	select 	a.AgreementNumber				AgreementNumber,


		a.Amount					Amount,


		a.AmountIsoCurrencyCode				AmountIsoCurrencyCode,


		NULL						Ceiling,


		NULL						CeilingIsoCurrencyCode,


		a.Coverage					Coverage,


		a.Description					Description,


		a.DisplayName					DisplayName,


		NULL						Duration,


		NULL						DurationUnit_ContractTimeUnitId,


		a.EffectiveDate					EffectiveDate,


		a.ExpirationDate				ExpirationDate,


		a.LifeCycleStatus_AgreementLifeCycleStatusId	LifeCycleStatus_AgreementLifeCycleStatusId,


		a.Notes						Notes,


		NULL						Program_LicensingProgramId,


		a.Status_EntityStatusId				Status_EntityStatusId,


		a.TermsAndConditions				TermsAndConditions,


		NULL						Transferability_ContractTransferabilityId,


		NULL						Type_UserDefinedAgreementTypeId,


		b.SoftwareMaintenanceAgreementContainsContact_ContactDimKey ContactDimKey,


		null						Conract_DisplayName,


		null						Contract_Id


	from	SWMaintAgtDimvw	 a


	left join SWMaintAgtContactFactvw b on a.SWMaintAgtDimKey = b.SWMaintAgtDimKey


					    and b.DeletedDate        is null


	WHERE	a.BaseManagedEntityId	  = @BaseManagedEntityID


	AND	a.IsDeleted		  = 0


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


									B


LEFT JOIN (


	SELECT	a.AgreementLifeCycleStatusId, 


		ISNULL(b.DisplayName, 


		 a.AgreementLifeCycleStatusValue) LifecycleStatus


	FROM  	  AgreementLifeCycleStatusvw	a


	LEFT JOIN vDisplayStringDimvw		b 


	ON a.EnumTypeId	= b.BaseManagedEntityId)			C ON B.LifeCycleStatus_AgreementLifeCycleStatusId = C.AgreementLifeCycleStatusId


LEFT JOIN (


	SELECT	a.EntityStatusId, 


		ISNULL(b.DisplayName, 


		 a.EntityStatusValue) Status


	FROM  	  EntityStatus			a


	LEFT JOIN vDisplayStringDimvw		b 


	ON a.EnumTypeId	= b.BaseManagedEntityId)			D ON B.Status_EntityStatusId = D.EntityStatusID


LEFT JOIN (


	SELECT	a.LicensingProgramId, 


		ISNULL(b.DisplayName, 


		 a.LicensingProgramValue) Program


	FROM	  LicensingProgramvw		a


	LEFT JOIN vDisplayStringDimvw		b 


	ON a.EnumTypeId	= b.BaseManagedEntityId)			E ON B.Program_LicensingProgramId = e.LicensingProgramId	


LEFT JOIN (


	SELECT	a.ContractTimeUnitId, 


		ISNULL(b.DisplayName, 


		 a.ContractTimeUnitValue) ContractTimeUnit


	FROM	  ContractTimeUnitvw		a


	LEFT JOIN vDisplayStringDimvw		b 


	ON a.EnumTypeId	= b.BaseManagedEntityId)			F ON B.DurationUnit_ContractTimeUnitId = F.ContractTimeUnitId


LEFT JOIN (


	SELECT	a.ContractTransferabilityId, 


		ISNULL(b.DisplayName, 


		a.ContractTransferabilityValue) ContractTransferability


	FROM	  ContractTransferability	a


	LEFT JOIN vDisplayStringDimvw		b 


	ON a.EnumTypeId	= b.BaseManagedEntityId)			G ON B.Transferability_ContractTransferabilityId = G.ContractTransferabilityId	


LEFT JOIN (


	SELECT	a.UserDefinedAgreementTypeId, 


		ISNULL(b.DisplayName, 


		a.UserDefinedAgreementTypeValue) UserDefinedAgreementType


	FROM	  UserDefinedAgreementTypevw	a


	LEFT JOIN vDisplayStringDimvw		b 


	ON a.EnumTypeId	= b.BaseManagedEntityId)			H ON B.Type_UserDefinedAgreementTypeId = H.UserDefinedAgreementTypeId	


LEFT JOIN ContactDimvw							I ON B.ContactDimkKey			= I.ContactDimKey		</CommandText>


      </Query>


      <Fields>


        <Field Name="LifecycleStatus">


          <DataField>LifecycleStatus</DataField>


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


        </Field>


        <Field Name="Status">


          <DataField>Status</DataField>


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


        </Field>


        <Field Name="Amount">


          <DataField>Amount</DataField>


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


        </Field>


        <Field Name="AmountIsoCurrencyCode">


          <DataField>AmountIsoCurrencyCode</DataField>


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


        </Field>


        <Field Name="Program">


          <DataField>Program</DataField>


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


        </Field>


        <Field Name="AgreementNumber">


          <DataField>AgreementNumber</DataField>


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


        </Field>


        <Field Name="ContractTimeUnit">


          <DataField>ContractTimeUnit</DataField>


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


        </Field>


        <Field Name="Contact">


          <DataField>Contact</DataField>


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


        </Field>


        <Field Name="CostCenter">


          <DataField>CostCenter</DataField>


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


        </Field>


        <Field Name="ContractTransferability">


          <DataField>ContractTransferability</DataField>


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


        </Field>


        <Field Name="Organization">


          <DataField>Organization</DataField>


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


        </Field>


        <Field Name="Ceiling">


          <DataField>Ceiling</DataField>


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


        </Field>


        <Field Name="Location">


          <DataField>Location</DataField>


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


        </Field>


        <Field Name="UserDefinedAgreementType">


          <DataField>UserDefinedAgreementType</DataField>


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


        </Field>


        <Field Name="CeilingIsoCurrencyCode">


          <DataField>CeilingIsoCurrencyCode</DataField>


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


        </Field>


        <Field Name="Coverage">


          <DataField>Coverage</DataField>


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


        </Field>


        <Field Name="Description">


          <DataField>Description</DataField>


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


        </Field>


        <Field Name="DisplayName">


          <DataField>DisplayName</DataField>


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


        </Field>


        <Field Name="Duration">


          <DataField>Duration</DataField>


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


        </Field>


        <Field Name="EffectiveDate">


          <DataField>EffectiveDate</DataField>


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


        </Field>


        <Field Name="ExpirationDate">


          <DataField>ExpirationDate</DataField>


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


        </Field>


        <Field Name="Notes">


          <DataField>Notes</DataField>


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


        </Field>


        <Field Name="TermsAndConditions">


          <DataField>TermsAndConditions</DataField>


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


        </Field>


        <Field Name="Conract_DisplayName">


          <DataField>Conract_DisplayName</DataField>


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


        </Field>


        <Field Name="Contract_Id">


          <DataField>Contract_Id</DataField>


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


        </Field>


      </Fields>


    </DataSet>


    <DataSet Name="AgreementContractManager">


      <Query>


        <DataSourceName>DWDataMart</DataSourceName>


        <QueryParameters>


          <QueryParameter Name="@ObjectStatusPendingDelete">


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


          </QueryParameter>


          <QueryParameter Name="@AgreementDimKey">


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


          </QueryParameter>


        </QueryParameters>


        <CommandText>select b.DisplayName  from AgreementSystemUserFactvw a


join SystemUserDimvw b on a.AgreementOwnedBySystemUser_SystemUserDimKey = b.SystemUserDimKey


				and isnull(b.ObjectStatus,'') &lt;&gt; @ObjectStatusPendingDelete


				and b.IsDeleted = 0


where a.DeletedDate is null


and a.AgreementDimKey = @AgreementDimKey</CommandText>


      </Query>


      <Fields>


        <Field Name="DisplayName">


          <DataField>DisplayName</DataField>


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


        </Field>


      </Fields>


    </DataSet>


    <DataSet Name="AgreementSupplier">


      <Query>


        <DataSourceName>DWDataMart</DataSourceName>


        <QueryParameters>


          <QueryParameter Name="@ObjectStatusPendingDelete">


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


          </QueryParameter>


          <QueryParameter Name="@AgreementDimKey">


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


          </QueryParameter>


        </QueryParameters>


        <CommandText>





select b.DisplayName  from AgreementCompanyFactvw a


join CompanyDimvw b on a.AgreementSuppliedByCompany_CompanyDimKey = b.CompanyDimKey


				and isnull(b.ObjectStatus,'') &lt;&gt; @ObjectStatusPendingDelete


				and b.IsDeleted = 0


where a.DeletedDate is null


and a.AgreementDimKey = @AgreementDimKey</CommandText>


      </Query>


      <Fields>


        <Field Name="DisplayName">


          <DataField>DisplayName</DataField>


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


        </Field>


      </Fields>


    </DataSet>


    <DataSet Name="MileStone">


      <Query>


        <DataSourceName>DWDataMart</DataSourceName>


        <QueryParameters>


          <QueryParameter Name="@UserLanguage">


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


          </QueryParameter>


          <QueryParameter Name="@ObjectStatusPendingDelete">


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


          </QueryParameter>


          <QueryParameter Name="@AgreementDimKey">


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


          </QueryParameter>


        </QueryParameters>


        <CommandText>;WITH vMilestoneType as (


	SELECT A.MilestoneTypeId, 


		ISNULL(B.DisplayName, A.MilestoneTypeValue) AS MilestoneType


	FROM 	  MilestoneTypevw  A


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


				    AND B.LanguageCode	= @UserLanguage)


SELECT	A.AgreementNumber,


	D.MilestoneDimKey,


	D.Id, 


	E.MilestoneType, 


	D.EffectiveDate,


	D.DisplayName,


	D.Description


FROM	   AgreementDimvw 		A


INNER JOIN ConfigItemDimvw		B ON A.EntityDimKey				= B.EntityDimKey	 AND B.IsDeleted = 0		AND ISNULL(B.ObjectStatus,'') &lt;&gt; @ObjectStatusPendingDelete


INNER JOIN ConfigItemMilestoneFactvw	C ON B.ConfigItemDimKey 			= C.ConfigItemDimKey	 AND C.DeletedDate IS NULL


INNER JOIN MilestoneDimvw		D ON C.ConfigItemHasMilestones_MilestoneDimKey  = D.MilestoneDimKey	 AND D.IsDeleted = 0		AND ISNULL(D.ObjectStatus,'') &lt;&gt; @ObjectStatusPendingDelete


LEFT  JOIN vMilestoneType		E ON D.Type_MilestoneTypeId			= E.MilestoneTypeId





WHERE	A.IsDeleted = 0


AND	ISNULL(A.ObjectStatus,'') &lt;&gt; @ObjectStatusPendingDelete


AND	A.AgreementDimKey = @AgreementDimKey</CommandText>


      </Query>


      <Fields>


        <Field Name="AgreementNumber">


          <DataField>AgreementNumber</DataField>


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


        </Field>


        <Field Name="MilestoneDimKey">


          <DataField>MilestoneDimKey</DataField>


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


        </Field>


        <Field Name="Id">


          <DataField>Id</DataField>


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


        </Field>


        <Field Name="MilestoneType">


          <DataField>MilestoneType</DataField>


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


        </Field>


        <Field Name="EffectiveDate">


          <DataField>EffectiveDate</DataField>


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


        </Field>


        <Field Name="DisplayName">


          <DataField>DisplayName</DataField>


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


        </Field>


        <Field Name="Description">


          <DataField>Description</DataField>


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


        </Field>


      </Fields>


    </DataSet>


    <DataSet Name="AssociatedAgreement">


      <Query>


        <DataSourceName>DWDataMart</DataSourceName>


        <QueryParameters>


          <QueryParameter Name="@UserLanguage">


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


          </QueryParameter>


          <QueryParameter Name="@AgreementDimKey">


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


          </QueryParameter>


          <QueryParameter Name="@ObjectStatusPendingDelete">


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


          </QueryParameter>


        </QueryParameters>


        <CommandText>;with vDisplayStringDimvw AS (


	SELECT A.DisplayName,A.BaseManagedEntityId 


	FROM  DisplayStringDimvw	A  


	WHERE A.LanguageCode	= @UserLanguage)





select 	a.AgreementNumber				AgreementNumber,


	a.Description					Description,


	a.DisplayName					DisplayName,


	a.EffectiveDate					EffectiveDate,


	a.ExpirationDate				ExpirationDate,


	a.Notes						Notes,


	a.TermsAndConditions				TermsAndConditions,


	c.LifecycleStatus,


	D.Status,


	H.UserDefinedAgreementType


from	  UserDefinedAgreementDimvw         A


join	UserDefinedAgreementAgreementFactvw B on a.UserDefinedAgreementDimKey = B.UserDefinedAgreementDimKey


						and b.UserDefinedAgreementRelatesToAgreement_AgreementDimKey = @AgreementDimKey


						and b.DeletedDate is null


LEFT JOIN (


	SELECT	a.AgreementLifeCycleStatusId, 


		ISNULL(b.DisplayName, 


		 a.AgreementLifeCycleStatusValue) LifecycleStatus


	FROM  	  AgreementLifeCycleStatusvw	a


	LEFT JOIN vDisplayStringDimvw		b 


	ON a.EnumTypeId	= b.BaseManagedEntityId)			C ON A.LifeCycleStatus_AgreementLifeCycleStatusId = C.AgreementLifeCycleStatusId


LEFT JOIN (


	SELECT	a.EntityStatusId, 


		ISNULL(b.DisplayName, 


		 a.EntityStatusValue) Status


	FROM  	  EntityStatus			a


	LEFT JOIN vDisplayStringDimvw		b 


	ON a.EnumTypeId	= b.BaseManagedEntityId)			D ON A.Status_EntityStatusId = D.EntityStatusID


LEFT JOIN (


	SELECT	a.UserDefinedAgreementTypeId, 


		ISNULL(b.DisplayName, 


		a.UserDefinedAgreementTypeValue) UserDefinedAgreementType


	FROM	  UserDefinedAgreementTypevw	a


	LEFT JOIN vDisplayStringDimvw		b 


	ON a.EnumTypeId	= b.BaseManagedEntityId)			H ON A.Type_UserDefinedAgreementTypeId = H.UserDefinedAgreementTypeId	


WHERE	a.IsDeleted		  = 0


AND	ISNULL(a.ObjectStatus,'') &lt;&gt; @ObjectStatusPendingDelete</CommandText>


      </Query>


      <Fields>


        <Field Name="AgreementNumber">


          <DataField>AgreementNumber</DataField>


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


        </Field>


        <Field Name="Description">


          <DataField>Description</DataField>


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


        </Field>


        <Field Name="DisplayName">


          <DataField>DisplayName</DataField>


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


        </Field>


        <Field Name="EffectiveDate">


          <DataField>EffectiveDate</DataField>


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


        </Field>


        <Field Name="ExpirationDate">


          <DataField>ExpirationDate</DataField>


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


        </Field>


        <Field Name="Notes">


          <DataField>Notes</DataField>


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


        </Field>


        <Field Name="TermsAndConditions">


          <DataField>TermsAndConditions</DataField>


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


        </Field>


        <Field Name="LifecycleStatus">


          <DataField>LifecycleStatus</DataField>


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


        </Field>


        <Field Name="Status">


          <DataField>Status</DataField>


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


        </Field>


        <Field Name="UserDefinedAgreementType">


          <DataField>UserDefinedAgreementType</DataField>


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


        </Field>


      </Fields>


    </DataSet>


  </DataSets>


  <ReportParameters>


    <ReportParameter Name="LT_Report">


      <DataType>String</DataType>


      <DefaultValue>


        <DataSetReference>


          <DataSetName>LT_Report</DataSetName>


          <ValueField>XML_F52E2B61_18A1_11d1_B105_00805F49916B</ValueField>


        </DataSetReference>


      </DefaultValue>


      <Hidden>true</Hidden>


    </ReportParameter>


    <ReportParameter Name="AgreementDimKey">


      <DataType>Integer</DataType>


      <Prompt>AgreementDimKey</Prompt>


    </ReportParameter>


    <ReportParameter Name="ExpiredThreshold">


      <DataType>Integer</DataType>


      <DefaultValue>


        <DataSetReference>


          <DataSetName>ContractAdminSettings</DataSetName>


          <ValueField>ExpiredThresholdDays</ValueField>


        </DataSetReference>


      </DefaultValue>


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


      <Hidden>true</Hidden>


    </ReportParameter>


    <ReportParameter Name="CloseToExpiredThreshold">


      <DataType>Integer</DataType>


      <DefaultValue>


        <DataSetReference>


          <DataSetName>ContractAdminSettings</DataSetName>


          <ValueField>CloseToExpiredThresholdDays</ValueField>


        </DataSetReference>


      </DefaultValue>


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


      <Hidden>true</Hidden>


    </ReportParameter>


    <ReportParameter Name="ObjectStatusPendingDelete">


      <DataType>String</DataType>


      <DefaultValue>


        <Values>


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


        </Values>


      </DefaultValue>


      <Hidden>true</Hidden>


    </ReportParameter>


    <ReportParameter Name="ContractID">


      <DataType>String</DataType>


      <Nullable>true</Nullable>


      <AllowBlank>true</AllowBlank>


      <Prompt>ReportParameter1</Prompt>


      <Hidden>true</Hidden>


    </ReportParameter>


  </ReportParameters>


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





Const TimeZoneParameterName As String = "TimeZone"


Const SD_BaseTypeParameterName As String = "StartDate_BaseType"


Const SD_BaseValueParameterName As String = "StartDate_BaseValue"


Const SD_OffsetTypeParameterName As String = "StartDate_OffsetType"


Const SD_OffsetValueParameterName As String = "StartDate_OffsetValue"


Const ED_BaseTypeParameterName As String = "EndDate_BaseType"


Const ED_BaseValueParameterName As String = "EndDate_BaseValue"


Const ED_OffsetTypeParameterName As String = "EndDate_OffsetType"


Const ED_OffsetValueParameterName As String = "EndDate_OffsetValue"


Const IsRelativeTimeSupported As Boolean = False


Const TimeTypeParameterName As String = "TimeType"


Const TimeWeekMapParameterName As String = "TimeWeekMap"





Dim LocTables As System.Collections.Generic.Dictionary(Of String, Microsoft.EnterpriseManagement.Reporting.XmlStringTable)


Dim ReportTimeZone As Microsoft.EnterpriseManagement.Reporting.TimeZoneCoreInformation


Dim ReportStartDate As DateTime


Dim ReportEndDate As DateTime


Dim ReportTime As Microsoft.EnterpriseManagement.Reporting.ParameterProcessor.RelativeTime


Dim ReportCulture As System.Globalization.CultureInfo


Dim ParameterProcessor As Microsoft.EnterpriseManagement.Reporting.ParameterProcessor


Dim TargetList As String





Protected Overrides Sub OnInit()


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


  ReportTimeZone = Microsoft.EnterpriseManagement.Reporting.TimeZoneInformation.Current


  ReportStartDate = DateTime.MinValue


  ReportEndDate = DateTime.MinValue


  ReportTime = Nothing


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


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


  TargetList =Nothing


End Sub





'Public Function GetCallingManagementGroupId() As String


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


'End Function





Public Function GetReportLocLanguageCode() As String


   Return ReportCulture.ThreeLetterWindowsLanguageName


End Function





Public Function GetReportLCID() As Integer


    Return ReportCulture.LCID


End Function





Public Function GetLocTable(Name As String) As Microsoft.EnterpriseManagement.Reporting.XmlStringTable


   Dim LocTable As Microsoft.EnterpriseManagement.Reporting.XmlStringTable





   If Not LocTables.TryGetValue(Name, LocTable) Then


      LocTable = New Microsoft.EnterpriseManagement.Reporting.XmlStringTable(LocTableStringQuery, Report.Parameters(Name).Value)


      LocTables.Add(Name, LocTable)


   End If





   Return LocTable


End Function





Public Function GetReportTimeZone() As Microsoft.EnterpriseManagement.Reporting.TimeZoneCoreInformation


   If IsNothing(ReportTimeZone) Then ReportTimeZone = Microsoft.EnterpriseManagement.Reporting.TimeZoneCoreInformation.FromValueString(Report.Parameters(TimeZoneParameterName).Value)


   Return ReportTimeZone


End Function





Public Function ToDbDate(ByVal DateValue As DateTime) As DateTime


   return GetReportTimeZone.ToUniversalTime(DateValue)


End Function





Public Function ToReportDate(ByVal DateValue As DateTime) As DateTime


   return GetReportTimeZone.ToLocalTime(DateValue)


End Function





Public Function GetReportStartDate() As DateTime


  If (ReportStartDate = DateTime.MinValue) Then


    If (IsRelativeTimeSupported) Then


      ReportStartDate = ParameterProcessor.GetDateTime(ToReportDate(DateTime.UtcNow), Report.Parameters(SD_BaseTypeParameterName).Value, Report.Parameters(SD_BaseValueParameterName).Value, Report.Parameters(SD_OffsetTypeParameterName).Value, Report.Parameters(SD_OffsetValueParameterName).Value, Report.Parameters(TimeTypeParameterName).Value)


    Else


      ReportStartDate = ParameterProcessor.GetDateTime(ToReportDate(DateTime.UtcNow), Report.Parameters(SD_BaseTypeParameterName).Value, Report.Parameters(SD_BaseValueParameterName).Value, Report.Parameters(SD_OffsetTypeParameterName).Value, Report.Parameters(SD_OffsetValueParameterName).Value)


    End if


  End If


  return ReportStartDate


End Function





Public Function GetReportEndDate() As DateTime


  If (ReportEndDate = DateTime.MinValue) Then


    If (IsRelativeTimeSupported) Then


      ReportEndDate = ParameterProcessor.GetDateTime(ToReportDate(DateTime.UtcNow), Report.Parameters(ED_BaseTypeParameterName).Value, Report.Parameters(ED_BaseValueParameterName).Value, Report.Parameters(ED_OffsetTypeParameterName).Value, Report.Parameters(ED_OffsetValueParameterName).Value, Report.Parameters(TimeTypeParameterName).Value)


      If IsBusinessHours(GetReportTimeFilter()) Then ReportEndDate = ReportCulture.Calendar.AddDays(ReportEndDate, 1)


    Else


      ReportEndDate = ParameterProcessor.GetDateTime(ToReportDate(DateTime.UtcNow), Report.Parameters(ED_BaseTypeParameterName).Value, Report.Parameters(ED_BaseValueParameterName).Value, Report.Parameters(ED_OffsetTypeParameterName).Value, Report.Parameters(ED_OffsetValueParameterName).Value)


    End if


  End If


  return ReportEndDate


End Function





Public Function GetReportTimeFilter() As Microsoft.EnterpriseManagement.Reporting.ParameterProcessor.RelativeTime


  If IsNothing(ReportTime) Then ReportTime = New Microsoft.EnterpriseManagement.Reporting.ParameterProcessor.RelativeTime(Report.Parameters(TimeTypeParameterName).Value, Report.Parameters(SD_BaseValueParameterName).Value, Report.Parameters(ED_BaseValueParameterName).Value, CStr(Join(Report.Parameters(TimeWeekMapParameterName).Value, ",")))


  return ReportTime


End Function





Public Function IsBusinessHours(Value As Microsoft.EnterpriseManagement.Reporting.ParameterProcessor.RelativeTime) As Boolean


  return (Not IsNothing(Value)) And (Value.TimeType = Microsoft.EnterpriseManagement.Reporting.ParameterProcessor.RelativeTimeType.Business)


End Function





Public Function FormatDateTime(Format As String, Value As DateTime) As String


  return Value.ToString(Format, ReportCulture)


End Function





Public Function FormatNumber(Format As String, Value As Decimal) As String


  return Value.ToString(Format, ReportCulture)


End Function





Public Function FormatString(Format As String, ParamArray Values() as  Object) As String


  return String.Format(ReportCulture, Format, Values)


End Function





Public Function NullFormatString(Format As String, Value as  String) As String


  return IIF(String.IsNullOrEmpty(Value), String.Empty, String.Format(ReportCulture, Format, Value))


End Function





Public Function FormatBusinessHours(Format As String, Value As Microsoft.EnterpriseManagement.Reporting.ParameterProcessor.RelativeTime) As String


  Dim result As String





  If IsBusinessHours(Value) Then


 


    Dim firstDay As DayOfWeek


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





    firstDay = ReportCulture.DateTimeFormat.FirstDayOfWeek


    days = new System.Collections.Generic.List(Of String)()





    For loopDay As DayOfWeek = DayOfWeek.Sunday To DayOfWeek.Saturday


      Dim day As DayOfWeek


      day = CType((CInt(loopDay) + CInt(firstDay)) Mod 7, DayOfWeek)





      If value.WeekMap.Contains(day) Then days.Add(ReportCulture.DateTimeFormat.GetAbbreviatedDayName(day))


    Next loopDay





     result = FormatString(Format, DateTime.Today.Add(Value.StartTime).ToString(ReportCulture.DateTimeFormat.ShortTimePattern), DateTime.Today.Add(Value.EndTime).ToString(ReportCulture.DateTimeFormat.ShortTimePattern), String.Join(",", days.ToArray()))





  Else


     result = String.Empty


  End if


  


  return result


End Function





Public Function BuildXmlValueList(ByVal ValueList() As Object) As String


    Return Microsoft.EnterpriseManagement.Reporting.MultiValueParameter.ToXml("Data", "Value", ValueList)


End Function








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





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


Const FormatListParameterName As String = "DataFormat"





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





    Public Interface IDataFormatter


        Function FormatData(ByVal Value As String) As String


    End Interface





    Public Class RankDataFormatter


        Implements IDataFormatter





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


        Private Culture As System.Globalization.CultureInfo





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


            Culture = ReportCulture


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





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


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


            Next


        End Sub





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


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





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


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


                If RunningValue &gt; 0 Then


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


                Else


                    Exit For


                End If


            Next





            Return Result


        End Function


    End Class





    Public Class LookupDataFormatter


        Implements IDataFormatter





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





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


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


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


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


            Next


        End Sub





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


            Dim Result As String


            If MappingTable.ContainsKey(Value) Then


                Result = MappingTable(Value)


            Else


                Result = Value


            End If


            Return Result


        End Function


    End Class





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


        If IsNothing(ReportFormatList) Then


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


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





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


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


                Dim Formatter As IDataFormatter = Nothing





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


                    Case "RANK"


                        Formatter = New RankDataFormatter(Node, ReportCulture)


                    Case "LOOKUP"


                        Formatter = New LookupDataFormatter(Node)


                End Select





                If Not IsNothing(Formatter) Then


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


                End If


            Next


        End If


        Return ReportFormatList


    End Function





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


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


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


            If FormatList.ContainsKey(FormatName) Then


                Return FormatList(FormatName).FormatData(Value)


            End If


        End If





        If Not String.IsNullOrEmpty(DataType) Then


            If DataType = "DateTime" Then


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


            ElseIf DataType.StartsWith("UInt") Then


                Return FormatNumber("G", Value)


            End If


        End If





        Return Value


    End Function





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





Public Dim CurrentObjectList As String





    Public Function InitList(ByRef List As String) As String


        List  = String.Empty


        Return List


    End Function





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


        List = List + Item


        Return List


    End Function





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


        Dim Xml As System.Xml.XmlDocument


        Xml = New System.Xml.XmlDocument()


        Xml.LoadXml(OptionsXml)





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


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


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


            If Not Result.Contains(ObjectNode.InnerText) Then


                Result.Add(ObjectNode.InnerText)


            End If


        Next





        Return Result.ToArray()


    End Function


</Script></Code>


  <Language>en-US</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>Inch</rd:ReportUnitType>


  <rd:ReportID>c149c887-0af1-4cb8-b2b7-057731e8b2ad</rd:ReportID>


</Report>