<?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>
    <ReportItems>
      <Textbox Name="Textbox1">
        <CanGrow>true</CanGrow>
        <KeepTogether>true</KeepTogether>
        <Paragraphs>
          <Paragraph>
            <TextRuns>
              <TextRun>
                <Value>="Number of Blocked Processes on " &amp; First(Fields!ServerName.Value, "ServerName")</Value>
                <Style>
                  <FontSize>22pt</FontSize>
                  <Color>White</Color>
                </Style>
              </TextRun>
            </TextRuns>
            <Style>
              <TextAlign>Center</TextAlign>
            </Style>
          </Paragraph>
        </Paragraphs>
        <rd:DefaultName>Textbox1</rd:DefaultName>
        <Top>0.17167in</Top>
        <Left>0.2175in</Left>
        <Height>1.20833in</Height>
        <Width>8.79167in</Width>
        <Style>
          <Border>
            <Style>None</Style>
          </Border>
          <VerticalAlign>Middle</VerticalAlign>
          <PaddingLeft>2pt</PaddingLeft>
          <PaddingRight>2pt</PaddingRight>
          <PaddingTop>2pt</PaddingTop>
          <PaddingBottom>2pt</PaddingBottom>
        </Style>
      </Textbox>
      <Textbox Name="Textbox2">
        <CanGrow>true</CanGrow>
        <KeepTogether>true</KeepTogether>
        <Paragraphs>
          <Paragraph>
            <TextRuns>
              <TextRun>
                <Value>=IIF(Sum(Fields!NumBlockedProcesses.Value, "NumberBlocked")&gt;0,IIF(Sum(Fields!NumBlockedProcesses.Value, "NumberBlocked")=1,"There is " &amp; Sum(Fields!NumBlockedProcesses.Value, "NumberBlocked") &amp; " blocked process at this time.", "There are " &amp; Sum(Fields!NumBlockedProcesses.Value, "NumberBlocked") &amp; " blocked processes at this time."), "There are no blocked processes at this time.")</Value>
                <Style>
                  <FontSize>16pt</FontSize>
                  <Color>White</Color>
                </Style>
              </TextRun>
            </TextRuns>
            <Style>
              <TextAlign>Center</TextAlign>
            </Style>
          </Paragraph>
        </Paragraphs>
        <rd:DefaultName>Textbox2</rd:DefaultName>
        <Top>3.03542in</Top>
        <Left>1.6675in</Left>
        <Height>0.76667in</Height>
        <Width>5.85in</Width>
        <ZIndex>1</ZIndex>
        <Style>
          <Border>
            <Style>None</Style>
          </Border>
          <BackgroundColor>=IIF(Sum(Fields!NumBlockedProcesses.Value, "NumberBlocked") &gt; 0, "Red", "Green")</BackgroundColor>
          <VerticalAlign>Middle</VerticalAlign>
          <PaddingLeft>2pt</PaddingLeft>
          <PaddingRight>2pt</PaddingRight>
          <PaddingTop>2pt</PaddingTop>
          <PaddingBottom>2pt</PaddingBottom>
        </Style>
      </Textbox>
      <Textbox Name="Textbox5">
        <CanGrow>true</CanGrow>
        <KeepTogether>true</KeepTogether>
        <Paragraphs>
          <Paragraph>
            <TextRuns>
              <TextRun>
                <Value>Go to Report Library</Value>
                <Style>
                  <FontSize>14pt</FontSize>
                  <Color>White</Color>
                </Style>
              </TextRun>
            </TextRuns>
            <Style>
              <TextAlign>Center</TextAlign>
            </Style>
          </Paragraph>
        </Paragraphs>
        <rd:DefaultName>Textbox5</rd:DefaultName>
        <ActionInfo>
          <Actions>
            <Action>
              <Drillthrough>
                <ReportName>ReportLibrary</ReportName>
              </Drillthrough>
            </Action>
          </Actions>
        </ActionInfo>
        <Top>2.09167in</Top>
        <Left>1.68833in</Left>
        <Height>0.76667in</Height>
        <Width>5.85in</Width>
        <ZIndex>2</ZIndex>
        <Style>
          <Border>
            <Style>None</Style>
          </Border>
          <BackgroundColor>DimGray</BackgroundColor>
          <VerticalAlign>Middle</VerticalAlign>
          <PaddingLeft>2pt</PaddingLeft>
          <PaddingRight>2pt</PaddingRight>
          <PaddingTop>2pt</PaddingTop>
          <PaddingBottom>2pt</PaddingBottom>
        </Style>
      </Textbox>
      <Textbox Name="Textbox6">
        <CanGrow>true</CanGrow>
        <KeepTogether>true</KeepTogether>
        <Paragraphs>
          <Paragraph>
            <TextRuns>
              <TextRun>
                <Value>Click to See Details about Current Processes</Value>
                <Style>
                  <FontSize>14pt</FontSize>
                  <Color>White</Color>
                </Style>
              </TextRun>
            </TextRuns>
            <Style>
              <TextAlign>Center</TextAlign>
            </Style>
          </Paragraph>
        </Paragraphs>
        <rd:DefaultName>Textbox5</rd:DefaultName>
        <ActionInfo>
          <Actions>
            <Action>
              <Drillthrough>
                <ReportName>Processes</ReportName>
              </Drillthrough>
            </Action>
          </Actions>
        </ActionInfo>
        <Top>3.97917in</Top>
        <Left>1.6675in</Left>
        <Height>0.76667in</Height>
        <Width>5.85in</Width>
        <ZIndex>3</ZIndex>
        <Style>
          <Border>
            <Style>None</Style>
          </Border>
          <BackgroundColor>DimGray</BackgroundColor>
          <VerticalAlign>Middle</VerticalAlign>
          <PaddingLeft>2pt</PaddingLeft>
          <PaddingRight>2pt</PaddingRight>
          <PaddingTop>2pt</PaddingTop>
          <PaddingBottom>2pt</PaddingBottom>
        </Style>
      </Textbox>
      <Line Name="Line4">
        <Top>1.59167in</Top>
        <Left>0.2175in</Left>
        <Height>0in</Height>
        <Width>8.79167in</Width>
        <ZIndex>4</ZIndex>
        <Style>
          <Border>
            <Color>SlateGray</Color>
            <Style>Solid</Style>
            <Width>1.5pt</Width>
          </Border>
          <TopBorder>
            <Color>SlateGray</Color>
            <Style>Solid</Style>
            <Width>1.5pt</Width>
          </TopBorder>
          <BottomBorder>
            <Color>SlateGray</Color>
            <Style>Solid</Style>
            <Width>1.5pt</Width>
          </BottomBorder>
          <LeftBorder>
            <Color>SlateGray</Color>
            <Style>Solid</Style>
            <Width>1.5pt</Width>
          </LeftBorder>
          <RightBorder>
            <Color>SlateGray</Color>
            <Style>Solid</Style>
            <Width>1.5pt</Width>
          </RightBorder>
        </Style>
      </Line>
    </ReportItems>
    <Height>6.14166in</Height>
    <Style>
      <Border>
        <Style>None</Style>
      </Border>
      <BackgroundColor>DarkBlue</BackgroundColor>
    </Style>
  </Body>
  <Width>9.3925in</Width>
  <Page>
    <LeftMargin>1in</LeftMargin>
    <RightMargin>1in</RightMargin>
    <TopMargin>1in</TopMargin>
    <BottomMargin>1in</BottomMargin>
    <Style />
  </Page>
  <AutoRefresh>0</AutoRefresh>
  <DataSources>
    <DataSource Name="Local">
      <ConnectionProperties>
        <DataProvider>SQL</DataProvider>
        <ConnectString>Data Source=Localhost;Initial Catalog=Master</ConnectString>
        <IntegratedSecurity>true</IntegratedSecurity>
      </ConnectionProperties>
      <rd:SecurityType>Integrated</rd:SecurityType>
      <rd:DataSourceID>54922c84-9432-413e-8622-3a3530b3963a</rd:DataSourceID>
    </DataSource>
  </DataSources>
  <DataSets>
    <DataSet Name="NumberBlocked">
      <Query>
        <DataSourceName>Local</DataSourceName>
        <CommandText>SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED


SELECT
		Count(*) 'NumBlockedProcesses'
FROM sys.sysprocesses p
	INNER JOIN sysdatabases d
		ON p.dbid = d.dbid
	LEFT OUTER JOIN (SELECT spid 
					 FROM  master.sys.sysprocesses a
				     WHERE  exists ( SELECT b.*
							         FROM master.sys.sysprocesses b
							         WHERE b.blocked &gt; 0 
										AND b.blocked = a.spid ) 
										 AND NOT
											EXISTS ( SELECT b.*
													 FROM master.sys.sysprocesses b
													 WHERE b.blocked &gt; 0 
														AND b.spid = a.spid )) l
					ON p.spid = l.spid
WHERE p.spid &gt; 50
AND blocked &gt; 0</CommandText>
      </Query>
      <Fields>
        <Field Name="NumBlockedProcesses">
          <DataField>NumBlockedProcesses</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
      </Fields>
    </DataSet>
    <DataSet Name="ServerName">
      <Query>
        <DataSourceName>Local</DataSourceName>
        <CommandText>Select @@servername AS 'ServerName'</CommandText>
      </Query>
      <Fields>
        <Field Name="ServerName">
          <DataField>ServerName</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
      </Fields>
    </DataSet>
  </DataSets>
  <rd:ReportUnitType>Inch</rd:ReportUnitType>
  <rd:ReportID>675f5569-8cc2-46f8-95a4-065221d09fbb</rd:ReportID>
</Report>