<?xml version="1.0" encoding="utf-8"?>
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
  <RightMargin>1in</RightMargin>
  <Body>
    <ReportItems>
      <Table Name="table1">
        <Height>0.5in</Height>
        <ZIndex>1</ZIndex>
        <Style />
        <Header>
          <TableRows>
            <TableRow>
              <Height>0.25in</Height>
              <TableCells>
                <TableCell>
                  <ReportItems>
                    <Textbox Name="textbox2">
                      <Style>
                        <PaddingLeft>2pt</PaddingLeft>
                        <FontFamily>Verdana</FontFamily>
                        <BorderColor>
                          <Default>#081bcb</Default>
                        </BorderColor>
                        <BorderStyle>
                          <Bottom>Solid</Bottom>
                          <Top>Solid</Top>
                        </BorderStyle>
                        <TextAlign>Left</TextAlign>
                        <Color>#081bcb</Color>
                        <PaddingBottom>2pt</PaddingBottom>
                        <PaddingTop>2pt</PaddingTop>
                        <PaddingRight>2pt</PaddingRight>
                        <FontWeight>700</FontWeight>
                      </Style>
                      <ZIndex>5</ZIndex>
                      <rd:DefaultName>textbox2</rd:DefaultName>
                      <Value>Report Name</Value>
                    </Textbox>
                  </ReportItems>
                </TableCell>
                <TableCell>
                  <ReportItems>
                    <Textbox Name="textbox3">
                      <Style>
                        <PaddingLeft>2pt</PaddingLeft>
                        <FontFamily>Verdana</FontFamily>
                        <BorderColor>
                          <Default>#081bcb</Default>
                        </BorderColor>
                        <BorderStyle>
                          <Bottom>Solid</Bottom>
                          <Top>Solid</Top>
                        </BorderStyle>
                        <TextAlign>Center</TextAlign>
                        <Color>#081bcb</Color>
                        <PaddingBottom>2pt</PaddingBottom>
                        <PaddingTop>2pt</PaddingTop>
                        <PaddingRight>2pt</PaddingRight>
                        <FontWeight>700</FontWeight>
                      </Style>
                      <ZIndex>4</ZIndex>
                      <rd:DefaultName>textbox3</rd:DefaultName>
                      <Value>Execution Count</Value>
                    </Textbox>
                  </ReportItems>
                </TableCell>
                <TableCell>
                  <ReportItems>
                    <Textbox Name="textbox4">
                      <Style>
                        <PaddingLeft>2pt</PaddingLeft>
                        <FontFamily>Verdana</FontFamily>
                        <BorderColor>
                          <Default>#081bcb</Default>
                        </BorderColor>
                        <BorderStyle>
                          <Bottom>Solid</Bottom>
                          <Top>Solid</Top>
                        </BorderStyle>
                        <TextAlign>Right</TextAlign>
                        <Color>#081bcb</Color>
                        <PaddingBottom>2pt</PaddingBottom>
                        <PaddingTop>2pt</PaddingTop>
                        <PaddingRight>2pt</PaddingRight>
                        <FontWeight>700</FontWeight>
                      </Style>
                      <ZIndex>3</ZIndex>
                      <rd:DefaultName>textbox4</rd:DefaultName>
                      <Value>Avg. Execution Time</Value>
                    </Textbox>
                  </ReportItems>
                </TableCell>
              </TableCells>
            </TableRow>
          </TableRows>
        </Header>
        <DataSetName>RSExecutionLog</DataSetName>
        <Top>0.625in</Top>
        <Width>6in</Width>
        <TableGroups>
          <TableGroup>
            <Header>
              <TableRows>
                <TableRow>
                  <Height>0.25in</Height>
                  <TableCells>
                    <TableCell>
                      <ReportItems>
                        <Textbox Name="Name">
                          <Style>
                            <PaddingLeft>2pt</PaddingLeft>
                            <FontFamily>Verdana</FontFamily>
                            <BackgroundColor>WhiteSmoke</BackgroundColor>
                            <PaddingBottom>2pt</PaddingBottom>
                            <PaddingTop>2pt</PaddingTop>
                            <PaddingRight>2pt</PaddingRight>
                          </Style>
                          <ZIndex>2</ZIndex>
                          <rd:DefaultName>Name</rd:DefaultName>
                          <CanGrow>true</CanGrow>
                          <Value>=Fields!Name.Value</Value>
                        </Textbox>
                      </ReportItems>
                    </TableCell>
                    <TableCell>
                      <ReportItems>
                        <Textbox Name="ReportKey">
                          <Style>
                            <PaddingLeft>2pt</PaddingLeft>
                            <FontFamily>Verdana</FontFamily>
                            <BackgroundColor>WhiteSmoke</BackgroundColor>
                            <TextAlign>Center</TextAlign>
                            <PaddingBottom>2pt</PaddingBottom>
                            <PaddingTop>2pt</PaddingTop>
                            <PaddingRight>2pt</PaddingRight>
                          </Style>
                          <ZIndex>1</ZIndex>
                          <rd:DefaultName>ReportKey</rd:DefaultName>
                          <Value>=COUNT(Fields!ReportKey.Value)</Value>
                        </Textbox>
                      </ReportItems>
                    </TableCell>
                    <TableCell>
                      <ReportItems>
                        <Textbox Name="TotalTime">
                          <Style>
                            <PaddingLeft>2pt</PaddingLeft>
                            <Format>##.0 secs</Format>
                            <FontFamily>Verdana</FontFamily>
                            <BackgroundColor>WhiteSmoke</BackgroundColor>
                            <PaddingBottom>2pt</PaddingBottom>
                            <PaddingTop>2pt</PaddingTop>
                            <PaddingRight>2pt</PaddingRight>
                          </Style>
                          <rd:DefaultName>TotalTime</rd:DefaultName>
                          <Value>=Sum(Fields!TotalTime.Value)/ COUNT(Fields!ReportKey.Value) / 1000</Value>
                        </Textbox>
                      </ReportItems>
                    </TableCell>
                  </TableCells>
                </TableRow>
              </TableRows>
            </Header>
            <Grouping Name="table1_Group1">
              <GroupExpressions>
                <GroupExpression>=Fields!ReportKey.Value</GroupExpression>
              </GroupExpressions>
            </Grouping>
            <Sorting>
              <SortBy>
                <SortExpression>=SUM(Fields!TotalTime.Value)/COUNT( Fields!ReportKey.Value)</SortExpression>
                <Direction>Descending</Direction>
              </SortBy>
            </Sorting>
          </TableGroup>
        </TableGroups>
        <Left>0.125in</Left>
        <TableColumns>
          <TableColumn>
            <Width>2in</Width>
          </TableColumn>
          <TableColumn>
            <Width>2in</Width>
          </TableColumn>
          <TableColumn>
            <Width>2in</Width>
          </TableColumn>
        </TableColumns>
      </Table>
      <Textbox Name="textbox1">
        <Style>
          <PaddingLeft>2pt</PaddingLeft>
          <FontSize>18pt</FontSize>
          <TextAlign>Center</TextAlign>
          <Color>#081bcb</Color>
          <PaddingBottom>2pt</PaddingBottom>
          <PaddingTop>2pt</PaddingTop>
          <PaddingRight>2pt</PaddingRight>
          <FontWeight>700</FontWeight>
        </Style>
        <Height>0.375in</Height>
        <Width>6in</Width>
        <CanGrow>true</CanGrow>
        <Value>Longest Running Reports</Value>
        <Left>0.125in</Left>
      </Textbox>
    </ReportItems>
    <Style />
    <Height>2in</Height>
  </Body>
  <TopMargin>1in</TopMargin>
  <DataSources>
    <DataSource Name="RSExecutionLog">
      <rd:DataSourceID>8bf98867-4db1-4457-9036-341ab59283ba</rd:DataSourceID>
      <DataSourceReference>RSExecutionLog</DataSourceReference>
    </DataSource>
  </DataSources>
  <Width>6.25in</Width>
  <DataSets>
    <DataSet Name="RSExecutionLog">
      <Fields>
        <Field Name="ReportKey">
          <DataField>ReportKey</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
        <Field Name="Name">
          <DataField>Name</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="TimeDataRetrieval">
          <DataField>TimeDataRetrieval</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
        <Field Name="TimeProcessing">
          <DataField>TimeProcessing</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
        <Field Name="TimeRendering">
          <DataField>TimeRendering</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
        <Field Name="TotalTime">
          <DataField>TotalTime</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
      </Fields>
      <Query>
        <DataSourceName>RSExecutionLog</DataSourceName>
        <CommandText>SELECT     ExecutionLogs.ReportKey, Reports.Name, ExecutionLogs.TimeDataRetrieval, ExecutionLogs.TimeProcessing, ExecutionLogs.TimeRendering, 
                      ExecutionLogs.TimeDataRetrieval + ExecutionLogs.TimeProcessing + ExecutionLogs.TimeRendering AS TotalTime
FROM         ExecutionLogs INNER JOIN
                      Reports ON ExecutionLogs.ReportKey = Reports.ReportKey
WHERE     (ExecutionLogs.TimeStart BETWEEN @pMinDate AND @pMaxDate)</CommandText>
        <QueryParameters>
          <QueryParameter Name="@pMinDate">
            <Value>=Parameters!pMinDate.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@pMaxDate">
            <Value>=Parameters!pMaxDate.Value</Value>
          </QueryParameter>
        </QueryParameters>
        <Timeout>30</Timeout>
      </Query>
    </DataSet>
    <DataSet Name="dsDates">
      <Fields>
        <Field Name="MinDate">
          <DataField>MinDate</DataField>
          <rd:TypeName>System.DateTime</rd:TypeName>
        </Field>
        <Field Name="MaxDate">
          <DataField>MaxDate</DataField>
          <rd:TypeName>System.DateTime</rd:TypeName>
        </Field>
      </Fields>
      <Query>
        <DataSourceName>RSExecutionLog</DataSourceName>
        <CommandText>SELECT     MIN(TimeStart) AS MinDate, MAX(TimeStart) AS MaxDate
FROM         ExecutionLogs</CommandText>
        <Timeout>30</Timeout>
      </Query>
    </DataSet>
  </DataSets>
  <LeftMargin>1in</LeftMargin>
  <rd:SnapToGrid>true</rd:SnapToGrid>
  <rd:DrawGrid>true</rd:DrawGrid>
  <rd:ReportID>c832cfaa-3f76-492e-8ebc-c50d7c734faa</rd:ReportID>
  <BottomMargin>1in</BottomMargin>
  <ReportParameters>
    <ReportParameter Name="pMinDate">
      <DataType>DateTime</DataType>
      <DefaultValue>
        <DataSetReference>
          <DataSetName>dsDates</DataSetName>
          <ValueField>MinDate</ValueField>
        </DataSetReference>
      </DefaultValue>
      <AllowBlank>true</AllowBlank>
      <Prompt>Start Date:  </Prompt>
    </ReportParameter>
    <ReportParameter Name="pMaxDate">
      <DataType>DateTime</DataType>
      <DefaultValue>
        <DataSetReference>
          <DataSetName>dsDates</DataSetName>
          <ValueField>MaxDate</ValueField>
        </DataSetReference>
      </DefaultValue>
      <AllowBlank>true</AllowBlank>
      <Prompt>End Date:  </Prompt>
    </ReportParameter>
  </ReportParameters>
</Report>