<?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="Textbox2">
        <CanGrow>true</CanGrow>
        <KeepTogether>true</KeepTogether>
        <Paragraphs>
          <Paragraph>
            <TextRuns>
              <TextRun>
                <Value>Report Library</Value>
                <Style>
                  <FontSize>26pt</FontSize>
                  <Color>White</Color>
                </Style>
              </TextRun>
            </TextRuns>
            <Style>
              <TextAlign>Center</TextAlign>
            </Style>
          </Paragraph>
        </Paragraphs>
        <rd:DefaultName>Textbox2</rd:DefaultName>
        <Top>0.11056in</Top>
        <Left>3.78625in</Left>
        <Height>0.65388in</Height>
        <Width>7.76374in</Width>
        <Style>
          <Border>
            <Style>None</Style>
          </Border>
          <BackgroundColor>DarkBlue</BackgroundColor>
          <VerticalAlign>Middle</VerticalAlign>
          <PaddingLeft>2pt</PaddingLeft>
          <PaddingRight>2pt</PaddingRight>
          <PaddingTop>2pt</PaddingTop>
          <PaddingBottom>2pt</PaddingBottom>
        </Style>
      </Textbox>
      <Textbox Name="Textbox117">
        <CanGrow>true</CanGrow>
        <KeepTogether>true</KeepTogether>
        <Paragraphs>
          <Paragraph>
            <TextRuns>
              <TextRun>
                <Value>="Click Here for steps to add a report "</Value>
                <Style>
                  <FontSize>14pt</FontSize>
                  <Color>White</Color>
                </Style>
              </TextRun>
            </TextRuns>
            <Style>
              <TextAlign>Right</TextAlign>
            </Style>
          </Paragraph>
        </Paragraphs>
        <rd:DefaultName>Textbox117</rd:DefaultName>
        <ActionInfo>
          <Actions>
            <Action>
              <Drillthrough>
                <ReportName>HowToAddAnotherReport</ReportName>
              </Drillthrough>
            </Action>
          </Actions>
        </ActionInfo>
        <Top>0.11056in</Top>
        <Left>11.54999in</Left>
        <Height>0.65388in</Height>
        <Width>3.68835in</Width>
        <ZIndex>1</ZIndex>
        <Style>
          <Border>
            <Style>None</Style>
          </Border>
          <BackgroundColor>DarkBlue</BackgroundColor>
          <VerticalAlign>Middle</VerticalAlign>
          <PaddingLeft>2pt</PaddingLeft>
          <PaddingRight>2pt</PaddingRight>
          <PaddingTop>2pt</PaddingTop>
          <PaddingBottom>2pt</PaddingBottom>
        </Style>
      </Textbox>
      <Textbox Name="Textbox118">
        <CanGrow>true</CanGrow>
        <KeepTogether>true</KeepTogether>
        <Paragraphs>
          <Paragraph>
            <TextRuns>
              <TextRun>
                <Value xml:space="preserve"> </Value>
                <Style>
                  <FontSize>14pt</FontSize>
                  <Color>White</Color>
                </Style>
              </TextRun>
              <TextRun>
                <Value xml:space="preserve"> </Value>
                <ActionInfo>
                  <Actions>
                    <Action>
                      <Drillthrough>
                        <ReportName>=IIF(First(Fields!ProductMajorVersion.Value, "Version") = 10 and First(Fields!EngineEdition.Value, "ServerProperty") &lt;&gt; 5, "MainReport2008", 
IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing, 
IIF(First(Fields!ProductMajorVersion.Value, "Version") &gt; 10 and First(Fields!EngineEdition.Value, "ServerProperty") &lt;&gt; 5, "MainReport", Nothing)))</ReportName>
                      </Drillthrough>
                    </Action>
                  </Actions>
                </ActionInfo>
                <Style>
                  <FontSize>14pt</FontSize>
                  <Color>White</Color>
                </Style>
              </TextRun>
              <TextRun>
                <Value>Go To Main Report</Value>
                <ActionInfo>
                  <Actions>
                    <Action>
                      <Drillthrough>
                        <ReportName>=IIF(First(Fields!ProductMajorVersion.Value, "Version") = 10 and First(Fields!EngineEdition.Value, "ServerProperty") &lt;&gt; 5, "MainReport2008", 
IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing, 
IIF(First(Fields!ProductMajorVersion.Value, "Version") &gt; 10 and First(Fields!EngineEdition.Value, "ServerProperty") &lt;&gt; 5, "MainReport", Nothing)))</ReportName>
                      </Drillthrough>
                    </Action>
                  </Actions>
                </ActionInfo>
                <Style>
                  <FontSize>14pt</FontSize>
                  <Color>=IIF(First(Fields!ProductMajorVersion.Value, "Version") = 10, "WHITE", IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Darkblue", "White"))</Color>
                </Style>
              </TextRun>
            </TextRuns>
            <Style>
              <TextAlign>Left</TextAlign>
            </Style>
          </Paragraph>
        </Paragraphs>
        <rd:DefaultName>Textbox117</rd:DefaultName>
        <Top>0.11056in</Top>
        <Left>0.09126in</Left>
        <Height>0.65388in</Height>
        <Width>3.69499in</Width>
        <ZIndex>2</ZIndex>
        <Style>
          <Border>
            <Style>None</Style>
          </Border>
          <BackgroundColor>DarkBlue</BackgroundColor>
          <VerticalAlign>Middle</VerticalAlign>
          <PaddingLeft>2pt</PaddingLeft>
          <PaddingRight>2pt</PaddingRight>
          <PaddingTop>2pt</PaddingTop>
          <PaddingBottom>2pt</PaddingBottom>
        </Style>
      </Textbox>
      <Line Name="Line1">
        <Top>0.35222in</Top>
        <Left>3.61624in</Left>
        <Height>0.28333in</Height>
        <Width>0in</Width>
        <ZIndex>3</ZIndex>
        <Style>
          <Border>
            <Color>Teal</Color>
            <Style>Solid</Style>
          </Border>
        </Style>
      </Line>
      <Line Name="Line2">
        <Top>0.35222in</Top>
        <Left>10.44125in</Left>
        <Height>0.28333in</Height>
        <Width>0in</Width>
        <ZIndex>4</ZIndex>
        <Style>
          <Border>
            <Color>Green</Color>
            <Style>Solid</Style>
          </Border>
        </Style>
      </Line>
      <Textbox Name="Textbox3">
        <CanGrow>true</CanGrow>
        <KeepTogether>true</KeepTogether>
        <Paragraphs>
          <Paragraph>
            <TextRuns>
              <TextRun>
                <Value>="Server Name: " &amp; UCASE(First(Fields!ServerName.Value, "ServerName")) &amp; "    Current Database: " &amp; UCASE(First(Fields!DatabaseName.Value, "DatabaseName"))</Value>
                <Style>
                  <FontSize>16pt</FontSize>
                  <Color>DarkBlue</Color>
                </Style>
              </TextRun>
            </TextRuns>
            <Style>
              <TextAlign>Center</TextAlign>
            </Style>
          </Paragraph>
        </Paragraphs>
        <rd:DefaultName>Textbox3</rd:DefaultName>
        <Top>0.82in</Top>
        <Left>0.09126in</Left>
        <Height>0.33222in</Height>
        <Width>15.14708in</Width>
        <ZIndex>5</ZIndex>
        <Style>
          <Border>
            <Style>Solid</Style>
          </Border>
          <BackgroundColor>LightSteelBlue</BackgroundColor>
          <VerticalAlign>Middle</VerticalAlign>
          <PaddingLeft>2pt</PaddingLeft>
          <PaddingRight>2pt</PaddingRight>
          <PaddingTop>2pt</PaddingTop>
          <PaddingBottom>2pt</PaddingBottom>
        </Style>
      </Textbox>
      <Rectangle Name="Rectangle1">
        <ReportItems>
          <Tablix Name="Tablix4">
            <TablixBody>
              <TablixColumns>
                <TablixColumn>
                  <Width>3.52166in</Width>
                </TablixColumn>
              </TablixColumns>
              <TablixRows>
                <TablixRow>
                  <Height>0.26667in</Height>
                  <TablixCells>
                    <TablixCell>
                      <CellContents>
                        <Textbox Name="Textbox28">
                          <CanGrow>true</CanGrow>
                          <KeepTogether>true</KeepTogether>
                          <Paragraphs>
                            <Paragraph>
                              <TextRuns>
                                <TextRun>
                                  <Value>Database Information Reports</Value>
                                  <Style>
                                    <FontSize>14pt</FontSize>
                                    <Color>White</Color>
                                  </Style>
                                </TextRun>
                              </TextRuns>
                              <Style>
                                <TextAlign>Center</TextAlign>
                              </Style>
                            </Paragraph>
                          </Paragraphs>
                          <rd:DefaultName>Textbox28</rd:DefaultName>
                          <Style>
                            <Border>
                              <Color>LightGrey</Color>
                              <Style>Solid</Style>
                            </Border>
                            <BackgroundColor>DarkBlue</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.35889in</Height>
                  <TablixCells>
                    <TablixCell>
                      <CellContents>
                        <Textbox Name="MenuItem3">
                          <CanGrow>true</CanGrow>
                          <KeepTogether>true</KeepTogether>
                          <Paragraphs>
                            <Paragraph>
                              <TextRuns>
                                <TextRun>
                                  <Value>=Switch(
 Fields!MenuItem.Value = "Azure Database Resource Stats" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure Database Resource Stats","Only Works in Azure DB")
, Fields!MenuItem.Value = "CDC and Change Tracking Status" ,"CDC and Change Tracking Status"
, Fields!MenuItem.Value = "CDC Tables" ,"CDC Tables"
, Fields!MenuItem.Value = "Change Tracking Tables (D)" ,"Change Tracking Tables (D)"
, Fields!MenuItem.Value = "CheckDB Status" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","CheckDB Status *")
, Fields!MenuItem.Value = "Column List for Current Databases  (D)" ,"Column List for Current Databases  (D)"
, Fields!MenuItem.Value = "Columns with BLOB data types" ,"Columns with BLOB Data Types  (D)"
, Fields!MenuItem.Value = "Column Store Index Information" ,IIF(First(Fields!ProductMajorVersion.Value, "Version") &lt; 14 , "Old Version - Column Store","Column Store Index Information")
, Fields!MenuItem.Value = "Compressed Objects   (D)" ,"Compressed Objects   (D)"
, Fields!MenuItem.Value = "Computed Columns in Database (D)" ,"Computed Columns in Database (D)"
, Fields!MenuItem.Value = "Contained Database Information" ,IIF(First(Fields!ProductMajorVersion.Value, "Version") &lt; 11 or First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Old Version - Contained Database","Contained Database Information")
, Fields!MenuItem.Value = "Contained Database Users" ,IIF(First(Fields!ProductMajorVersion.Value, "Version") &lt; 11 or First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Old Version - Contained DB Users","Contained Database Users")
, Fields!MenuItem.Value = "Database Auto Settings" , "Database Auto Settings *"
, Fields!MenuItem.Value = "Database Autotune Settings" ,IIF(First(Fields!ProductMajorVersion.Value, "Version") &lt; 14 and First(Fields!EngineEdition.Value, "ServerProperty") &lt;&gt; 5, "Old Version - Database Autotune","Database Autotune Settings *")
, Fields!MenuItem.Value = "Database File Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA",IIF(First(Fields!ProductMajorVersion.Value, "Version") &lt; 10, "Old Version - Database File Info", "Database File Information *"))
, Fields!MenuItem.Value = "Database Filegroup Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Database Filegroup Information")
, Fields!MenuItem.Value = "Database Functions   (D)" ,"Database Functions   (D)"
, Fields!MenuItem.Value = "Database Information(Stats Settings\Compat Level)" ,"Database Information(Stats Settings\Compat Level) *"
, Fields!MenuItem.Value = "Database Settings" ,"Database Settings"
, Fields!MenuItem.Value = "Database Snapshot Information" ,"Database Snapshot Information"
, Fields!MenuItem.Value = "Database Triggers   (D)" ,"Database Triggers   (D)"
, Fields!MenuItem.Value = "Database Virtual Log Files" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Database Virtual Log Files *")
, Fields!MenuItem.Value = "Databases Not in Offline\Online State" ,"Database State - All Databases"
, Fields!MenuItem.Value = "Default Constraint Info.  (D)" ,"Default Constraint Info.  (D)"
, Fields!MenuItem.Value = "Duplicate Indexes" ,"Duplicate Indexes  (D) *"
, Fields!MenuItem.Value = "Dynamic Masked Columns" ,IIF(First(Fields!ProductMajorVersion.Value, "Version") &lt; 13 and First(Fields!EngineEdition.Value, "ServerProperty") &lt;&gt; 5, "Old Version - Dynamic Mask","Dynamic Masked Columns")
, Fields!MenuItem.Value = "Database File Size\Space Used" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Database File Size\Space Used")
, Fields!MenuItem.Value = "Forwarded Records   (D)" ,"Forwarded Records   (D)"
, Fields!MenuItem.Value = "Full Text Index Info.  (D)" ,"Full Text Index Info.  (D)"
, Fields!MenuItem.Value = "Index Fragmentation   (D)" ,"Index Fragmentation   (D) *"
, Fields!MenuItem.Value = "Index Fragmentation for an Object   (D)" ,"Index Fragmentation for an Object   (D)"
, Fields!MenuItem.Value = "Index Information  (D)" ,"Index Information  (D) *"
, Fields!MenuItem.Value = "Index To Column Ratio by Table  (D)" ,"Index To Column Ratio by Table  (D)"
, Fields!MenuItem.Value = "Index Usage" ,"Index Usage"
, Fields!MenuItem.Value = "Indexes that Are Unused" ,"Indexes that Are Unused"
, Fields!MenuItem.Value = "Memory Optimized Tables" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA",IIF(First(Fields!ProductMajorVersion.Value, "Version") &lt; 13, "Old Version - Mem. Optimzed Tables","Memory Optimized Tables"))
, Fields!MenuItem.Value = "Nonsargable Searches in Stored Procs" ,"Nonsargable Searches in Stored Procs"
, Fields!MenuItem.Value = "Objects with Schemabinding" ,"Objects with Schemabinding"
, Fields!MenuItem.Value = "Orphan Database Users" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Orphan Database Users   (D)")
, Fields!MenuItem.Value = "Plan Guides" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Plan Guides *")
, Fields!MenuItem.Value = "Plans with Implicit Converts" ,"Plans with Implicit Converts *"
, Fields!MenuItem.Value = "Partitioned Tables" ,"Partitioned Tables"
, Fields!MenuItem.Value = "Stored Procedures that start with SP_" ,"Stored Procedures that start with SP_ *"
, Fields!MenuItem.Value = "Stored Procs with a SELECT *" ,"Stored Procedures that use SELECT *"
, Fields!MenuItem.Value = "Stored Procs with a CURSOR" ,"Stored Procedures that have a CURSOR"
, Fields!MenuItem.Value = "Stored Procs with Deadlock Priority Set" ,"Stored Procs with Deadlock Priority Set"
, Fields!MenuItem.Value = "Stored Procs with NOCOUNT set to OFF" ,"Stored Procs with NOCOUNT set to OFF"
, Fields!MenuItem.Value = "Temporal Table Information" ,IIF(First(Fields!ProductMajorVersion.Value, "Version") &lt;= 13, "Old Version - Temporal Tables","Temporal Table Information")
, Fields!MenuItem.Value = "Stretch Database Information" ,IIF(First(Fields!ProductMajorVersion.Value, "Version") &lt;= 12, "Old Version - Stretch DB","Stretch Database Information")
, Fields!MenuItem.Value = "Queries with High Logical Reads  (D)" ,"Queries with High Logical Reads  (D) *"
, Fields!MenuItem.Value = "Queries with High Physical Reads  (D)" ,"Queries with High Physical Reads  (D) *"
, Fields!MenuItem.Value = "Query Store Status and Settings" ,IIF(First(Fields!ProductMajorVersion.Value, "Version") &lt;= 12, "Old Version - Query Store","Query Store Status and Settings")
, Fields!MenuItem.Value = "Statistics Information  (D)" ,IIF(Sum(Fields!VersionOfSQLServer.Value, "Version") &lt;= 11, "Old Version - Statistics Info", "Statistics Information  (D)")
, Fields!MenuItem.Value = "Stored Procs Created or Modified Last 90 Days  (D)" ,"Stored Procs Created or Modified Last 90 Days  (D)"
, Fields!MenuItem.Value = "Stored Procs with Recompile" ,"Stored Procs with Recompile  (D)"
, Fields!MenuItem.Value = "Synonym Information  (D)" ,"Synonym Information  (D)"
, Fields!MenuItem.Value = "Table Row Counts and Size  (D)" ,"Table Row Counts and Size  (D)"
, Fields!MenuItem.Value = "Tables Created or Modified Last 90 Days  (D)" ,"Tables Created or Modified Last 90 Days  (D)"
, Fields!MenuItem.Value = "Tables That are Heaps   (D)" ,"Tables That are Heaps   (D)"
, Fields!MenuItem.Value = "TempDB  Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","TempDB  Information *")
, Fields!MenuItem.Value = "User Defined Data Types   (D)" ,"User Defined Data Types   (D)"
, Fields!MenuItem.Value = "User Defined Data Type Usage  (D)" ,"User Defined Data Type Usage  (D)"
, Fields!MenuItem.Value = "Views Created or Modified Last 90 Days   (D)" ,"Views Created or Modified Last 90 Days (D)"
, Fields!MenuItem.Value = "Databases Using the Version Store" ,"Databases Using the Version Store"
, Fields!MenuItem.Value = "StoredProcList" ,"Stored Procedure List"
, Fields!MenuItem.Value = "View List" ,"View List"
, Fields!MenuItem.Value = "Table List" ,"Table List"
, Fields!MenuItem.Value = "Databases Deleted" ,"Databases Deleted"
, Fields!MenuItem.Value = "DBCC Command Progress" ,"DBCC Command Progress"
, Fields!MenuItem.Value = "DatabaseObjectsChanged" ,"Database Object Charges"
, Fields!MenuItem.Value = "Database File Growth Settings" ,"Database File Growth Settings"
, Fields!MenuItem.Value = "Database File Growths" ,IIF(Sum(Fields!Default.Value, "DefaultTraceEnabled") &gt; 0,"Database File Growths(Trace)", "Database File Growths - Default Trace Must Be Enabled")
, Fields!MenuItem.Value = "Database File GrowthsEE" ,IIF(Sum(Fields!SessionExists.Value, "FileGrowthExtendedEventSessionExists") &gt; 0,"Database File Growths(Extended Events)", "Database File Growths - Extended Event Session Does not Exist")
)</Value>
                                  <Style>
                                    <FontSize>14pt</FontSize>
                                    <Color>=Switch(
 Fields!MenuItem.Value = "Azure Database Resource Stats" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") &lt;&gt; 5, "DarkGray","Black")
, Fields!MenuItem.Value = "CDC and Change Tracking Status" ,"Black"
, Fields!MenuItem.Value = "CDC Tables" ,"Black"
, Fields!MenuItem.Value = "Change Tracking Tables (D)" ,"Black"
, Fields!MenuItem.Value = "CheckDB Status" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray","Black")
, Fields!MenuItem.Value = "Column List for Current Databases  (D)" ,"Black"
, Fields!MenuItem.Value = "Columns with BLOB data types" ,"Black"
, Fields!MenuItem.Value = "Column Store Index Information" ,IIF(First(Fields!ProductMajorVersion.Value, "Version") &lt; 14 , "DarkGray","Black")
, Fields!MenuItem.Value = "Compressed Objects   (D)" ,"Black"
, Fields!MenuItem.Value = "Computed Columns in Database (D)" ,"Black"
, Fields!MenuItem.Value = "Contained Database Information" ,IIF(First(Fields!ProductMajorVersion.Value, "Version") &lt; 11 or First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray","Black")
, Fields!MenuItem.Value = "Contained Database Users" ,IIF(First(Fields!ProductMajorVersion.Value, "Version") &lt; 11 or First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray","Black")
, Fields!MenuItem.Value = "Database Auto Settings" ,"Black"
, Fields!MenuItem.Value = "Database Autotune Settings" ,IIF(First(Fields!ProductMajorVersion.Value, "Version") &lt; 14 and First(Fields!EngineEdition.Value, "ServerProperty") &lt;&gt; 5, "DarkGray","Black")
, Fields!MenuItem.Value = "Database File Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray","Black")
, Fields!MenuItem.Value = "Database Filegroup Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray","Black")
, Fields!MenuItem.Value = "Database Functions   (D)" ,"Black"
, Fields!MenuItem.Value = "Database Information(Stats Settings\Compat Level)" ,"Black"
, Fields!MenuItem.Value = "Database Settings" ,"Black"
, Fields!MenuItem.Value = "Database Snapshot Information" ,"Black"
, Fields!MenuItem.Value = "Database Triggers   (D)" ,"Black"
, Fields!MenuItem.Value = "Database Virtual Log Files" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray","Black")
, Fields!MenuItem.Value = "Databases Not in Offline\Online State" ,"Black"
, Fields!MenuItem.Value = "Default Constraint Info.  (D)" ,"Black"
, Fields!MenuItem.Value = "Duplicate Indexes" ,"Black"
, Fields!MenuItem.Value = "Dynamic Masked Columns" ,IIF(First(Fields!ProductMajorVersion.Value, "Version") &lt; 13 and First(Fields!EngineEdition.Value, "ServerProperty") &lt;&gt; 5, "DarkGray","Black")
, Fields!MenuItem.Value = "File Size\Space Used" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray","Black")
, Fields!MenuItem.Value = "Forwarded Records   (D)" ,"Black"
, Fields!MenuItem.Value = "Full Text Index Info.  (D)" ,"Black"
, Fields!MenuItem.Value = "Index Fragmentation   (D)" ,"Black"
, Fields!MenuItem.Value = "Index Fragmentation for an Object   (D)" ,"Black"
, Fields!MenuItem.Value = "Index Information  (D)" ,"Black"
, Fields!MenuItem.Value = "Index Usage" ,"Black"
, Fields!MenuItem.Value = "Indexes that Are Unused" ,"Black"
, Fields!MenuItem.Value = "Index To Column Ratio by Table  (D)" ,"Black"
, Fields!MenuItem.Value = "Memory Optimized Tables" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray",IIF(First(Fields!ProductMajorVersion.Value, "Version") &lt; 13, "DarkGray","Black"))
, Fields!MenuItem.Value = "Nonsargable Searches in Stored Procs" ,"Black"
, Fields!MenuItem.Value = "Objects with Schemabinding" ,"Black"
, Fields!MenuItem.Value = "Orphan Database Users" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray","Black")
, Fields!MenuItem.Value = "Partitioned Tables" ,"Black"
, Fields!MenuItem.Value = "Plan Guides" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray","Black")
, Fields!MenuItem.Value = "Plans with Implicit Converts" ,"Black"
, Fields!MenuItem.Value = "Queries with High Logical Reads  (D)" ,"Black"
, Fields!MenuItem.Value = "Query Store Status and Settings" ,IIF(First(Fields!ProductMajorVersion.Value, "Version") &lt;= 12, "DarkGray","Black")
, Fields!MenuItem.Value = "Statistics Information  (D)" ,IIF(First(Fields!ProductMajorVersion.Value, "Version") &lt;  10, "DarkGray", "Black")
, Fields!MenuItem.Value = "Stored Procs Created or Modified Last 90 Days  (D)" ,"Black"
, Fields!MenuItem.Value = "Stored Procs with NOCOUNT set to OFF" ,"Black"
, Fields!MenuItem.Value = "Stored Procs with Recompile" ,"Black"
, Fields!MenuItem.Value = "Stored Procs with a SELECT *" ,"Black"
, Fields!MenuItem.Value = "Stored Procs with a CURSOR" ,"Black"
, Fields!MenuItem.Value = "Stored Procs with Deadlock Priority Set" ,"Black"
, Fields!MenuItem.Value = "Stored Procedures that start with SP_" ,"Black"
, Fields!MenuItem.Value = "Stretch Database Information" ,IIF(First(Fields!ProductMajorVersion.Value, "Version") &lt;= 13, "DarkGray","Black")
, Fields!MenuItem.Value = "Synonym Information  (D)" ,"Black"
, Fields!MenuItem.Value = "Table Row Counts and Size  (D)" ,"Black"
, Fields!MenuItem.Value = "Tables Created or Modified Last 90 Days  (D)" ,"Black"
, Fields!MenuItem.Value = "Tables That are Heaps   (D)" ,"Black"
, Fields!MenuItem.Value = "TempDB  Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray","Black")
, Fields!MenuItem.Value = "Temporal Table Information" ,IIF(First(Fields!ProductMajorVersion.Value, "Version") &lt;= 12, "DarkGray","Black")
, Fields!MenuItem.Value = "User Defined Data Types   (D)" ,"Black"
, Fields!MenuItem.Value = "User Defined Data Type Usage  (D)" ,"Black"
, Fields!MenuItem.Value = "Views Created or Modified Last 90 Days   (D)" ,"Black"
, Fields!MenuItem.Value = "Database File Growths" ,IIF(Sum(Fields!Default.Value, "DefaultTraceEnabled") &gt; 0,"Black", "DarkGray")
, Fields!MenuItem.Value = "Database File GrowthsEE" ,IIF(Sum(Fields!SessionExists.Value, "FileGrowthExtendedEventSessionExists") &gt; 0,"Black", "DarkGray")
)</Color>
                                  </Style>
                                </TextRun>
                              </TextRuns>
                              <Style />
                            </Paragraph>
                          </Paragraphs>
                          <rd:DefaultName>MenuItem3</rd:DefaultName>
                          <ActionInfo>
                            <Actions>
                              <Action>
                                <Drillthrough>
                                  <ReportName>=Switch(
  Fields!MenuItem.Value = "Azure Database Resource Stats" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "AzureDBResourceStats",Nothing)
, Fields!MenuItem.Value = "CDC and Change Tracking Status" ,"DatabaseCDCChangeTracking"
, Fields!MenuItem.Value = "CDC Tables" ,"CDCEnabledTables"
, Fields!MenuItem.Value = "Change Tracking Tables (D)" ,"ChangeTrackingTables"
, Fields!MenuItem.Value = "CheckDB Status" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,"CheckDBStatus")
, Fields!MenuItem.Value = "Column List for Current Databases  (D)" ,"ColumnList"
, Fields!MenuItem.Value = "Column Store Index Information" ,IIF(First(Fields!ProductMajorVersion.Value, "Version") &lt; 14 , Nothing,"ColumnStoreIndexes")
, Fields!MenuItem.Value = "Compressed Objects   (D)" ,"CompressedObjects"
, Fields!MenuItem.Value = "Computed Columns in Database (D)" ,"ComputedColumnsInDB"
, Fields!MenuItem.Value = "Columns with BLOB data types" ,"ColumnsWithBLOBDataType"
, Fields!MenuItem.Value = "Contained Database Information" ,IIF(First(Fields!ProductMajorVersion.Value, "Version") &lt; 11 or First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,"ContainedDatabases")
, Fields!MenuItem.Value = "Contained Database Users" ,IIF(First(Fields!ProductMajorVersion.Value, "Version") &lt; 11 or First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,"ContainedDatabaseUsers")
, Fields!MenuItem.Value = "Database Auto Settings" ,"DatabaseAutoSettings"
, Fields!MenuItem.Value = "Database Autotune Settings" ,IIF(First(Fields!ProductMajorVersion.Value, "Version") &lt; 14 and First(Fields!EngineEdition.Value, "ServerProperty") &lt;&gt; 5, Nothing,"AutoTuningOptions")
, Fields!MenuItem.Value = "Database File Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,"DatabaseFileInfo")
, Fields!MenuItem.Value = "Database Filegroup Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,"FilegroupInformation")
, Fields!MenuItem.Value = "Database Functions   (D)" ,"DatabaseFunctions"
, Fields!MenuItem.Value = "Database Information(Stats Settings\Compat Level)" ,"DatabaseInformation"
, Fields!MenuItem.Value = "Database Settings" ,"DatabaseSettings"
, Fields!MenuItem.Value = "Database Snapshot Information" ,"DatabaseSnapshotInformation"
, Fields!MenuItem.Value = "Database Triggers   (D)" ,"DatabaseTriggers"
, Fields!MenuItem.Value = "Database Virtual Log Files" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,"DatabaseVirtualLogFile")
, Fields!MenuItem.Value = "Databases Not in Offline\Online State" ,"ProblemDatabases"
, Fields!MenuItem.Value = "Default Constraint Info.  (D)" ,"DatabaseDefaultInformation"
, Fields!MenuItem.Value = "Duplicate Indexes" ,"DuplicateIndexes"
, Fields!MenuItem.Value = "Dynamic Masked Columns" ,IIF(First(Fields!ProductMajorVersion.Value, "Version") &lt; 13 and First(Fields!EngineEdition.Value, "ServerProperty") &lt;&gt; 5, Nothing,"DynamicMaskedColumns")
, Fields!MenuItem.Value = "Database File Size\Space Used" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,"DatabaseSizeInfo")
, Fields!MenuItem.Value = "Forwarded Records   (D)" ,"ForwardedRecordsYesNo"
, Fields!MenuItem.Value = "Full Text Index Info.  (D)" ,"FullTextIndexInformation"
, Fields!MenuItem.Value = "Index Fragmentation   (D)" ,"IndexFragementationYesNo"
, Fields!MenuItem.Value = "Index Fragmentation for an Object   (D)" ,"IndexFragmentationForAnObject"
, Fields!MenuItem.Value = "Index Information  (D)" ,"IndexInformation"
, Fields!MenuItem.Value = "Index To Column Ratio by Table  (D)" ,"IndexToColumnRatio"
, Fields!MenuItem.Value = "Index Usage" ,"IndexUsage"
, Fields!MenuItem.Value = "Indexes that Are Unused" ,"IndexThatAreUnused"
, Fields!MenuItem.Value = "Memory Optimized Tables" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,IIF(First(Fields!ProductMajorVersion.Value, "Version") &lt; 13, Nothing,"MemoryOptimizedTables"))
, Fields!MenuItem.Value = "Nonsargable Searches in Stored Procs" ,"NonSargAbleStoredProcs"
, Fields!MenuItem.Value = "Objects with Schemabinding" ,"ObjectsWithSchemabinding"
, Fields!MenuItem.Value = "Orphan Database Users" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,"OrphanedDBUsrs")
, Fields!MenuItem.Value = "Plan Guides" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,"PlanGuide")
, Fields!MenuItem.Value = "Plans with Implicit Converts" ,"ImplicitConvertsYesNo"
, Fields!MenuItem.Value = "Partitioned Tables" ,"PartitionedTables"
, Fields!MenuItem.Value = "Stored Procedures that start with SP_" ,"ProceduresThatStartWithSP_"
, Fields!MenuItem.Value = "Stored Procs with Deadlock Priority Set" ,"StoredProceduresWithDeadlockPriority"
, Fields!MenuItem.Value = "Stored Procs with a SELECT *" ,"StoredProcsWithSelectAst"
, Fields!MenuItem.Value = "Queries with High Logical Reads  (D)" ,"QueriesWithHighReads"
, Fields!MenuItem.Value = "Queries with High Physical Reads  (D)" ,"QueriesWithPhysicalHighReads"
, Fields!MenuItem.Value = "Query Store Status and Settings" ,IIF(First(Fields!ProductMajorVersion.Value, "Version") &lt;= 12, Nothing,"QueryStoreStatus")
, Fields!MenuItem.Value = "Statistics Information  (D)" ,IIF(First(Fields!ProductMajorVersion.Value, "Version") &lt; 10, Nothing, "StatsModificationCountsYesNo")
, Fields!MenuItem.Value = "Stored Procs Created or Modified Last 90 Days  (D)" ,"StoredProcsCreatedModifiedPast7Days"
, Fields!MenuItem.Value = "Stored Procs with NOCOUNT set to OFF" ,"StoredProceduresWithoutNOCOUNT"
, Fields!MenuItem.Value = "Stored Procs with Recompile" ,"StoredProcsWithRecompile"
, Fields!MenuItem.Value = "Stored Procs with a CURSOR" ,"StoredProcsWithCursor"
, Fields!MenuItem.Value = "Synonym Information  (D)" ,"DatabaseSynonyms"
, Fields!MenuItem.Value = "Stretch Database Information" ,IIF(First(Fields!ProductMajorVersion.Value, "Version") &lt;= 13, Nothing,"StretchTableInformation")
, Fields!MenuItem.Value = "Table Row Counts and Size  (D)" ,"TableRowCountsAndSize"
, Fields!MenuItem.Value = "Tables Created or Modified Last 90 Days  (D)" ,"TablesCreatedModifiedInPast7Days"
, Fields!MenuItem.Value = "Tables That are Heaps   (D)" ,"TablesThatAreHeaps"
, Fields!MenuItem.Value = "TempDB  Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,"TempDBInformation")
, Fields!MenuItem.Value = "Temporal Table Information" ,IIF(First(Fields!ProductMajorVersion.Value, "Version") &lt;= 12, Nothing,"TemporalTableInformation")
, Fields!MenuItem.Value = "User Defined Data Types   (D)" ,"DatabaseUserDefinedDataTypes"
, Fields!MenuItem.Value = "User Defined Data Type Usage  (D)" ,"DatabaseUserDefDataTypeUsage"
, Fields!MenuItem.Value = "Views Created or Modified Last 90 Days   (D)" ,"ViewsCreatedOrModifiedPast7Days"
, Fields!MenuItem.Value = "StoredProcList" ,"StoredProcedureList"
, Fields!MenuItem.Value = "View List" ,"ViewList"
, Fields!MenuItem.Value = "Table List" ,"TableList"
, Fields!MenuItem.Value = "Databases Using the Version Store" ,"VersionStoreWhatDatabaseIsUsingIt"
, Fields!MenuItem.Value = "Databases Deleted" ,"DeletedDatabases"
, Fields!MenuItem.Value = "Database File Growth Settings" ,"FileGrowthSettings"
, Fields!MenuItem.Value = "DatabaseObjectsChanged" ,"ObjectsChangedTimePicker"
, Fields!MenuItem.Value = "DBCC Command Progress" ,"DBCCStatementProgress"
, Fields!MenuItem.Value = "Database File Growths" ,IIF(Sum(Fields!Default.Value, "DefaultTraceEnabled") &gt; 0,"DatabaseFileGrowths", NOthing)
, Fields!MenuItem.Value = "Database File GrowthsEE" ,IIF(Sum(Fields!SessionExists.Value, "FileGrowthExtendedEventSessionExists") &gt; 0,"DatabaseGrowthEE", "DatabaseFileGrowthEEDitrections")
)</ReportName>
                                </Drillthrough>
                              </Action>
                            </Actions>
                          </ActionInfo>
                          <ToolTip>=Switch(
 Fields!MenuItem.Value = "Database File GrowthsEE" ,IIF(Sum(Fields!SessionExists.Value, "FileGrowthExtendedEventSessionExists") &gt; 0,Nothing, "Click to See Direstions to Install Extended Events session")
)</ToolTip>
                          <Style>
                            <Border>
                              <Color>LightGrey</Color>
                              <Style>Solid</Style>
                            </Border>
                            <BackgroundColor>=IIF(ROWNUMBER(NOTHING) MOD 2, "LIGHTBLUE", "SILVER")</BackgroundColor>
                            <VerticalAlign>Middle</VerticalAlign>
                            <PaddingLeft>4pt</PaddingLeft>
                            <PaddingRight>2pt</PaddingRight>
                            <PaddingTop>2pt</PaddingTop>
                            <PaddingBottom>2pt</PaddingBottom>
                          </Style>
                        </Textbox>
                      </CellContents>
                    </TablixCell>
                  </TablixCells>
                </TablixRow>
                <TablixRow>
                  <Height>1.73in</Height>
                  <TablixCells>
                    <TablixCell>
                      <CellContents>
                        <Textbox Name="Textbox58">
                          <CanGrow>true</CanGrow>
                          <KeepTogether>true</KeepTogether>
                          <Paragraphs>
                            <Paragraph>
                              <TextRuns>
                                <TextRun>
                                  <Value>Much of the code in the reports are based on Microsoft documentation.  For the queries that  I obtained elsewhere, I tried to give proper credit. Please let me know if you find I missed doing so. </Value>
                                  <Style>
                                    <FontSize>14pt</FontSize>
                                    <Color>White</Color>
                                  </Style>
                                </TextRun>
                              </TextRuns>
                              <Style>
                                <TextAlign>Center</TextAlign>
                              </Style>
                            </Paragraph>
                          </Paragraphs>
                          <rd:DefaultName>Textbox58</rd:DefaultName>
                          <Style>
                            <Border>
                              <Color>LightGrey</Color>
                              <Style>Solid</Style>
                            </Border>
                            <BackgroundColor>DarkBlue</BackgroundColor>
                            <VerticalAlign>Middle</VerticalAlign>
                            <PaddingLeft>4pt</PaddingLeft>
                            <PaddingRight>2pt</PaddingRight>
                            <PaddingTop>2pt</PaddingTop>
                            <PaddingBottom>2pt</PaddingBottom>
                          </Style>
                        </Textbox>
                      </CellContents>
                    </TablixCell>
                  </TablixCells>
                </TablixRow>
              </TablixRows>
            </TablixBody>
            <TablixColumnHierarchy>
              <TablixMembers>
                <TablixMember />
              </TablixMembers>
            </TablixColumnHierarchy>
            <TablixRowHierarchy>
              <TablixMembers>
                <TablixMember>
                  <KeepWithGroup>After</KeepWithGroup>
                </TablixMember>
                <TablixMember>
                  <Group Name="Details3" />
                </TablixMember>
                <TablixMember>
                  <KeepWithGroup>Before</KeepWithGroup>
                </TablixMember>
              </TablixMembers>
            </TablixRowHierarchy>
            <DataSetName>DatabaseInformation</DataSetName>
            <SortExpressions>
              <SortExpression>
                <Value>=Fields!MenuItem.Value</Value>
              </SortExpression>
            </SortExpressions>
            <Top>0.02778in</Top>
            <Left>0.07263in</Left>
            <Height>2.35556in</Height>
            <Width>3.52166in</Width>
            <Style>
              <Border>
                <Style>Solid</Style>
              </Border>
            </Style>
          </Tablix>
        </ReportItems>
        <KeepTogether>true</KeepTogether>
        <Top>1.56166in</Top>
        <Left>3.81403in</Left>
        <Height>2.38334in</Height>
        <Width>3.59429in</Width>
        <ZIndex>6</ZIndex>
        <Style>
          <Border>
            <Style>None</Style>
          </Border>
        </Style>
      </Rectangle>
      <Rectangle Name="Rectangle2">
        <ReportItems>
          <Tablix Name="Tablix1">
            <TablixBody>
              <TablixColumns>
                <TablixColumn>
                  <Width>3.75373in</Width>
                </TablixColumn>
              </TablixColumns>
              <TablixRows>
                <TablixRow>
                  <Height>0.27333in</Height>
                  <TablixCells>
                    <TablixCell>
                      <CellContents>
                        <Textbox Name="Textbox7">
                          <CanGrow>true</CanGrow>
                          <KeepTogether>true</KeepTogether>
                          <Paragraphs>
                            <Paragraph>
                              <TextRuns>
                                <TextRun>
                                  <Value>Current State Reports</Value>
                                  <Style>
                                    <FontSize>14pt</FontSize>
                                    <Color>White</Color>
                                  </Style>
                                </TextRun>
                              </TextRuns>
                              <Style>
                                <TextAlign>Center</TextAlign>
                              </Style>
                            </Paragraph>
                          </Paragraphs>
                          <rd:DefaultName>Textbox7</rd:DefaultName>
                          <Style>
                            <Border>
                              <Color>LightGrey</Color>
                              <Style>Solid</Style>
                            </Border>
                            <BackgroundColor>DarkBlue</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.35889in</Height>
                  <TablixCells>
                    <TablixCell>
                      <CellContents>
                        <Textbox Name="MenuItem">
                          <CanGrow>true</CanGrow>
                          <KeepTogether>true</KeepTogether>
                          <Paragraphs>
                            <Paragraph>
                              <TextRuns>
                                <TextRun>
                                  <Value>=Switch(
  Fields!MenuItem.Value = "Any Running Jobs" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Any Currently Executing Jobs? *")
, Fields!MenuItem.Value = "CPU Utilization" ,"What is current CPU Utilization? *"
, Fields!MenuItem.Value = "Open Transactions" ,IIF(Sum(Fields!VersionOfSQLServer.Value, "Version") &lt; 10, "Old Version - Open Transactions", "Are there any open transactions? *")
, Fields!MenuItem.Value = "Processes" ,IIF(Sum(Fields!VersionOfSQLServer.Value, "Version") &lt;= 9, "Old Version - Processes", "View Current Processes *")
, Fields!MenuItem.Value = "Read Write Latency" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Any Read\Write Latency issues? *")
, Fields!MenuItem.Value = "What is Using the TempDB with Code" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA",IIF(Sum(Fields!VersionOfSQLServer.Value, "Version") &lt;= 10, "Old Version - TempDB Usage", "What is Using the TempDB with Code? *"))
, Fields!MenuItem.Value = "Why is the Log Not Clearing" , "Why is the Log not Clearing? *"
, Fields!MenuItem.Value = "Target and Total Memory 5 Minutes" , "Target and Total Memory 30 Seconds *"
, Fields!MenuItem.Value = "Page Life Expectancy 5 Minutes" , "Page Life Expectancy 30 Seconds *"
, Fields!MenuItem.Value = "Lazy Writes\Sec 5 Minutes" , "Lazy Writes\Sec 30 Seconds *"
, Fields!MenuItem.Value = "Memory Grants Pending 5 Minutes" , "Memory Grants Pending 30 Seconds *"
, Fields!MenuItem.Value = "Checkpoint pages/sec 90 Seconds" , "Checkpoint pages/sec 30 Seconds *"
, Fields!MenuItem.Value = "Page Reads/sec 5 Minutes" , "Page Reads/sec 30 Seconds *"
, Fields!MenuItem.Value = "IOStalls" , "Database IO Stalls *"
)</Value>
                                  <Style>
                                    <FontSize>14pt</FontSize>
                                    <Color>=Switch(
  Fields!MenuItem.Value = "Any Running Jobs" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray","Black")
, Fields!MenuItem.Value = "CPU Utilization" ,"Black"
, Fields!MenuItem.Value = "Open Transactions" ,IIF(First(Fields!ProductMajorVersion.Value, "Version") &lt; 10, "DarkGray", "Black")
, Fields!MenuItem.Value = "Processes" ,IIF(First(Fields!ProductMajorVersion.Value, "Version") &lt;= 9, "DarkGray", "Black")
, Fields!MenuItem.Value = "Read Write Latency" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray","Black")
, Fields!MenuItem.Value = "Wait Information" ,"WaitInformation"
, Fields!MenuItem.Value = "What is Using the TempDB with Code" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray",IIF(First(Fields!ProductMajorVersion.Value, "Version") &lt;= 10, "DarkGray", "Black"))
, Fields!MenuItem.Value = "Why is the Log Not Clearing" ,"Black"
)</Color>
                                  </Style>
                                </TextRun>
                              </TextRuns>
                              <Style />
                            </Paragraph>
                          </Paragraphs>
                          <rd:DefaultName>MenuItem</rd:DefaultName>
                          <ActionInfo>
                            <Actions>
                              <Action>
                                <Drillthrough>
                                  <ReportName>=Switch(
  Fields!MenuItem.Value = "Any Running Jobs" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,"CurrentlyExecutingJobs")
, Fields!MenuItem.Value = "CPU Utilization" ,"CPULast7Days"
, Fields!MenuItem.Value = "Open Transactions" ,IIF(First(Fields!ProductMajorVersion.Value, "Version") &lt; 10, Nothing, "OpenTransactions")
, Fields!MenuItem.Value = "Processes" ,IIF(First(Fields!ProductMajorVersion.Value, "Version") &lt;= 9, Nothing, "ProcessesCheckForBlocking")
, Fields!MenuItem.Value = "Read Write Latency" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,"ReadWriteLatency")
, Fields!MenuItem.Value = "Wait Information" ,"WaitInformation"
, Fields!MenuItem.Value = "What is Using the TempDB with Code" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,IIF(First(Fields!ProductMajorVersion.Value, "Version") &lt;= 10, Nothing, "TempDBQueries"))
, Fields!MenuItem.Value = "Why is the Log Not Clearing" ,"WhyIsTLogNotClearing"
, Fields!MenuItem.Value = "Target and Total Memory 5 Minutes" ,"TargetTotalMemory5Min"
, Fields!MenuItem.Value = "Page Life Expectancy 5 Minutes" ,"PLE5Min"
, Fields!MenuItem.Value = "Lazy Writes\Sec 5 Minutes" ,"LazyWrites5Min"
, Fields!MenuItem.Value = "Memory Grants Pending 5 Minutes" ,"MemGrantsPending5Min"
, Fields!MenuItem.Value = "Checkpoint pages/sec 90 Seconds" ,"Checkpoints5Min"
, Fields!MenuItem.Value = "Page Reads/sec 5 Minutes" ,"PageReads5Min"
, Fields!MenuItem.Value = "IOStalls" ,"DatabaseIOStalls"
)</ReportName>
                                </Drillthrough>
                              </Action>
                            </Actions>
                          </ActionInfo>
                          <Style>
                            <Border>
                              <Color>LightGrey</Color>
                              <Style>Solid</Style>
                            </Border>
                            <BackgroundColor>=IIF(ROWNUMBER(NOTHING) MOD 2, "LIGHTBLUE", "SILVER")</BackgroundColor>
                            <VerticalAlign>Middle</VerticalAlign>
                            <PaddingLeft>4pt</PaddingLeft>
                            <PaddingRight>2pt</PaddingRight>
                            <PaddingTop>2pt</PaddingTop>
                            <PaddingBottom>2pt</PaddingBottom>
                          </Style>
                        </Textbox>
                      </CellContents>
                    </TablixCell>
                  </TablixCells>
                </TablixRow>
              </TablixRows>
            </TablixBody>
            <TablixColumnHierarchy>
              <TablixMembers>
                <TablixMember />
              </TablixMembers>
            </TablixColumnHierarchy>
            <TablixRowHierarchy>
              <TablixMembers>
                <TablixMember>
                  <KeepWithGroup>After</KeepWithGroup>
                </TablixMember>
                <TablixMember>
                  <Group Name="Details" />
                </TablixMember>
              </TablixMembers>
            </TablixRowHierarchy>
            <DataSetName>CurrentState</DataSetName>
            <Height>0.63222in</Height>
            <Width>3.75373in</Width>
            <Style>
              <Border>
                <Style>Solid</Style>
              </Border>
            </Style>
          </Tablix>
          <Tablix Name="Tablix3">
            <TablixBody>
              <TablixColumns>
                <TablixColumn>
                  <Width>3.75373in</Width>
                </TablixColumn>
              </TablixColumns>
              <TablixRows>
                <TablixRow>
                  <Height>0.29167in</Height>
                  <TablixCells>
                    <TablixCell>
                      <CellContents>
                        <Textbox Name="Textbox22">
                          <CanGrow>true</CanGrow>
                          <KeepTogether>true</KeepTogether>
                          <Paragraphs>
                            <Paragraph>
                              <TextRuns>
                                <TextRun>
                                  <Value>Memory Information Reports</Value>
                                  <Style>
                                    <FontSize>14pt</FontSize>
                                    <Color>White</Color>
                                  </Style>
                                </TextRun>
                              </TextRuns>
                              <Style>
                                <TextAlign>Center</TextAlign>
                              </Style>
                            </Paragraph>
                          </Paragraphs>
                          <rd:DefaultName>Textbox22</rd:DefaultName>
                          <Style>
                            <Border>
                              <Color>LightGrey</Color>
                              <Style>Solid</Style>
                            </Border>
                            <BackgroundColor>DarkBlue</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.32778in</Height>
                  <TablixCells>
                    <TablixCell>
                      <CellContents>
                        <Textbox Name="MenuItem2">
                          <CanGrow>true</CanGrow>
                          <KeepTogether>true</KeepTogether>
                          <Paragraphs>
                            <Paragraph>
                              <TextRuns>
                                <TextRun>
                                  <Value>=Switch(
  Fields!MenuItem.Value = "Additional Memory Counters" ,"Additional Memory Counters *"
, Fields!MenuItem.Value = "Connection Count and Memory Used" ,"Connection Count and Memory Used"
, Fields!MenuItem.Value = "Memory Dump File Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA",IIF(First(Fields!ProductMajorVersion.Value, "Version") &lt; 10.5, "OldVersion -  Memory Dump","Memory Dump File Information *"))
, Fields!MenuItem.Value = "Memory Grants Pending" ,"Memory Grants Pending *"
, Fields!MenuItem.Value = "Memory Settings and Counters" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Memory Settings and Counters *")
, Fields!MenuItem.Value = "Buffer Pool Usage" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Buffer Pool Usage *")
, Fields!MenuItem.Value = "Buffer Pool Usage For Objects" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Buffer Pool Usage For Objects")
, Fields!MenuItem.Value = "Spills To TempDB" ,IIF(First(Fields!ProductMajorVersion.Value, "Version") &lt; 13, "OldVersion -  Spills To TempDB","Spills To TempDB *"))</Value>
                                  <Style>
                                    <FontSize>14pt</FontSize>
                                    <Color>=Switch(
  Fields!MenuItem.Value = "Additional Memory Counters" ,"Black"
, Fields!MenuItem.Value = "Connection Count and Memory Used" ,"Black"
, Fields!MenuItem.Value = "Memory Dump File Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray",IIF(First(Fields!ProductMajorVersion.Value, "Version") &lt;= 10.5, "DarkGray","Black"))
, Fields!MenuItem.Value = "Memory Settings and Counters" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray","Black")
, Fields!MenuItem.Value = "Spills To TempDB" ,IIF(First(Fields!ProductMajorVersion.Value, "Version") &lt;= 13, "DarkGray","Black")
)</Color>
                                  </Style>
                                </TextRun>
                              </TextRuns>
                              <Style />
                            </Paragraph>
                          </Paragraphs>
                          <rd:DefaultName>MenuItem2</rd:DefaultName>
                          <ActionInfo>
                            <Actions>
                              <Action>
                                <Drillthrough>
                                  <ReportName>=Switch(
  Fields!MenuItem.Value = "Additional Memory Counters" ,"MoreMemoryCounters"
, Fields!MenuItem.Value = "Connection Count and Memory Used" ,"UserConnections"
, Fields!MenuItem.Value = "Memory Dump File Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,IIF(First(Fields!ProductMajorVersion.Value, "Version") &lt;= 10.5, Nothing,"MemoryDumpFileInformation"))
, Fields!MenuItem.Value = "Memory Grants Pending" ,"MemoryGrantsPending"
, Fields!MenuItem.Value = "Memory Settings and Counters" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,"MemorySettingsAndCounters")
, Fields!MenuItem.Value = "Buffer Pool Usage" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,"BufferPoolUsageYesNo")
, Fields!MenuItem.Value = "Buffer Pool Usage For Objects" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,"BufferPoolUsageForObjectsYesNo")
, Fields!MenuItem.Value = "Spills To TempDB" ,IIF(First(Fields!ProductMajorVersion.Value, "Version") &lt; 13, Nothing,"SpillsToTempDB")
)</ReportName>
                                </Drillthrough>
                              </Action>
                            </Actions>
                          </ActionInfo>
                          <Style>
                            <Border>
                              <Color>LightGrey</Color>
                              <Style>Solid</Style>
                            </Border>
                            <BackgroundColor>=IIF(ROWNUMBER(NOTHING) MOD 2, "LIGHTBLUE", "SILVER")</BackgroundColor>
                            <VerticalAlign>Middle</VerticalAlign>
                            <PaddingLeft>4pt</PaddingLeft>
                            <PaddingRight>2pt</PaddingRight>
                            <PaddingTop>2pt</PaddingTop>
                            <PaddingBottom>2pt</PaddingBottom>
                          </Style>
                        </Textbox>
                      </CellContents>
                    </TablixCell>
                  </TablixCells>
                </TablixRow>
              </TablixRows>
            </TablixBody>
            <TablixColumnHierarchy>
              <TablixMembers>
                <TablixMember />
              </TablixMembers>
            </TablixColumnHierarchy>
            <TablixRowHierarchy>
              <TablixMembers>
                <TablixMember>
                  <KeepWithGroup>After</KeepWithGroup>
                </TablixMember>
                <TablixMember>
                  <Group Name="Details2" />
                </TablixMember>
              </TablixMembers>
            </TablixRowHierarchy>
            <DataSetName>MemoryItems</DataSetName>
            <SortExpressions>
              <SortExpression>
                <Value>=Fields!MenuItem.Value</Value>
              </SortExpression>
            </SortExpressions>
            <Top>0.75111in</Top>
            <Height>0.61945in</Height>
            <Width>3.75373in</Width>
            <ZIndex>1</ZIndex>
            <Style>
              <Border>
                <Style>Solid</Style>
              </Border>
            </Style>
          </Tablix>
          <Tablix Name="Tablix8">
            <TablixBody>
              <TablixColumns>
                <TablixColumn>
                  <Width>3.75373in</Width>
                </TablixColumn>
              </TablixColumns>
              <TablixRows>
                <TablixRow>
                  <Height>0.25in</Height>
                  <TablixCells>
                    <TablixCell>
                      <CellContents>
                        <Textbox Name="Textbox59">
                          <CanGrow>true</CanGrow>
                          <KeepTogether>true</KeepTogether>
                          <Paragraphs>
                            <Paragraph>
                              <TextRuns>
                                <TextRun>
                                  <Value>Backups\Restores\HA\DR Reports</Value>
                                  <Style>
                                    <FontSize>14pt</FontSize>
                                    <Color>White</Color>
                                  </Style>
                                </TextRun>
                              </TextRuns>
                              <Style>
                                <TextAlign>Center</TextAlign>
                              </Style>
                            </Paragraph>
                          </Paragraphs>
                          <rd:DefaultName>Textbox59</rd:DefaultName>
                          <Style>
                            <Border>
                              <Color>LightGrey</Color>
                              <Style>Solid</Style>
                            </Border>
                            <BackgroundColor>DarkBlue</BackgroundColor>
                            <PaddingLeft>2pt</PaddingLeft>
                            <PaddingRight>2pt</PaddingRight>
                            <PaddingTop>2pt</PaddingTop>
                            <PaddingBottom>2pt</PaddingBottom>
                          </Style>
                        </Textbox>
                      </CellContents>
                    </TablixCell>
                  </TablixCells>
                </TablixRow>
                <TablixRow>
                  <Height>0.30833in</Height>
                  <TablixCells>
                    <TablixCell>
                      <CellContents>
                        <Textbox Name="MenuItem6">
                          <CanGrow>true</CanGrow>
                          <KeepTogether>true</KeepTogether>
                          <Paragraphs>
                            <Paragraph>
                              <TextRuns>
                                <TextRun>
                                  <Value>=Switch( 
  Fields!MenuItem.Value = "Availablity Group Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA",IIF(First(Fields!ProductMajorVersion.Value, "Version") &lt;= 10.5, "Old Version - AG Info", "Availablity Group Information"))
, Fields!MenuItem.Value = "Backup (All Other Types) Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Backup (All Other Types) Information")
, Fields!MenuItem.Value = "Backup (TLog Only) Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Backup (TLog Only) Information")
, Fields!MenuItem.Value = "Backup Speed Rate" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Backup Speed Rate")
, Fields!MenuItem.Value = "Backup(Full and Differential) Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Backup(Full and Differential) Information - Past 45 Days")
, Fields!MenuItem.Value = "Backup(Full and Differential) Information - Past 7 Days" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Backup(Full and Differential) Information - Past 7 Days")
, Fields!MenuItem.Value = "Cluster Node Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Cluster Node Information")
, Fields!MenuItem.Value = "Log Shipping Databases" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Log Shipping Databases")
, Fields!MenuItem.Value = "Mirrored Database Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Mirrored Database Information")
, Fields!MenuItem.Value = "Missing Backups" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Missing Backups")
, Fields!MenuItem.Value = "Replication Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Replication Information")
, Fields!MenuItem.Value = "Restore Progress" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Restore Progress")
, Fields!MenuItem.Value = "Backup Progress" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Backup Progress")
, Fields!MenuItem.Value = "Restore Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Restore History")
, Fields!MenuItem.Value = "Backup(Full and Differential) Information For a Database Past 45 Days" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Backup(Full and Differential) Information For a Database Past 45 Days")
, Fields!MenuItem.Value = "Backup(Log) Information For a Database Past 14 Days" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Backup(Log) Information For a Database Past 14 Days")
)</Value>
                                  <Style>
                                    <FontSize>14pt</FontSize>
                                    <Color>=Switch(
  Fields!MenuItem.Value = "Availablity Group Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray",IIF(First(Fields!ProductMajorVersion.Value, "Version") &lt;11, "DarkGrey","Black"))
, Fields!MenuItem.Value = "Backup (All Other Types) Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray","Black")
, Fields!MenuItem.Value = "Backup (TLog Only) Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray","Black")
, Fields!MenuItem.Value = "Backup Speed Rate" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray","Black")
, Fields!MenuItem.Value = "Backup(Full and Differential) Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray","Black")
, Fields!MenuItem.Value = "Cluster Node Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray","Black")
, Fields!MenuItem.Value = "Log Shipping Databases" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray","Black")
, Fields!MenuItem.Value = "Mirrored Database Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray","Black")
, Fields!MenuItem.Value = "Missing Backups" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray","Black")
, Fields!MenuItem.Value = "Replication Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray","Black")
, Fields!MenuItem.Value = "Restore Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5,"DarkGray","Black")
)</Color>
                                  </Style>
                                </TextRun>
                              </TextRuns>
                              <Style />
                            </Paragraph>
                          </Paragraphs>
                          <rd:DefaultName>MenuItem6</rd:DefaultName>
                          <ActionInfo>
                            <Actions>
                              <Action>
                                <Drillthrough>
                                  <ReportName>=Switch(
  Fields!MenuItem.Value = "Availablity Group Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "OldVersion",IIF(First(Fields!ProductMajorVersion.Value, "Version") &lt; 11, "OldVersion","AvailablityGroupInformation"))
, Fields!MenuItem.Value = "Backup (All Other Types) Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "OldVersion","BackupInformationOtherBkupType")
, Fields!MenuItem.Value = "Backup (TLog Only) Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "OldVersion","BackupInformationTLog")
, Fields!MenuItem.Value = "Backup Speed Rate" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "OldVersion","BackupSpeed")
, Fields!MenuItem.Value = "Backup(Full and Differential) Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "OldVersion","BackupInformation")
, Fields!MenuItem.Value = "Backup(Full and Differential) Information - Past 7 Days" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "OldVersion","BackupInformationFullPast7Days")
, Fields!MenuItem.Value = "Cluster Node Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "OldVersion","WindowsClusterInformation")
, Fields!MenuItem.Value = "Log Shipping Databases" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "OldVersion","LogShippingInformation")
, Fields!MenuItem.Value = "Mirrored Database Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "OldVersion","MirroredDatabases")
, Fields!MenuItem.Value = "Missing Backups" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "OldVersion","MissingBackups")
, Fields!MenuItem.Value = "Replication Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "OldVersion","ReplicationInfo")
, Fields!MenuItem.Value = "Restore Progress" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "OldVersion","RestoreProgress")
, Fields!MenuItem.Value = "Backup Progress" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "OldVersion","BackupProgress")
, Fields!MenuItem.Value = "Restore Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "OldVersion","RestoreInformation")
, Fields!MenuItem.Value = "Backup(Full and Differential) Information For a Database Past 45 Days" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "OldVersion","BackupSpecificDBpicker")
, Fields!MenuItem.Value = "Backup(Log) Information For a Database Past 14 Days" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "OldVersion","BackupSpecificDBpickerlog")
)</ReportName>
                                </Drillthrough>
                              </Action>
                            </Actions>
                          </ActionInfo>
                          <Style>
                            <Border>
                              <Color>LightGrey</Color>
                              <Style>Solid</Style>
                            </Border>
                            <BackgroundColor>=IIF(ROWNUMBER(NOTHING) MOD 2, "LIGHTBLUE", "SILVER")</BackgroundColor>
                            <VerticalAlign>Middle</VerticalAlign>
                            <PaddingLeft>4pt</PaddingLeft>
                            <PaddingRight>2pt</PaddingRight>
                            <PaddingTop>2pt</PaddingTop>
                            <PaddingBottom>2pt</PaddingBottom>
                          </Style>
                        </Textbox>
                      </CellContents>
                    </TablixCell>
                  </TablixCells>
                </TablixRow>
                <TablixRow>
                  <Height>1.57667in</Height>
                  <TablixCells>
                    <TablixCell>
                      <CellContents>
                        <Textbox Name="Textbox65">
                          <CanGrow>true</CanGrow>
                          <KeepTogether>true</KeepTogether>
                          <Paragraphs>
                            <Paragraph>
                              <TextRuns>
                                <TextRun>
                                  <Value />
                                  <Style>
                                    <FontSize>14pt</FontSize>
                                    <FontWeight>Normal</FontWeight>
                                    <TextDecoration>None</TextDecoration>
                                    <Color>White</Color>
                                  </Style>
                                </TextRun>
                              </TextRuns>
                              <Style>
                                <TextAlign>Center</TextAlign>
                              </Style>
                            </Paragraph>
                            <Paragraph>
                              <TextRuns>
                                <TextRun>
                                  <Value>(D) = Database specific and it must be the current database, otherwise will return data on incorrect database.  If not in proper database, run report by right clicking on the desired database</Value>
                                  <Style>
                                    <FontSize>14pt</FontSize>
                                    <FontWeight>Normal</FontWeight>
                                    <TextDecoration>None</TextDecoration>
                                    <Color>White</Color>
                                  </Style>
                                </TextRun>
                              </TextRuns>
                              <Style>
                                <TextAlign>Center</TextAlign>
                              </Style>
                            </Paragraph>
                            <Paragraph>
                              <TextRuns>
                                <TextRun>
                                  <Value />
                                  <Style>
                                    <FontSize>14pt</FontSize>
                                    <FontWeight>Normal</FontWeight>
                                    <TextDecoration>None</TextDecoration>
                                    <Color>White</Color>
                                  </Style>
                                </TextRun>
                              </TextRuns>
                              <Style />
                            </Paragraph>
                          </Paragraphs>
                          <rd:DefaultName>Textbox65</rd:DefaultName>
                          <Style>
                            <Border>
                              <Color>LightGrey</Color>
                              <Style>Solid</Style>
                            </Border>
                            <BackgroundColor>DarkBlue</BackgroundColor>
                            <VerticalAlign>Middle</VerticalAlign>
                            <PaddingLeft>4pt</PaddingLeft>
                            <PaddingRight>2pt</PaddingRight>
                            <PaddingTop>2pt</PaddingTop>
                            <PaddingBottom>2pt</PaddingBottom>
                          </Style>
                        </Textbox>
                      </CellContents>
                    </TablixCell>
                  </TablixCells>
                </TablixRow>
              </TablixRows>
            </TablixBody>
            <TablixColumnHierarchy>
              <TablixMembers>
                <TablixMember />
              </TablixMembers>
            </TablixColumnHierarchy>
            <TablixRowHierarchy>
              <TablixMembers>
                <TablixMember>
                  <KeepWithGroup>After</KeepWithGroup>
                </TablixMember>
                <TablixMember>
                  <Group Name="Details6" />
                </TablixMember>
                <TablixMember>
                  <KeepWithGroup>Before</KeepWithGroup>
                </TablixMember>
              </TablixMembers>
            </TablixRowHierarchy>
            <DataSetName>BackupsDRHA</DataSetName>
            <Top>1.41222in</Top>
            <Height>2.135in</Height>
            <Width>3.75373in</Width>
            <ZIndex>2</ZIndex>
            <Style>
              <Border>
                <Style>Solid</Style>
              </Border>
            </Style>
          </Tablix>
        </ReportItems>
        <KeepTogether>true</KeepTogether>
        <Top>1.58278in</Top>
        <Left>0.09126in</Left>
        <Height>3.54722in</Height>
        <Width>3.82207in</Width>
        <ZIndex>7</ZIndex>
        <Style>
          <Border>
            <Style>None</Style>
          </Border>
        </Style>
      </Rectangle>
      <Rectangle Name="Rectangle4">
        <ReportItems>
          <Tablix Name="Tablix2">
            <TablixBody>
              <TablixColumns>
                <TablixColumn>
                  <Width>4.15001in</Width>
                </TablixColumn>
              </TablixColumns>
              <TablixRows>
                <TablixRow>
                  <Height>0.30459in</Height>
                  <TablixCells>
                    <TablixCell>
                      <CellContents>
                        <Textbox Name="Textbox20">
                          <CanGrow>true</CanGrow>
                          <KeepTogether>true</KeepTogether>
                          <Paragraphs>
                            <Paragraph>
                              <TextRuns>
                                <TextRun>
                                  <Value>Jobs, Alerts and Operators Reports</Value>
                                  <Style>
                                    <FontSize>14pt</FontSize>
                                    <Color>White</Color>
                                  </Style>
                                </TextRun>
                              </TextRuns>
                              <Style>
                                <TextAlign>Center</TextAlign>
                              </Style>
                            </Paragraph>
                          </Paragraphs>
                          <rd:DefaultName>Textbox20</rd:DefaultName>
                          <Style>
                            <Border>
                              <Color>LightGrey</Color>
                              <Style>Solid</Style>
                            </Border>
                            <BackgroundColor>DarkBlue</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.3582in</Height>
                  <TablixCells>
                    <TablixCell>
                      <CellContents>
                        <Textbox Name="MenuItem1">
                          <CanGrow>true</CanGrow>
                          <KeepTogether>true</KeepTogether>
                          <Paragraphs>
                            <Paragraph>
                              <TextRuns>
                                <TextRun>
                                  <Value>=Switch(
  Fields!MenuItem.Value = "Alert Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Alert Information")
, Fields!MenuItem.Value = "Auto Delete Jobs" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Auto Delete Jobs")
, Fields!MenuItem.Value = "Currently Running Jobs" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Currently Executing Jobs *")
, Fields!MenuItem.Value = "Job Failure Rate Past 90 Days" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Job Failure Rate")
, Fields!MenuItem.Value = "Job Failures Last 30 Days" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Job Failures Past 30 Days")
, Fields!MenuItem.Value = "Job Step Retries Past 24 hours" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Job Step Retries Past 24 hours")
, Fields!MenuItem.Value = "Job Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Job Information *")
, Fields!MenuItem.Value = "Job Step Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Job Step Information")
, Fields!MenuItem.Value = "Jobs Using Schedules" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Jobs Using Schedules")
, Fields!MenuItem.Value = "SQL Server Agent Properties" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","SQL Server Agent Properties")
, Fields!MenuItem.Value = "Job History" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Job History *")
, Fields!MenuItem.Value = "JobHistory24Hours" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Job History Past 24 Hours *")
, Fields!MenuItem.Value = "Job Schedules" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA",IIF(Sum(Fields!Default.Value, "DefaultTraceEnabled") = 1,"Job Schedules", "Default Trace is Disabled"))
, Fields!MenuItem.Value = "JobExecuteTime" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Jobs Executing\Spec. Time *")
, Fields!MenuItem.Value = "Jobs Running Longer Than Average" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Jobs Running Longer Than Average *")
, Fields!MenuItem.Value = "Jobs with No Configured Notification" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA",IIF(First(Fields!ProductMajorVersion.Value, "Version") &lt; 10.5, "OldVersion - Notification", "Jobs with No Configured Notification"))
, Fields!MenuItem.Value = "Operator Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Operator Information"))</Value>
                                  <Style>
                                    <FontSize>14pt</FontSize>
                                    <Color>=Switch(
  Fields!MenuItem.Value = "Alert Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray","Black")
, Fields!MenuItem.Value = "Auto Delete Jobs" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray","Black")
, Fields!MenuItem.Value = "Currently Running Jobs" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray","Black")
, Fields!MenuItem.Value = "Job Failure Rate Past 90 Days" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray","Black")
, Fields!MenuItem.Value = "Job Failures Last 30 Days" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray","Black")
, Fields!MenuItem.Value = "JJob Step Retries Past 24 hours" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray","Black")
, Fields!MenuItem.Value = "Job Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray","Black")
, Fields!MenuItem.Value = "Job Step Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray","Black")
, Fields!MenuItem.Value = "Jobs Using Schedules" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray","Black")
, Fields!MenuItem.Value = "Job Schedules" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5,"DarkGray",IIF(Sum(Fields!Default.Value, "DefaultTraceEnabled") = 0, "DarkGray","Black"))
, Fields!MenuItem.Value = "Jobs with No Configured Notification" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray",IIF(First(Fields!ProductMajorVersion.Value, "Version") &lt; 10.5, "DarkGray", "Black"))
, Fields!MenuItem.Value = "Operator Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray","Black"))</Color>
                                  </Style>
                                </TextRun>
                              </TextRuns>
                              <Style />
                            </Paragraph>
                          </Paragraphs>
                          <rd:DefaultName>MenuItem1</rd:DefaultName>
                          <ActionInfo>
                            <Actions>
                              <Action>
                                <Drillthrough>
                                  <ReportName>=Switch(
  Fields!MenuItem.Value = "Alert Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,"AlertInformation")
, Fields!MenuItem.Value = "Auto Delete Jobs" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,"AutoDeleteJobs")
, Fields!MenuItem.Value = "Currently Running Jobs" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,"CurrentlyExecutingJobs")
, Fields!MenuItem.Value = "Job Failure Rate Past 90 Days" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,"JobFailureRate")
, Fields!MenuItem.Value = "Job Failures Last 30 Days" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,"JobFailures")
, Fields!MenuItem.Value = "Job Step Retries Past 24 hours" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,"JobStepsRetryPast24Hours")
, Fields!MenuItem.Value = "Job Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,"JobInformation")
, Fields!MenuItem.Value = "Job Step Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,"JobStepInformation")
, Fields!MenuItem.Value = "Jobs Using Schedules" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,"JobsUsingSchedules")
, Fields!MenuItem.Value = "SQL Server Agent Properties" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,"SQLServerAgentProperties")
, Fields!MenuItem.Value = "Job History" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,"JobHistory")
, Fields!MenuItem.Value = "JobHistory24Hours" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,"JobFailuresPast24Hours")
, Fields!MenuItem.Value = "Job Schedules" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,IIF(Sum(Fields!Default.Value, "DefaultTraceEnabled") = 0, Nothing,"JobSchedules"))
, Fields!MenuItem.Value = "JobExecuteTime" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,"JobExecutionAtSpecificTimePicker")
, Fields!MenuItem.Value = "Jobs Running Longer Than Average" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,"JobHistoryPerecentPicker")
, Fields!MenuItem.Value = "Jobs with No Configured Notification" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,IIF(First(Fields!ProductMajorVersion.Value, "Version") &lt;= 10.5, Nothing,IIF(Fields!MenuItem.Value = "Jobs with No Configured Notification", "JobsWithNoConfiguredNotification",Nothing)))
, Fields!MenuItem.Value = "Operator Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,"OperatorInformation")
)</ReportName>
                                </Drillthrough>
                              </Action>
                            </Actions>
                          </ActionInfo>
                          <Style>
                            <Border>
                              <Color>LightGrey</Color>
                              <Style>Solid</Style>
                            </Border>
                            <BackgroundColor>=IIF(ROWNUMBER(NOTHING) MOD 2, "LIGHTBLUE", "SILVER")</BackgroundColor>
                            <PaddingLeft>4pt</PaddingLeft>
                            <PaddingRight>2pt</PaddingRight>
                            <PaddingTop>2pt</PaddingTop>
                            <PaddingBottom>2pt</PaddingBottom>
                          </Style>
                        </Textbox>
                        <rd:Selected>true</rd:Selected>
                      </CellContents>
                    </TablixCell>
                  </TablixCells>
                </TablixRow>
              </TablixRows>
            </TablixBody>
            <TablixColumnHierarchy>
              <TablixMembers>
                <TablixMember />
              </TablixMembers>
            </TablixColumnHierarchy>
            <TablixRowHierarchy>
              <TablixMembers>
                <TablixMember>
                  <KeepWithGroup>After</KeepWithGroup>
                </TablixMember>
                <TablixMember>
                  <Group Name="Details1" />
                </TablixMember>
              </TablixMembers>
            </TablixRowHierarchy>
            <DataSetName>JobsAlertsOperators</DataSetName>
            <Height>0.66279in</Height>
            <Width>4.15001in</Width>
            <Style>
              <Border>
                <Style>Solid</Style>
              </Border>
            </Style>
          </Tablix>
          <Tablix Name="Tablix5">
            <TablixBody>
              <TablixColumns>
                <TablixColumn>
                  <Width>4.15001in</Width>
                </TablixColumn>
              </TablixColumns>
              <TablixRows>
                <TablixRow>
                  <Height>0.33166in</Height>
                  <TablixCells>
                    <TablixCell>
                      <CellContents>
                        <Textbox Name="Textbox34">
                          <CanGrow>true</CanGrow>
                          <KeepTogether>true</KeepTogether>
                          <Paragraphs>
                            <Paragraph>
                              <TextRuns>
                                <TextRun>
                                  <Value>Server Information Reports</Value>
                                  <Style>
                                    <FontSize>14pt</FontSize>
                                    <Color>White</Color>
                                  </Style>
                                </TextRun>
                              </TextRuns>
                              <Style>
                                <TextAlign>Center</TextAlign>
                              </Style>
                            </Paragraph>
                          </Paragraphs>
                          <rd:DefaultName>Textbox34</rd:DefaultName>
                          <Style>
                            <Border>
                              <Color>LightGrey</Color>
                              <Style>Solid</Style>
                            </Border>
                            <BackgroundColor>DarkBlue</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.3in</Height>
                  <TablixCells>
                    <TablixCell>
                      <CellContents>
                        <Textbox Name="MenuItem4">
                          <CanGrow>true</CanGrow>
                          <KeepTogether>true</KeepTogether>
                          <Paragraphs>
                            <Paragraph>
                              <TextRuns>
                                <TextRun>
                                  <Value>=Switch(
  Fields!MenuItem.Value = "Azure SQL DB Service Tiers" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") &lt;&gt; 5, "Only works in Azure DB","Azure SQL DB Service Tiers")
, Fields!MenuItem.Value = "Buffer Pool Extension Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Buffer Pool Extension Information")
, Fields!MenuItem.Value = "Cluster Node Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Cluster Node Information")
, Fields!MenuItem.Value = "Connection IP Addresses" ,"Connection IP Addresses"
, Fields!MenuItem.Value = "Custom Error Messages" ,"Custom Error Messages"
, Fields!MenuItem.Value = "Data Collection Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Data Collection Information")
, Fields!MenuItem.Value = "Database Mail Status and History" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Database Mail Status and History")
, Fields!MenuItem.Value = "Error Log File Size" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Error Log File Size")
, Fields!MenuItem.Value = "Extended Events Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Extended Events Information *")
, Fields!MenuItem.Value = "Extended Events Session Status" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") &lt;&gt; 5 AND First(Fields!ProductMajorVersion.Value, "Version") &lt;10, "Old Version - Extended Events Status","Extended Events Session Status")
, Fields!MenuItem.Value = "General Server Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","General Server Information")
, Fields!MenuItem.Value = "General Server OS Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA",IIF(Sum(Fields!VersionOfSQLServer.Value, "Version") &lt;= 11, "Old Version - OS Information","General Server OS Information"))
, Fields!MenuItem.Value = "Mail Configuration" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Mail Configuration")
, Fields!MenuItem.Value = "Mail Configuration Parameters" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Mail Configuration Parameters")
, Fields!MenuItem.Value = "OS Power Plan Setting" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","OS Power Plan Setting *")
, Fields!MenuItem.Value = "Processor Information" ,"Processor Information"
, Fields!MenuItem.Value = "Server Triggers" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Server Triggers")
, Fields!MenuItem.Value = "Service Account Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA",IIF(First(Fields!ProductMajorVersion.Value, "Version") &lt;= 10, "Old Version - Service Account","Service Account Information"))
, Fields!MenuItem.Value = "Spinlock Information" ,"Spinlock Information *"
, Fields!MenuItem.Value = "Start up Parameters" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA",IIF(Sum(Fields!VersionOfSQLServer.Value, "Version") &lt;= 11, "Old Version - Start up Parameters","Start up Parameters"))
, Fields!MenuItem.Value = "Sys.Configurations" ,"Sys.Configurations *"
, Fields!MenuItem.Value = "Trace Flags Being Used" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Trace Flag start entries in log")
, Fields!MenuItem.Value = "Trace Flags Enabled" ,"Trace Flags Enabled"
, Fields!MenuItem.Value = "Trace Flags Startup" ,"Trace Flags Enabled at Startup"
, Fields!MenuItem.Value = "Trace Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Trace Information")
, Fields!MenuItem.Value = "Performance Counters Installed" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Performance Counters Installed")
)</Value>
                                  <Style>
                                    <FontSize>14pt</FontSize>
                                    <Color>=Switch(
  Fields!MenuItem.Value = "Azure SQL DB Service Tiers" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") &lt;&gt; 5, "DarkGray","Black")
, Fields!MenuItem.Value = "Buffer Pool Extension Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray","Black")
, Fields!MenuItem.Value = "Cluster Node Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray","BLack")
, Fields!MenuItem.Value = "Connection IP Addresses" ,"BLack"
, Fields!MenuItem.Value = "Custom Error Messages" ,"BLack"
, Fields!MenuItem.Value = "Data Collection Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray","Black")
, Fields!MenuItem.Value = "Database Mail Status and History" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray","Black")
, Fields!MenuItem.Value = "Error Log File Size" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray","Black")
, Fields!MenuItem.Value = "Extended Events Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray","BLack")
, Fields!MenuItem.Value = "Extended Events Session Status" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") &lt;&gt; 5 AND First(Fields!ProductMajorVersion.Value, "Version") &lt;10, "DarkGray","Black")
, Fields!MenuItem.Value = "General Server Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray","Black")
, Fields!MenuItem.Value = "General Server OS Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray",IIF(Sum(Fields!VersionOfSQLServer.Value, "Version") &lt;= 11, "DarkGray","Black"))
, Fields!MenuItem.Value = "Mail Configuration" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray","Black")
, Fields!MenuItem.Value = "Mail Configuration Parameters" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray","Black")
, Fields!MenuItem.Value = "OS Power Plan Setting" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray","Black")
, Fields!MenuItem.Value = "Processor Information" ,"BLack"
, Fields!MenuItem.Value = "Server Triggers" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray","BLack")
, Fields!MenuItem.Value = "Service Account Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray",IIF(First(Fields!ProductMajorVersion.Value, "Version") &lt;= 10, "DarkGray","Black"))
, Fields!MenuItem.Value = "Spinlock Information" ,"BLack"
, Fields!MenuItem.Value = "Start up Parameters" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray",IIF(Sum(Fields!VersionOfSQLServer.Value, "Version") &lt;= 11, "DarkGray","BLack"))
, Fields!MenuItem.Value = "Sys.Configurations" ,"BLack"
, Fields!MenuItem.Value = "Trace Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray","BLack")
, Fields!MenuItem.Value = "Trace Flags Being Used" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray","Black")
, Fields!MenuItem.Value = "Trace Flags Enabled" ,"BLack"
)</Color>
                                  </Style>
                                </TextRun>
                              </TextRuns>
                              <Style />
                            </Paragraph>
                          </Paragraphs>
                          <rd:DefaultName>MenuItem4</rd:DefaultName>
                          <ActionInfo>
                            <Actions>
                              <Action>
                                <Drillthrough>
                                  <ReportName>=Switch(
  Fields!MenuItem.Value = "Azure SQL DB Service Tiers" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") &lt;&gt; 5, Nothing,"AzureServiceTier")
, Fields!MenuItem.Value = "Buffer Pool Extension Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,"BufferPoolExtensionInformation")
, Fields!MenuItem.Value = "Cluster Node Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,"WindowsClusterInformation")
, Fields!MenuItem.Value = "Connection IP Addresses" ,"IPAddressesConnected"
, Fields!MenuItem.Value = "Custom Error Messages" ,"CustomMessages"
, Fields!MenuItem.Value = "Data Collection Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,"DataCollectionInformation")
, Fields!MenuItem.Value = "Database Mail Status and History" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,"DatabaseMailEmailSentStatus")
, Fields!MenuItem.Value = "Error Log File Size" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,"ErrorLogFileSize")
, Fields!MenuItem.Value = "Extended Events Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,"ExtendedEventInformation")
, Fields!MenuItem.Value = "Extended Events Session Status" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") &lt;&gt; 5 AND First(Fields!ProductMajorVersion.Value, "Version") &lt;10, Nothing,"ExtendedEventSessionStatus")
, Fields!MenuItem.Value = "General Server Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,"GeneralInformation")
, Fields!MenuItem.Value = "General Server OS Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,IIF(Sum(Fields!VersionOfSQLServer.Value, "Version") &lt;= 11, Nothing,"GeneralInformationWithOS"))
, Fields!MenuItem.Value = "OS Power Plan Setting" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,"OSPowerPlanSetting")
, Fields!MenuItem.Value = "Processor Information" ,"ProcessorInformation"
, Fields!MenuItem.Value = "Mail Configuration" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,"MailConfiguration")
, Fields!MenuItem.Value = "Mail Configuration Parameters" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,"MailConfigParameters")
, Fields!MenuItem.Value = "Server Triggers" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,"ServerTriggers")
, Fields!MenuItem.Value = "Service Account Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,IIF(First(Fields!ProductMajorVersion.Value, "Version") &lt;= 10, Nothing, "ServiceAccountInformation"))
, Fields!MenuItem.Value = "Spinlock Information" ,"SpinLockInformation"
, Fields!MenuItem.Value = "Start up Parameters" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,IIF(First(Fields!ProductMajorVersion.Value, "Version") &lt;= 11, Nothing, "StartupParameters"))
, Fields!MenuItem.Value = "Sys.Configurations" ,"SysConfiguration"
, Fields!MenuItem.Value = "Trace Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,"Traces")
, Fields!MenuItem.Value = "Trace Flags Being Used" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,"Traceflagsbeingused")
, Fields!MenuItem.Value = "Trace Flags Enabled" ,"EnabledTraceFlags"
, Fields!MenuItem.Value = "Trace Flags Startup" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,"TraceFlagsEnabledStartup")
, Fields!MenuItem.Value = "Performance Counters Installed" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,"PerformanceCountersInstalled")
)</ReportName>
                                </Drillthrough>
                              </Action>
                            </Actions>
                          </ActionInfo>
                          <Style>
                            <Border>
                              <Color>LightGrey</Color>
                              <Style>Solid</Style>
                            </Border>
                            <BackgroundColor>=IIF(ROWNUMBER(NOTHING) MOD 2, "LIGHTBLUE", "SILVER")</BackgroundColor>
                            <VerticalAlign>Middle</VerticalAlign>
                            <PaddingLeft>4pt</PaddingLeft>
                            <PaddingRight>2pt</PaddingRight>
                            <PaddingTop>2pt</PaddingTop>
                            <PaddingBottom>2pt</PaddingBottom>
                          </Style>
                        </Textbox>
                      </CellContents>
                    </TablixCell>
                  </TablixCells>
                </TablixRow>
                <TablixRow>
                  <Height>0.70833in</Height>
                  <TablixCells>
                    <TablixCell>
                      <CellContents>
                        <Textbox Name="Textbox1">
                          <CanGrow>true</CanGrow>
                          <KeepTogether>true</KeepTogether>
                          <Paragraphs>
                            <Paragraph>
                              <TextRuns>
                                <TextRun>
                                  <Value>Click here to see Report Descriptions</Value>
                                  <Style>
                                    <FontSize>14pt</FontSize>
                                    <TextDecoration>None</TextDecoration>
                                    <Color>White</Color>
                                  </Style>
                                </TextRun>
                              </TextRuns>
                              <Style>
                                <TextAlign>Center</TextAlign>
                              </Style>
                            </Paragraph>
                          </Paragraphs>
                          <rd:DefaultName>Textbox1</rd:DefaultName>
                          <ActionInfo>
                            <Actions>
                              <Action>
                                <Drillthrough>
                                  <ReportName>ReportDescription</ReportName>
                                </Drillthrough>
                              </Action>
                            </Actions>
                          </ActionInfo>
                          <Style>
                            <Border>
                              <Color>LightGrey</Color>
                              <Style>Solid</Style>
                            </Border>
                            <BackgroundColor>DarkBlue</BackgroundColor>
                            <VerticalAlign>Middle</VerticalAlign>
                            <PaddingLeft>4pt</PaddingLeft>
                            <PaddingRight>2pt</PaddingRight>
                            <PaddingTop>2pt</PaddingTop>
                            <PaddingBottom>2pt</PaddingBottom>
                          </Style>
                        </Textbox>
                      </CellContents>
                    </TablixCell>
                  </TablixCells>
                </TablixRow>
                <TablixRow>
                  <Height>0.79167in</Height>
                  <TablixCells>
                    <TablixCell>
                      <CellContents>
                        <Textbox Name="Textbox57">
                          <CanGrow>true</CanGrow>
                          <KeepTogether>true</KeepTogether>
                          <Paragraphs>
                            <Paragraph>
                              <TextRuns>
                                <TextRun>
                                  <Value>Click here to see the Disclaimer and Contact Information</Value>
                                  <Style>
                                    <FontSize>14pt</FontSize>
                                    <TextDecoration>None</TextDecoration>
                                    <Color>White</Color>
                                  </Style>
                                </TextRun>
                              </TextRuns>
                              <Style>
                                <TextAlign>Center</TextAlign>
                              </Style>
                            </Paragraph>
                          </Paragraphs>
                          <rd:DefaultName>Textbox57</rd:DefaultName>
                          <ActionInfo>
                            <Actions>
                              <Action>
                                <Drillthrough>
                                  <ReportName>Disclaimer</ReportName>
                                </Drillthrough>
                              </Action>
                            </Actions>
                          </ActionInfo>
                          <Style>
                            <Border>
                              <Color>LightGrey</Color>
                              <Style>Solid</Style>
                            </Border>
                            <BackgroundColor>DarkBlue</BackgroundColor>
                            <VerticalAlign>Middle</VerticalAlign>
                            <PaddingLeft>4pt</PaddingLeft>
                            <PaddingRight>2pt</PaddingRight>
                            <PaddingTop>2pt</PaddingTop>
                            <PaddingBottom>2pt</PaddingBottom>
                          </Style>
                        </Textbox>
                      </CellContents>
                    </TablixCell>
                  </TablixCells>
                </TablixRow>
              </TablixRows>
            </TablixBody>
            <TablixColumnHierarchy>
              <TablixMembers>
                <TablixMember />
              </TablixMembers>
            </TablixColumnHierarchy>
            <TablixRowHierarchy>
              <TablixMembers>
                <TablixMember>
                  <KeepWithGroup>After</KeepWithGroup>
                </TablixMember>
                <TablixMember>
                  <Group Name="Details4" />
                </TablixMember>
                <TablixMember>
                  <KeepWithGroup>Before</KeepWithGroup>
                </TablixMember>
                <TablixMember>
                  <KeepWithGroup>Before</KeepWithGroup>
                </TablixMember>
              </TablixMembers>
            </TablixRowHierarchy>
            <DataSetName>ServerInformation</DataSetName>
            <Top>0.73223in</Top>
            <Height>2.13166in</Height>
            <Width>4.15001in</Width>
            <ZIndex>1</ZIndex>
            <Style>
              <Border>
                <Style>Solid</Style>
              </Border>
            </Style>
          </Tablix>
        </ReportItems>
        <KeepTogether>true</KeepTogether>
        <Top>1.58944in</Top>
        <Left>7.49958in</Left>
        <Height>3.06389in</Height>
        <Width>4.15001in</Width>
        <ZIndex>8</ZIndex>
        <Style>
          <Border>
            <Style>None</Style>
          </Border>
        </Style>
      </Rectangle>
      <Tablix Name="Tablix7">
        <TablixBody>
          <TablixColumns>
            <TablixColumn>
              <Width>3.41929in</Width>
            </TablixColumn>
          </TablixColumns>
          <TablixRows>
            <TablixRow>
              <Height>0.29528in</Height>
              <TablixCells>
                <TablixCell>
                  <CellContents>
                    <Textbox Name="Textbox48">
                      <CanGrow>true</CanGrow>
                      <KeepTogether>true</KeepTogether>
                      <Paragraphs>
                        <Paragraph>
                          <TextRuns>
                            <TextRun>
                              <Value>Security Reports</Value>
                              <Style>
                                <FontSize>14pt</FontSize>
                                <Color>White</Color>
                              </Style>
                            </TextRun>
                          </TextRuns>
                          <Style>
                            <TextAlign>Center</TextAlign>
                          </Style>
                        </Paragraph>
                      </Paragraphs>
                      <rd:DefaultName>Textbox48</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>LightGrey</Color>
                          <Style>Solid</Style>
                        </Border>
                        <BackgroundColor>DarkBlue</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.33027in</Height>
              <TablixCells>
                <TablixCell>
                  <CellContents>
                    <Textbox Name="MenuItem5">
                      <CanGrow>true</CanGrow>
                      <KeepTogether>true</KeepTogether>
                      <Paragraphs>
                        <Paragraph>
                          <TextRuns>
                            <TextRun>
                              <Value>=Switch(
  Fields!MenuItem.Value = "All Permissions On The Database" ,"All Permissions On The Database"
, Fields!MenuItem.Value = "Authentication Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Authentication Information")
, Fields!MenuItem.Value = "Credential Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Credential Information")
, Fields!MenuItem.Value = "Database Audit Specification Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Database Audit Specification Info.")
, Fields!MenuItem.Value = "Database Role Members" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Database Role Members")
, Fields!MenuItem.Value = "Database Users" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Database Users")
, Fields!MenuItem.Value = "Email In Job Steps" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Email In Job Steps")
, Fields!MenuItem.Value = "Encrypted Database Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA",IIF(First(Fields!ProductMajorVersion.Value, "Version") &lt; 14, "Old Version - Encrypted Database","Encrypted Database Information"))
, Fields!MenuItem.Value = "Failed Logins" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Failed Logins")
, Fields!MenuItem.Value = "Guest Account Permissions and Status (D)" ,"Guest Account Permissions and Status (D)"
, Fields!MenuItem.Value = "Guest Account Status All Databases" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Guest Account Status All Databases")
, Fields!MenuItem.Value = "Linked Server Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Linked Server Information")
, Fields!MenuItem.Value = "Login Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA",IIF(Sum(Fields!VersionOfSQLServer.Value, "Version")&lt;= 10, "Old Version - Login Info", "Login Information"))
, Fields!MenuItem.Value = "Procedures With Execute As   (D)" ,"Procedures With Execute As   (D)"
, Fields!MenuItem.Value = "Proxy Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Proxy Information")
, Fields!MenuItem.Value = "Public Role Permissions  (D)" ,"Public Role Permissions  (D)"
, Fields!MenuItem.Value = "SA Audit and Password Review" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","SA Audit and Password Review")
, Fields!MenuItem.Value = "Security Policy Information" ,"Security Policy Information"
, Fields!MenuItem.Value = "Schema Owners w\Number of Objects" ,"Schema Owners w\Number of Objects"
, Fields!MenuItem.Value = "Schema Objects" ,"Schema Objects"
, Fields!MenuItem.Value = "Login Last Password Change" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Login Last Password Change")
, Fields!MenuItem.Value = "Dropped Logins" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA",IIF(First(Fields!DBExists.Value, "AdminMonitorExists") = 0, "AdminMonitor DB Does not Exist","Dropped Logins"))
, Fields!MenuItem.Value = "Dropped DB Users" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA",IIF(First(Fields!DBExists.Value, "AdminMonitorExists") = 0, "AdminMonitor DB Does not Exist","Dropped DB Users"))
, Fields!MenuItem.Value = "Server Audit Specification Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Server Audit Specification Information")
, Fields!MenuItem.Value = "Server Permissions other than Connect" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Server Permissions other than Connect")
, Fields!MenuItem.Value = "Server Role Information and Membership" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Server Role Information and Membership")
, Fields!MenuItem.Value = "Users DMLRights other than SELECT (D)" ,"Users DMLRights other than SELECT (D)"
)</Value>
                              <Style>
                                <FontSize>14pt</FontSize>
                                <Color>=Switch(
  Fields!MenuItem.Value = "All Permissions On The Database" ,"Black"
, Fields!MenuItem.Value = "Authentication Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray","Black")
, Fields!MenuItem.Value = "Credential Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray","Black")
, Fields!MenuItem.Value = "Database Audit Specification Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray","Black")
, Fields!MenuItem.Value = "Database Role Members" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray","Black")
, Fields!MenuItem.Value = "Database Users" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray","Black")
, Fields!MenuItem.Value = "Email In Job Steps" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray","Black")
, Fields!MenuItem.Value = "Encrypted Database Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray",IIF(First(Fields!ProductMajorVersion.Value, "Version") &lt; 14, "DarkGray","Black"))
, Fields!MenuItem.Value = "Failed Logins" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray","Black")
, Fields!MenuItem.Value = "Login Last Password Change" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray","Black")
, Fields!MenuItem.Value = "Guest Account Permissions and Status (D)" ,"Black"
, Fields!MenuItem.Value = "Schema Objects" ,"Black"
, Fields!MenuItem.Value = "Guest Account Status All Databases" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray","Black")
, Fields!MenuItem.Value = "Dropped Logins" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray",IIF(First(Fields!DBExists.Value, "AdminMonitorExists") = 0, "DarkGray","Black"))
, Fields!MenuItem.Value = "Dropped DB Users" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray",IIF(First(Fields!DBExists.Value, "AdminMonitorExists") = 0, "DarkGray","Black"))
, Fields!MenuItem.Value = "Linked Server Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray","Black")
, Fields!MenuItem.Value = "Login Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray",IIF(Sum(Fields!VersionOfSQLServer.Value, "Version")&lt;= 10, "DarkGray", "Black"))
, Fields!MenuItem.Value = "Proxy Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray","Black")
, Fields!MenuItem.Value = "Public Role Permissions  (D)" ,"BLack"
, Fields!MenuItem.Value = "Security Policy Information" ,"Black"
, Fields!MenuItem.Value = "SA Audit and Password Review" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray","Black")
, Fields!MenuItem.Value = "Server Audit Specification Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray","Black")
, Fields!MenuItem.Value = "Server Permissions other than Connect" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray","Black")
, Fields!MenuItem.Value = "Server Role Information and Membership" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray","Black")
, Fields!MenuItem.Value = "Users DMLRights other than SELECT (D)" ,"Black"
)</Color>
                              </Style>
                            </TextRun>
                          </TextRuns>
                          <Style />
                        </Paragraph>
                      </Paragraphs>
                      <rd:DefaultName>MenuItem5</rd:DefaultName>
                      <ActionInfo>
                        <Actions>
                          <Action>
                            <Drillthrough>
                              <ReportName>=Switch(
  Fields!MenuItem.Value = "All Permissions On The Database" ,"AllPermissionsOntheDatabase"
, Fields!MenuItem.Value = "Authentication Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,"AuthenticationInfo")
, Fields!MenuItem.Value = "Credential Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,"CredentialInformation")
, Fields!MenuItem.Value = "Database Audit Specification Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,"DatabaseAuditInformation")
, Fields!MenuItem.Value = "Database Role Members" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,"DatabaseRoleMembers")
, Fields!MenuItem.Value = "Database Users" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,"DatabaseUsers")
, Fields!MenuItem.Value = "Email In Job Steps" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,"EmbeddedEmailInJobSteps")
, Fields!MenuItem.Value = "Encrypted Database Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,IIF(First(Fields!ProductMajorVersion.Value, "Version") &lt; 14, Nothing,"EncryptedDatabaseInfo"))
, Fields!MenuItem.Value = "Failed Logins" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,"FailedLogins")
, Fields!MenuItem.Value = "Login Last Password Change" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,"LoginLastChangePassword")
, Fields!MenuItem.Value = "Guest Account Permissions and Status (D)" ,"GuessAccountPermissions"
, Fields!MenuItem.Value = "Schema Owners w\Number of Objects" ,"SchemaOwners"
, Fields!MenuItem.Value = "Schema Objects" ,"SchemaObjects"
, Fields!MenuItem.Value = "Guest Account Status All Databases" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,"GuestAccountStatusAllDatabases")
, Fields!MenuItem.Value = "Linked Server Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,"LinkedServerInformation")
, Fields!MenuItem.Value = "Login Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,IIF(Sum(Fields!VersionOfSQLServer.Value, "Version")&lt;= 10, Nothing, "LoginInformation"))
, Fields!MenuItem.Value = "Procedures With Execute As   (D)" ,"StoredProcsWithExecuteAs"
, Fields!MenuItem.Value = "Proxy Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,"ProxyInformation")
, Fields!MenuItem.Value = "Public Role Permissions  (D)" ,"PublicRolePermissions"
, Fields!MenuItem.Value = "SA Audit and Password Review" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,"SAAuditPasswordReview")
, Fields!MenuItem.Value = "Security Policy Information" ,"SecurityPolicyInformation"
, Fields!MenuItem.Value = "Dropped Logins", Microsoft.VisualBasic.Interaction.IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing, IIF(First(Fields!DBExists.Value, "AdminMonitorExists") = 0, Nothing,"DroppedLoginsPast30Days"))
, Fields!MenuItem.Value = "Dropped DB Users", Microsoft.VisualBasic.Interaction.IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing, IIF(First(Fields!DBExists.Value, "AdminMonitorExists") = 0, Nothing,"DatabaseUsersDeletedPast30Days"))
, Fields!MenuItem.Value = "Server Audit Specification Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,"ServerAuditInformation")
, Fields!MenuItem.Value = "Server Permissions other than Connect" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,"ServerPermissionsOtherThanConnect")
, Fields!MenuItem.Value = "Server Role Information and Membership" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing,"ServerRoleMembers")
, Fields!MenuItem.Value = "Users DMLRights other than SELECT (D)" ,"UsersWithDMLRightsOtherThanSELECT"
)</ReportName>
                            </Drillthrough>
                          </Action>
                        </Actions>
                      </ActionInfo>
                      <Style>
                        <Border>
                          <Color>LightGrey</Color>
                          <Style>Solid</Style>
                        </Border>
                        <BackgroundColor>=IIF(ROWNUMBER(NOTHING) MOD 2, "LIGHTBLUE", "SILVER")</BackgroundColor>
                        <VerticalAlign>Middle</VerticalAlign>
                        <PaddingLeft>4pt</PaddingLeft>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                        <PaddingBottom>2pt</PaddingBottom>
                      </Style>
                    </Textbox>
                  </CellContents>
                </TablixCell>
              </TablixCells>
            </TablixRow>
            <TablixRow>
              <Height>0.73833in</Height>
              <TablixCells>
                <TablixCell>
                  <CellContents>
                    <Textbox Name="Textbox56">
                      <CanGrow>true</CanGrow>
                      <KeepTogether>true</KeepTogether>
                      <Paragraphs>
                        <Paragraph>
                          <TextRuns>
                            <TextRun>
                              <Value>Please Test Before Running in Production</Value>
                              <Style>
                                <FontSize>14pt</FontSize>
                                <Color>White</Color>
                              </Style>
                            </TextRun>
                          </TextRuns>
                          <Style>
                            <TextAlign>Center</TextAlign>
                          </Style>
                        </Paragraph>
                      </Paragraphs>
                      <rd:DefaultName>Textbox56</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>LightGrey</Color>
                          <Style>Solid</Style>
                        </Border>
                        <BackgroundColor>DarkBlue</BackgroundColor>
                        <VerticalAlign>Middle</VerticalAlign>
                        <PaddingLeft>4pt</PaddingLeft>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                        <PaddingBottom>2pt</PaddingBottom>
                      </Style>
                    </Textbox>
                  </CellContents>
                </TablixCell>
              </TablixCells>
            </TablixRow>
            <TablixRow>
              <Height>0.60001in</Height>
              <TablixCells>
                <TablixCell>
                  <CellContents>
                    <Textbox Name="Textbox4">
                      <CanGrow>true</CanGrow>
                      <KeepTogether>true</KeepTogether>
                      <Paragraphs>
                        <Paragraph>
                          <TextRuns>
                            <TextRun>
                              <Value>="SQL Servrer Major Version: " &amp; First(Fields!ProductMajorVersion.Value, "Version")</Value>
                              <Style>
                                <FontSize>14pt</FontSize>
                                <Color>White</Color>
                              </Style>
                            </TextRun>
                          </TextRuns>
                          <Style>
                            <TextAlign>Center</TextAlign>
                          </Style>
                        </Paragraph>
                      </Paragraphs>
                      <rd:DefaultName>Textbox4</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>LightGrey</Color>
                          <Style>Solid</Style>
                        </Border>
                        <BackgroundColor>DarkBlue</BackgroundColor>
                        <VerticalAlign>Middle</VerticalAlign>
                        <PaddingLeft>4pt</PaddingLeft>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                        <PaddingBottom>2pt</PaddingBottom>
                      </Style>
                    </Textbox>
                  </CellContents>
                </TablixCell>
              </TablixCells>
            </TablixRow>
          </TablixRows>
        </TablixBody>
        <TablixColumnHierarchy>
          <TablixMembers>
            <TablixMember />
          </TablixMembers>
        </TablixColumnHierarchy>
        <TablixRowHierarchy>
          <TablixMembers>
            <TablixMember>
              <KeepWithGroup>After</KeepWithGroup>
            </TablixMember>
            <TablixMember>
              <Group Name="Details5" />
            </TablixMember>
            <TablixMember>
              <KeepWithGroup>Before</KeepWithGroup>
            </TablixMember>
            <TablixMember>
              <KeepWithGroup>Before</KeepWithGroup>
            </TablixMember>
          </TablixMembers>
        </TablixRowHierarchy>
        <DataSetName>Security</DataSetName>
        <Top>2.33028in</Top>
        <Left>11.70515in</Left>
        <Height>1.96389in</Height>
        <Width>3.41929in</Width>
        <ZIndex>9</ZIndex>
        <Style>
          <Border>
            <Style>Solid</Style>
          </Border>
        </Style>
      </Tablix>
      <Tablix Name="Tablix6">
        <TablixBody>
          <TablixColumns>
            <TablixColumn>
              <Width>3.40541in</Width>
            </TablixColumn>
          </TablixColumns>
          <TablixRows>
            <TablixRow>
              <Height>0.31563in</Height>
              <TablixCells>
                <TablixCell>
                  <CellContents>
                    <Textbox Name="Textbox21">
                      <CanGrow>true</CanGrow>
                      <KeepTogether>true</KeepTogether>
                      <Paragraphs>
                        <Paragraph>
                          <TextRuns>
                            <TextRun>
                              <Value>Monitor Reports</Value>
                              <Style>
                                <FontSize>14pt</FontSize>
                                <Color>White</Color>
                              </Style>
                            </TextRun>
                          </TextRuns>
                          <Style>
                            <TextAlign>Center</TextAlign>
                          </Style>
                        </Paragraph>
                      </Paragraphs>
                      <rd:DefaultName>Textbox20</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>LightGrey</Color>
                          <Style>Solid</Style>
                        </Border>
                        <BackgroundColor>DarkBlue</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.35785in</Height>
              <TablixCells>
                <TablixCell>
                  <CellContents>
                    <Textbox Name="MenuItem7">
                      <CanGrow>true</CanGrow>
                      <KeepTogether>true</KeepTogether>
                      <Paragraphs>
                        <Paragraph>
                          <TextRuns>
                            <TextRun>
                              <Value>=Microsoft.VisualBasic.Interaction.Switch(Fields!MenuItem.Value = "Perf. Counters Last 120 Min", Microsoft.VisualBasic.Interaction.IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA",IIF(First(Fields!DBExists.Value, "AdminMonitorExists") = 0, "AdminMonitor DB Does not Exist","Perf. Counters"))
, Fields!MenuItem.Value = "Waits Last 120 Min", Microsoft.VisualBasic.Interaction.IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA", IIF(First(Fields!DBExists.Value, "AdminMonitorExists") = 0, "AdminMonitor DB Does not Exist","SQL Server Waits"))
, Fields!MenuItem.Value = "Read Write Latency Last 120 Min", Microsoft.VisualBasic.Interaction.IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA", IIF(First(Fields!DBExists.Value, "AdminMonitorExists") = 0, "AdminMonitor DB Does not Exist","ReadWrite Latency"))
, Fields!MenuItem.Value = "Windows Performance Counters", Microsoft.VisualBasic.Interaction.IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA", IIF(First(Fields!DBExists.Value, "AdminMonitorExists") = 0, "AdminMonitor DB Does not Exist","Windows Performance Counters"))
, Fields!MenuItem.Value = "Deadlock Information", Microsoft.VisualBasic.Interaction.IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA", IIF(First(Fields!DBExists.Value, "AdminMonitorExists") = 0, "AdminMonitor DB Does not Exist","Deadlock Information"))
, Fields!MenuItem.Value = "Blocking Information", Microsoft.VisualBasic.Interaction.IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA", IIF(First(Fields!DBExists.Value, "AdminMonitorExists") = 0, "AdminMonitor DB Does not Exist","Blocking Information"))
, Fields!MenuItem.Value = "Server Activity", Microsoft.VisualBasic.Interaction.IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA", IIF(First(Fields!DBExists.Value, "AdminMonitorExists") = 0, "AdminMonitor DB Does not Exist","Server Activity"))
, Fields!MenuItem.Value = "Query Timeouts by Time Period", Microsoft.VisualBasic.Interaction.IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA", IIF(First(Fields!DBExists.Value, "AdminMonitorExists") = 0, "AdminMonitor DB Does not Exist","Query Timeouts by Time Period"))
, Fields!MenuItem.Value = "Query Timeout Detail Past 60\Min.", Microsoft.VisualBasic.Interaction.IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA", IIF(First(Fields!DBExists.Value, "AdminMonitorExists") = 0, "AdminMonitor DB Does not Exist","Query Timeout Detail Past 60\Min."))
, Fields!MenuItem.Value = "Database Growth", Microsoft.VisualBasic.Interaction.IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA", IIF(First(Fields!DBExists.Value, "AdminMonitorExists") = 0, "AdminMonitor DB Does not Exist","Database Growth"))
, Fields!MenuItem.Value = "Monitor Configuration", Microsoft.VisualBasic.Interaction.IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA", IIF(First(Fields!DBExists.Value, "AdminMonitorExists") = 0, "AdminMonitor DB Does not Exist","Monitor Configuration"))
, Fields!MenuItem.Value = "Baseline History", Microsoft.VisualBasic.Interaction.IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA", IIF(First(Fields!DBExists.Value, "AdminMonitorExists") = 0, "AdminMonitor DB Does not Exist","Baseline History"))
, Fields!MenuItem.Value = "Deploy Monitor DB", Microsoft.VisualBasic.Interaction.IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA", IIF(First(Fields!DBExists.Value, "AdminMonitorExists") = 0, "Deploy Monitor DB","AdminMonitor Already Exists"))
, Fields!MenuItem.Value = "View Monitor Solution Code", Microsoft.VisualBasic.Interaction.IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA", "View Monitor Solution Code")
, Fields!MenuItem.Value = "Monitor Solution Directions", Microsoft.VisualBasic.Interaction.IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA", "Monitor Solution Directions")
, Fields!MenuItem.Value = "Monitor Help" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA","Monitor Help")
, Fields!MenuItem.Value = "Deploy Part of Monitor Solution", Microsoft.VisualBasic.Interaction.IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "Azure DB - NA", "Deploy Part of Monitor Solution"))</Value>
                              <Style>
                                <FontSize>14pt</FontSize>
                                <Color>=Switch(
  Fields!MenuItem.Value = "Perf. Counters Last 120 Min" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray",IIF(First(Fields!DBExists.Value, "AdminMonitorExists") = 0,"DarkGray","Black"))
, Fields!MenuItem.Value = "Waits Last 120 Min" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray",IIF(First(Fields!DBExists.Value, "AdminMonitorExists") = 0, "DarkGray","Black"))
, Fields!MenuItem.Value = "Read Write Latency Last 120 Min" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray",IIF(First(Fields!DBExists.Value, "AdminMonitorExists") = 0, "DarkGray","Black"))
, Fields!MenuItem.Value = "Windows Performance Counters" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray",IIF(First(Fields!DBExists.Value, "AdminMonitorExists") = 0, "DarkGray","Black"))
, Fields!MenuItem.Value = "Deadlock Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray",IIF(First(Fields!DBExists.Value, "AdminMonitorExists") = 0, "DarkGray","Black"))
, Fields!MenuItem.Value = "Blocking Information" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray",IIF(First(Fields!DBExists.Value, "AdminMonitorExists") = 0, "DarkGray","Black"))
, Fields!MenuItem.Value = "Server Activity" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray",IIF(First(Fields!DBExists.Value, "AdminMonitorExists") = 0, "DarkGray","Black"))
, Fields!MenuItem.Value = "Query Timeouts by Time Period" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray",IIF(First(Fields!DBExists.Value, "AdminMonitorExists") = 0, "DarkGray","Black"))
, Fields!MenuItem.Value = "Query Timeout Detail Past 60\Min." ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray",IIF(First(Fields!DBExists.Value, "AdminMonitorExists") = 0, "DarkGray","Black"))
, Fields!MenuItem.Value = "Baseline History" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray",IIF(First(Fields!DBExists.Value, "AdminMonitorExists") = 0, "DarkGray","Black"))
, Fields!MenuItem.Value = "Database Growth" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray",IIF(First(Fields!DBExists.Value, "AdminMonitorExists") = 0, "DarkGray","Black"))
, Fields!MenuItem.Value = "Monitor Configuration" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray",IIF(First(Fields!DBExists.Value, "AdminMonitorExists") = 0, "DarkGray","Black"))
, Fields!MenuItem.Value = "Monitor Help" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray","Black")
, Fields!MenuItem.Value = "Deploy Monitor DB" ,IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DarkGray",IIF(First(Fields!DBExists.Value, "AdminMonitorExists") = 0, "Black","DarkGray")))</Color>
                              </Style>
                            </TextRun>
                          </TextRuns>
                          <Style>
                            <TextAlign>Left</TextAlign>
                          </Style>
                        </Paragraph>
                      </Paragraphs>
                      <rd:DefaultName>MenuItem1</rd:DefaultName>
                      <ActionInfo>
                        <Actions>
                          <Action>
                            <Drillthrough>
                              <ReportName>=Microsoft.VisualBasic.Interaction.Switch(Fields!MenuItem.Value = "Perf. Counters Last 120 Min", Microsoft.VisualBasic.Interaction.IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing, IIF(First(Fields!DBExists.Value, "AdminMonitorExists") = 0,Nothing,"MonitorCallPerfCounterReport"))
, Fields!MenuItem.Value = "Waits Last 120 Min", Microsoft.VisualBasic.Interaction.IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing, IIF(First(Fields!DBExists.Value, "AdminMonitorExists") = 0, Nothing,"MonitorCallWaitreport"))
, Fields!MenuItem.Value = "Read Write Latency Last 120 Min", Microsoft.VisualBasic.Interaction.IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing, IIF(First(Fields!DBExists.Value, "AdminMonitorExists") = 0, Nothing,"MonitorCallReadWriteLatency"))
, Fields!MenuItem.Value = "Windows Performance Counters", Microsoft.VisualBasic.Interaction.IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing, IIF(First(Fields!DBExists.Value, "AdminMonitorExists") = 0, Nothing,"MonitorWindowsCountersTimeWindow"))
, Fields!MenuItem.Value = "Deadlock Information", Microsoft.VisualBasic.Interaction.IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing, IIF(First(Fields!DBExists.Value, "AdminMonitorExists") = 0, Nothing,"MonitorCallDeadlockReports"))
, Fields!MenuItem.Value = "Blocking Information", Microsoft.VisualBasic.Interaction.IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing, IIF(First(Fields!DBExists.Value, "AdminMonitorExists") = 0, Nothing,"MonitorCallBlockingReports"))
, Fields!MenuItem.Value = "Server Activity", Microsoft.VisualBasic.Interaction.IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing, IIF(First(Fields!DBExists.Value, "AdminMonitorExists") = 0, Nothing,"MonitorCallServerActivity"))
, Fields!MenuItem.Value = "Query Timeouts by Time Period", Microsoft.VisualBasic.Interaction.IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing, IIF(First(Fields!DBExists.Value, "AdminMonitorExists") = 0, Nothing,"MonitorCallQueryTimeoutReport"))
, Fields!MenuItem.Value = "Query Timeout Detail Past 60\Min.", Microsoft.VisualBasic.Interaction.IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing, IIF(First(Fields!DBExists.Value, "AdminMonitorExists") = 0, Nothing,"MonitorQueryTimeoutDetailPast90Min"))
, Fields!MenuItem.Value = "Database Growth", Microsoft.VisualBasic.Interaction.IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing, IIF(First(Fields!DBExists.Value, "AdminMonitorExists") = 0, Nothing,"MonitorCallDatabaseGrowth"))
, Fields!MenuItem.Value = "Monitor Configuration", Microsoft.VisualBasic.Interaction.IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing, IIF(First(Fields!DBExists.Value, "AdminMonitorExists") = 0, Nothing,"MonitorConfiguration"))
, Fields!MenuItem.Value = "Baseline History", Microsoft.VisualBasic.Interaction.IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing, IIF(First(Fields!DBExists.Value, "AdminMonitorExists") = 0, Nothing,"BaselineHistory"))
, Fields!MenuItem.Value = "Deploy Monitor DB", Microsoft.VisualBasic.Interaction.IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing, IIF(First(Fields!DBExists.Value, "AdminMonitorExists") = 0, "MonitorAreYouSure",NOthing))
, Fields!MenuItem.Value = "View Monitor Solution Code", Microsoft.VisualBasic.Interaction.IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing, "MonitorViewMonitorCode")
, Fields!MenuItem.Value = "Monitor Solution Directions", Microsoft.VisualBasic.Interaction.IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing, "MonitorDirections")
, Fields!MenuItem.Value = "Monitor Help", Microsoft.VisualBasic.Interaction.IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing, "MonitorHelp")

, Fields!MenuItem.Value = "Deploy Part of Monitor Solution", Microsoft.VisualBasic.Interaction.IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing, "MonitorAreYouSure"))</ReportName>
                            </Drillthrough>
                          </Action>
                        </Actions>
                      </ActionInfo>
                      <Style>
                        <Border>
                          <Color>LightGrey</Color>
                          <Style>Solid</Style>
                        </Border>
                        <BackgroundColor>=IIF(ROWNUMBER(NOTHING) MOD 2, "LIGHTBLUE", "SILVER")</BackgroundColor>
                        <VerticalAlign>Middle</VerticalAlign>
                        <PaddingLeft>4pt</PaddingLeft>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                        <PaddingBottom>2pt</PaddingBottom>
                      </Style>
                    </Textbox>
                  </CellContents>
                </TablixCell>
              </TablixCells>
            </TablixRow>
          </TablixRows>
        </TablixBody>
        <TablixColumnHierarchy>
          <TablixMembers>
            <TablixMember />
          </TablixMembers>
        </TablixColumnHierarchy>
        <TablixRowHierarchy>
          <TablixMembers>
            <TablixMember>
              <KeepWithGroup>After</KeepWithGroup>
            </TablixMember>
            <TablixMember>
              <Group Name="Details7" />
            </TablixMember>
          </TablixMembers>
        </TablixRowHierarchy>
        <DataSetName>PerformanceReports</DataSetName>
        <Top>1.58735in</Top>
        <Left>11.71903in</Left>
        <Height>0.67348in</Height>
        <Width>3.40541in</Width>
        <ZIndex>10</ZIndex>
        <Style>
          <Border>
            <Style>Solid</Style>
          </Border>
        </Style>
      </Tablix>
      <Textbox Name="Textbox5">
        <CanGrow>true</CanGrow>
        <KeepTogether>true</KeepTogether>
        <Paragraphs>
          <Paragraph>
            <TextRuns>
              <TextRun>
                <Value>####</Value>
                <Style>
                  <FontSize>12pt</FontSize>
                  <Color>Silver</Color>
                </Style>
              </TextRun>
              <TextRun>
                <Value xml:space="preserve">  </Value>
                <Style>
                  <FontSize>12pt</FontSize>
                  <Color>White</Color>
                </Style>
              </TextRun>
              <TextRun>
                <Value>When Viewing a report Right Click anywhere on the Report to Export to Excel ####</Value>
                <Style>
                  <FontSize>12pt</FontSize>
                  <Color>Silver</Color>
                </Style>
              </TextRun>
            </TextRuns>
            <Style>
              <TextAlign>Center</TextAlign>
            </Style>
          </Paragraph>
        </Paragraphs>
        <rd:DefaultName>Textbox5</rd:DefaultName>
        <Top>1.19389in</Top>
        <Left>0.09126in</Left>
        <Height>0.36112in</Height>
        <Width>15.14708in</Width>
        <ZIndex>11</ZIndex>
        <Style>
          <Border>
            <Style>None</Style>
          </Border>
          <BackgroundColor>DarkBlue</BackgroundColor>
          <VerticalAlign>Middle</VerticalAlign>
          <PaddingLeft>2pt</PaddingLeft>
          <PaddingRight>2pt</PaddingRight>
          <PaddingTop>2pt</PaddingTop>
          <PaddingBottom>2pt</PaddingBottom>
        </Style>
      </Textbox>
    </ReportItems>
    <Height>6.68194in</Height>
    <Style>
      <BackgroundColor>LightGrey</BackgroundColor>
    </Style>
  </Body>
  <Width>15.32738in</Width>
  <Page>
    <PageHeight>36in</PageHeight>
    <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>fc4871ee-3b1b-4994-adb8-963a294b9b95</rd:DataSourceID>
    </DataSource>
  </DataSources>
  <DataSets>
    <DataSet Name="Version">
      <Query>
        <DataSourceName>Local</DataSourceName>
        <CommandText>SELECT CONVERT(VARCHAR(20), SERVERPROPERTY('productversion')) AS 'Version', CONVERT(VARCHAR(20), SERVERPROPERTY('productlevel')) AS 'ProductLevel', SERVERPROPERTY('edition') AS 'Edition', Serverproperty('ResourceVersion') 
                  AS 'ResourceVersion'			  
, serverproperty('ProductMajorversion') AS 'ProductMajorVersion'
, Case WHEN Convert(decimal(3,1),serverproperty('ProductMajorversion')) = 16 THEN 2022
WHEN Convert(decimal(3,1),serverproperty('ProductMajorversion')) = 15 THEN 2019
 WHEN Convert(decimal(3,1),serverproperty('ProductMajorversion')) = 14 THEN 2017
  WHEN Convert(decimal(3,1),serverproperty('ProductMajorversion')) = 13 THEN 2016
   WHEN Convert(decimal(3,1),serverproperty('ProductMajorversion')) = 12 THEN 2014
    WHEN Convert(decimal(3,1),serverproperty('ProductMajorversion')) = 11 THEN 2012
	 WHEN Convert(decimal(3,1),serverproperty('ProductMajorversion')) = 10.5 THEN '2008r2'
	  WHEN Convert(decimal(3,1),serverproperty('ProductMajorversion')) = 10.0 THEN '2008'
end AS 'VersionOfSQLServer'
, CHARINDEX('Developer',CONVERT(varchar(100),SERVERPROPERTY('edition'))) AS 'ISDeveloper?'</CommandText>
      </Query>
      <Fields>
        <Field Name="Version">
          <DataField>Version</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="ProductLevel">
          <DataField>ProductLevel</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="Edition">
          <DataField>Edition</DataField>
          <rd:TypeName>System.Object</rd:TypeName>
        </Field>
        <Field Name="ResourceVersion">
          <DataField>ResourceVersion</DataField>
          <rd:TypeName>System.Object</rd:TypeName>
        </Field>
        <Field Name="ProductMajorVersion">
          <DataField>ProductMajorVersion</DataField>
          <rd:TypeName>System.Object</rd:TypeName>
        </Field>
        <Field Name="VersionOfSQLServer">
          <DataField>VersionOfSQLServer</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
        <Field Name="ISDeveloper_">
          <DataField>ISDeveloper?</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>
    <DataSet Name="DatabaseName">
      <Query>
        <DataSourceName>Local</DataSourceName>
        <CommandText>SELECT DB_NAME() DatabaseName</CommandText>
      </Query>
      <Fields>
        <Field Name="DatabaseName">
          <DataField>DatabaseName</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
      </Fields>
    </DataSet>
    <DataSet Name="CurrentState">
      <Query>
        <DataSourceName>Local</DataSourceName>
        <CommandText>CREATE TABLE #CurStateMenu
			(MenuItem VARCHAR(100))

INSERT INTO #CurStateMenu
SELECT 
'Processes' AS 'Topic'

INSERT INTO #CurStateMenu
SELECT 
'IOStalls' AS 'Topic'


INSERT INTO #CurStateMenu
SELECT 
'CPU Utilization' AS 'Topic'


INSERT INTO #CurStateMenu
SELECT 
'Open Transactions' AS 'Topic'



INSERT INTO #CurStateMenu
SELECT 
'What is Using the TempDB with Code' AS 'Topic'




INSERT INTO #CurStateMenu
SELECT 
'Read Write Latency' AS 'Topic'

/*
INSERT INTO #CurStateMenu
SELECT 
'Wait Information' AS 'Topic'
*/

INSERT INTO #CurStateMenu
SELECT 
'Why is the Log Not Clearing' AS 'Topic'


INSERT INTO #CurStateMenu
SELECT 
'Any Running Jobs' AS 'Topic'

INSERT INTO #CurStateMenu
SELECT 
'Target and Total Memory 5 Minutes' AS 'Topic'

INSERT INTO #CurStateMenu
SELECT 
'Page Life Expectancy 5 Minutes' AS 'Topic'

INSERT INTO #CurStateMenu
SELECT 
'Lazy Writes\Sec 5 Minutes' AS 'Topic'

INSERT INTO #CurStateMenu
SELECT 
'Memory Grants Pending 5 Minutes' AS 'Topic'

INSERT INTO #CurStateMenu
SELECT 
'Checkpoint pages/sec 90 Seconds' AS 'Topic'

INSERT INTO #CurStateMenu
SELECT 
'Page Reads/sec 5 Minutes' AS 'Topic'

SELECT * FROM #CurStateMenu
ORDER BY MenuItem

DROP TABLE #CurStateMenu</CommandText>
      </Query>
      <Fields>
        <Field Name="MenuItem">
          <DataField>MenuItem</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
      </Fields>
    </DataSet>
    <DataSet Name="JobsAlertsOperators">
      <Query>
        <DataSourceName>Local</DataSourceName>
        <CommandText>CREATE TABLE #JobMenu
			(MenuItem VARCHAR(100))



INSERT INTO #JobMenu
SELECT 
'Job Failures Last 30 Days' AS 'Topic'

INSERT INTO #JobMenu
SELECT 
'JobHistory24Hours' AS 'Topic'


INSERT INTO #JobMenu
SELECT 
'Job Schedules' AS 'Topic'

INSERT INTO #JobMenu
SELECT 
'Jobs Running Longer Than Average' AS 'Topic'


INSERT INTO #JobMenu
SELECT 
'JobExecuteTime' AS 'Topic'

INSERT INTO #JobMenu
SELECT 
'Job History' AS 'Topic'

INSERT INTO #JobMenu
SELECT 
'Job Step Retries Past 24 hours' AS 'Topic'


INSERT INTO #JobMenu
SELECT 
'Currently Running Jobs' AS 'Topic'



INSERT INTO #JobMenu
SELECT 
'Job Failure Rate Past 90 Days' AS 'Topic'


INSERT INTO #JobMenu
SELECT 
'Jobs Using Schedules' AS 'Topic'


INSERT INTO #JobMenu
SELECT 
'Operator Information' AS 'Topic'


INSERT INTO #JobMenu
SELECT 
'Job Information' AS 'Topic'


INSERT INTO #JobMenu
SELECT 
'Job Step Information' AS 'Topic'


INSERT INTO #JobMenu
SELECT 
'Auto Delete Jobs' AS 'Topic'


INSERT INTO #JobMenu
SELECT 
'Alert Information' AS 'Topic'


INSERT INTO #JobMenu
SELECT 
'Jobs with No Configured Notification' AS 'Topic'


INSERT INTO #JobMenu
SELECT 
'SQL Server Agent Properties' AS 'Topic'


SELECT * FROM #JobMenu
ORDER BY MenuItem

DROP TABLE #JobMenu</CommandText>
      </Query>
      <Fields>
        <Field Name="MenuItem">
          <DataField>MenuItem</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
      </Fields>
    </DataSet>
    <DataSet Name="MemoryItems">
      <Query>
        <DataSourceName>Local</DataSourceName>
        <CommandText>CREATE TABLE #MemoryMenu
			(MenuItem VARCHAR(100))



INSERT INTO #MemoryMenu
SELECT 
'Memory Settings and Counters' AS 'Topic'


INSERT INTO #MemoryMenu
SELECT 
'Buffer Pool Usage For Objects' AS 'Topic'

INSERT INTO #MemoryMenu
SELECT 
'Additional Memory Counters' AS 'Topic'


INSERT INTO #MemoryMenu
SELECT 
'Connection Count and Memory Used' AS 'Topic'

INSERT INTO #MemoryMenu
SELECT 
'Memory Dump File Information' AS 'Topic'

INSERT INTO #MemoryMenu
SELECT 
'Buffer Pool Usage' AS 'Topic'

INSERT INTO #MemoryMenu
SELECT 
'Memory Grants Pending' AS 'Topic'

INSERT INTO #MemoryMenu
SELECT 
'Spills To TempDB' AS 'Topic'

SELECT * FROM #MemoryMenu
ORDER BY MenuItem

DROP TABLE #MemoryMenu</CommandText>
      </Query>
      <Fields>
        <Field Name="MenuItem">
          <DataField>MenuItem</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
      </Fields>
    </DataSet>
    <DataSet Name="DatabaseInformation">
      <Query>
        <DataSourceName>Local</DataSourceName>
        <CommandText>CREATE TABLE #DatabaseConfigMenu
			(MenuItem VARCHAR(100))

INSERT INTO #DatabaseConfigMenu
SELECT 
'Database Virtual Log Files' AS 'Topic'

INSERT INTO #DatabaseConfigMenu
SELECT 
'Database File Growths' AS 'Topic'


INSERT INTO #DatabaseConfigMenu
SELECT 
'Database File Growth Settings' AS 'Topic'

INSERT INTO #DatabaseConfigMenu
SELECT 
'Database File GrowthsEE' AS 'Topic'

INSERT INTO #DatabaseConfigMenu
SELECT 
'DatabaseObjectsChanged' AS 'Topic'

INSERT INTO #DatabaseConfigMenu
SELECT 
'Databases Deleted' AS 'Topic'

INSERT INTO #DatabaseConfigMenu
SELECT 
'View List' AS 'Topic'

INSERT INTO #DatabaseConfigMenu
SELECT 
'Table List' AS 'Topic'

INSERT INTO #DatabaseConfigMenu
SELECT 
'Databases Using the Version Store' AS 'Topic'


INSERT INTO #DatabaseConfigMenu
SELECT 
'StoredProcList' AS 'Topic'


INSERT INTO #DatabaseConfigMenu
SELECT 
'TempDB  Information' AS 'Topic'

INSERT INTO #DatabaseConfigMenu
SELECT 
'Synonym Information  (D)' AS 'Topic'

INSERT INTO #DatabaseConfigMenu
SELECT 
'CDC Tables' AS 'Topic'

INSERT INTO #DatabaseConfigMenu
SELECT 
'Change Tracking Tables (D)' AS 'Topic'

INSERT INTO #DatabaseConfigMenu
SELECT 
'CheckDB Status' AS 'Topic'

INSERT INTO #DatabaseConfigMenu
SELECT 
'Table Row Counts and Size  (D)' AS 'Topic'

INSERT INTO #DatabaseConfigMenu
SELECT 
'Statistics Information  (D)' AS 'Topic'

INSERT INTO #DatabaseConfigMenu
SELECT 
'Forwarded Records   (D)' AS 'Topic'





INSERT INTO #DatabaseConfigMenu
SELECT 
'Index Fragmentation   (D)' AS 'Topic'

INSERT INTO #DatabaseConfigMenu
SELECT 
'Database Auto Settings' AS 'Topic'


INSERT INTO #DatabaseConfigMenu
SELECT 
'Database Snapshot Information' AS 'Topic'



INSERT INTO #DatabaseConfigMenu
SELECT 
'Tables Created or Modified Last 90 Days  (D)' AS 'Topic'

INSERT INTO #DatabaseConfigMenu
SELECT 
'Database Filegroup Information' AS 'Topic'

INSERT INTO #DatabaseConfigMenu
SELECT 
'Index To Column Ratio by Table  (D)' AS 'Topic'

INSERT INTO #DatabaseConfigMenu
SELECT 
'Database File Size\Space Used' AS 'Topic'

INSERT INTO #DatabaseConfigMenu
SELECT 
'Plan Guides' AS 'Topic'


INSERT INTO #DatabaseConfigMenu
SELECT 
'Stored Procs Created or Modified Last 90 Days  (D)' AS 'Topic'

INSERT INTO #DatabaseConfigMenu
SELECT 
'Index Information  (D)' AS 'Topic'

INSERT INTO #DatabaseConfigMenu
SELECT 
'Index Fragmentation for an Object   (D)' AS 'Topic'

INSERT INTO #DatabaseConfigMenu
SELECT 
'CDC and Change Tracking Status' AS 'Topic'

INSERT INTO #DatabaseConfigMenu
SELECT 
'Databases Not in Offline\Online State' AS 'Topic'

INSERT INTO #DatabaseConfigMenu
SELECT 
'Tables That are Heaps   (D)' AS 'Topic'

INSERT INTO #DatabaseConfigMenu
SELECT 
'Queries with High Logical Reads  (D)' AS 'Topic'



INSERT INTO #DatabaseConfigMenu
SELECT 
'Queries with High Physical Reads  (D)' AS 'Topic'



INSERT INTO #DatabaseConfigMenu
SELECT 
'Database Information(Stats Settings\Compat Level)' AS 'Topic'

INSERT INTO #DatabaseConfigMenu
SELECT 
'Database Settings' AS 'Topic'

INSERT INTO #DatabaseConfigMenu
SELECT 
'Computed Columns in Database (D)' AS 'Topic'

INSERT INTO #DatabaseConfigMenu
SELECT 
'Views Created or Modified Last 90 Days   (D)' AS 'Topic'


INSERT INTO #DatabaseConfigMenu
SELECT 
'Compressed Objects   (D)' AS 'Topic'

INSERT INTO #DatabaseConfigMenu
SELECT 
'Column List for Current Databases  (D)' AS 'Topic'

INSERT INTO #DatabaseConfigMenu
SELECT 
'Database File Information' AS 'Topic'

INSERT INTO #DatabaseConfigMenu
SELECT 
'Query Store Status and Settings' AS 'Topic'

INSERT INTO #DatabaseConfigMenu
SELECT 
'Database Triggers   (D)' AS 'Topic'

INSERT INTO #DatabaseConfigMenu
SELECT 
'Database Functions   (D)' AS 'Topic'

INSERT INTO #DatabaseConfigMenu
SELECT 
'User Defined Data Types   (D)' AS 'Topic'



INSERT INTO #DatabaseConfigMenu
SELECT 
'Full Text Index Info.  (D)' AS 'Topic'

INSERT INTO #DatabaseConfigMenu
SELECT 
'Default Constraint Info.  (D)' AS 'Topic'

INSERT INTO #DatabaseConfigMenu
SELECT 
'User Defined Data Type Usage  (D)' AS 'Topic'

INSERT INTO #DatabaseConfigMenu
SELECT 
'Azure Database Resource Stats' AS 'Topic'


INSERT INTO #DatabaseConfigMenu
SELECT 
'Database Autotune Settings' AS 'Topic'


INSERT INTO #DatabaseConfigMenu
SELECT 
'Memory Optimized Tables' AS 'Topic'

INSERT INTO #DatabaseConfigMenu
SELECT 
'Stored Procedures that start with SP_' AS 'Topic'

INSERT INTO #DatabaseConfigMenu
SELECT 
'Dynamic Masked Columns' AS 'Topic'

INSERT INTO #DatabaseConfigMenu
SELECT 
'Partitioned Tables' AS 'Topic'

INSERT INTO #DatabaseConfigMenu
SELECT 
'Column Store Index Information'

INSERT INTO #DatabaseConfigMenu
SELECT 
'Stored Procs with Recompile'

INSERT INTO #DatabaseConfigMenu
SELECT 
'Plans with Implicit Converts'

INSERT INTO #DatabaseConfigMenu
SELECT 
'Duplicate Indexes'

INSERT INTO #DatabaseConfigMenu
SELECT 
'Orphan Database Users'

INSERT INTO #DatabaseConfigMenu
SELECT 
'Columns with BLOB data types'

INSERT INTO #DatabaseConfigMenu
SELECT 
'Stored Procs with a SELECT *'

INSERT INTO #DatabaseConfigMenu
SELECT 
'Stored Procs with a CURSOR'

INSERT INTO #DatabaseConfigMenu
SELECT 
'Index Usage'

INSERT INTO #DatabaseConfigMenu
SELECT 
'Indexes that Are Unused'

INSERT INTO #DatabaseConfigMenu
SELECT 
'Nonsargable Searches in Stored Procs'

INSERT INTO #DatabaseConfigMenu
SELECT 
'Stored Procs with Deadlock Priority Set'

INSERT INTO #DatabaseConfigMenu
SELECT 
'Stored Procs with NOCOUNT set to OFF'

INSERT INTO #DatabaseConfigMenu
SELECT 
'Temporal Table Information'

INSERT INTO #DatabaseConfigMenu
SELECT 
'Objects with Schemabinding'

INSERT INTO #DatabaseConfigMenu
SELECT 
'Stretch Database Information'

INSERT INTO #DatabaseConfigMenu
SELECT 
'Contained Database Information'

INSERT INTO #DatabaseConfigMenu
SELECT 
'Contained Database Users'

SELECT * FROM #DatabaseConfigMenu
ORDER BY MenuItem

DROP TABLE #DatabaseConfigMenu</CommandText>
      </Query>
      <Fields>
        <Field Name="MenuItem">
          <DataField>MenuItem</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
      </Fields>
    </DataSet>
    <DataSet Name="ServerInformation">
      <Query>
        <DataSourceName>Local</DataSourceName>
        <CommandText>CREATE TABLE #ServerMenu
			(MenuItem VARCHAR(100))

INSERT INTO #ServerMenu
SELECT 
'Server Triggers' AS 'Topic'

INSERT INTO #ServerMenu
SELECT 
'Performance Counters Installed' AS 'Topic'

INSERT INTO #ServerMenu
SELECT 
'Trace Flags Startup' AS 'Topic'

INSERT INTO #ServerMenu
SELECT 
'Extended Events Information' AS 'Topic'

INSERT INTO #ServerMenu
SELECT 
'OS Power Plan Setting' AS 'Topic'

INSERT INTO #ServerMenu
SELECT 
'Trace Flags Enabled' AS 'Topic'


INSERT INTO #ServerMenu
SELECT 
'Trace Information' AS 'Topic'



INSERT INTO #ServerMenu
SELECT 
'Sys.Configurations' AS 'Topic'

INSERT INTO #ServerMenu
SELECT 
'Cluster Node Information' AS 'Topic'

INSERT INTO #ServerMenu
SELECT 
'Custom Error Messages' AS 'Topic'

INSERT INTO #ServerMenu
SELECT 
'Processor Information' AS 'Topic'

INSERT INTO #ServerMenu
SELECT 
'Service Account Information' AS 'Topic'


INSERT INTO #ServerMenu
SELECT 
'Connection IP Addresses' AS 'Topic'


INSERT INTO #ServerMenu
SELECT 
'Start up Parameters' AS 'Topic'

INSERT INTO #ServerMenu
SELECT 
'Azure SQL DB Service Tiers' AS 'Topic'

INSERT INTO #ServerMenu
SELECT 
'Extended Events Session Status' AS 'Topic'


INSERT INTO #ServerMenu
SELECT 
'Mail Configuration' AS 'Topic'

INSERT INTO #ServerMenu
SELECT 
'Mail Configuration Parameters' AS 'Topic'

INSERT INTO #ServerMenu
SELECT 
'Data Collection Information' AS 'Topic'

INSERT INTO #ServerMenu
SELECT 
'Database Mail Status and History' AS 'Topic'


INSERT INTO #ServerMenu
SELECT 
'General Server Information' AS 'Topic'


INSERT INTO #ServerMenu
SELECT 
'Trace Flags Being Used' AS 'Topic'

INSERT INTO #ServerMenu
SELECT 
'Error Log File Size' AS 'Topic'

INSERT INTO #ServerMenu
SELECT 
'Buffer Pool Extension Information' AS 'Topic'

INSERT INTO #ServerMenu
SELECT 
'Spinlock Information' AS 'Topic'


INSERT INTO #ServerMenu
SELECT 
'General Server OS Information' AS 'Topic'


SELECT * FROM #ServerMenu
ORDER BY MenuItem

DROP TABLE #ServerMenu</CommandText>
      </Query>
      <Fields>
        <Field Name="MenuItem">
          <DataField>MenuItem</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
      </Fields>
    </DataSet>
    <DataSet Name="Security">
      <Query>
        <DataSourceName>Local</DataSourceName>
        <CommandText>CREATE TABLE #SecMenu
			(MenuItem VARCHAR(100))



INSERT INTO #SecMenu
SELECT 
'SA Audit and Password Review' AS 'Topic'


INSERT INTO #SecMenu
SELECT 
'Failed Logins' AS 'Topic'



INSERT INTO #SecMenu
SELECT 
'Login Information' AS 'Topic'


INSERT INTO #SecMenu
SELECT 
'Server Role Information and Membership' AS 'Topic'


INSERT INTO #SecMenu
SELECT 
'Authentication Information' AS 'Topic'


INSERT INTO #SecMenu
SELECT 
'Email In Job Steps' AS 'Topic'


INSERT INTO #SecMenu
SELECT 
'Server Permissions other than Connect' AS 'Topic'


INSERT INTO #SecMenu
SELECT 
'Database Role Members' AS 'Topic'


INSERT INTO #SecMenu
SELECT 
'Database Users' AS 'Topic'

INSERT INTO #SecMenu
SELECT 
'Linked Server Information' AS 'Topic'

INSERT INTO #SecMenu
SELECT 
'Credential Information' AS 'Topic'

INSERT INTO #SecMenu
SELECT 
'Database Audit Specification Information' AS 'Topic'

INSERT INTO #SecMenu
SELECT 
'Server Audit Specification Information' AS 'Topic'

INSERT INTO #SecMenu
SELECT 
'Proxy Information' AS 'Topic'

INSERT INTO #SecMenu
SELECT 
'Users DMLRights other than SELECT (D)' AS 'Topic'

INSERT INTO #SecMenu
SELECT 
'Public Role Permissions  (D)' AS 'Topic'

INSERT INTO #SecMenu
SELECT 
'Guest Account Permissions and Status (D)' AS 'Topic'

INSERT INTO #SecMenu
SELECT 
'Encrypted Database Information' AS 'Topic'

INSERT INTO #SecMenu
SELECT 
'Guest Account Status All Databases' AS 'Topic'

INSERT INTO #SecMenu
SELECT 
'Procedures With Execute As   (D)' AS 'Topic'

INSERT INTO #SecMenu
SELECT 
'All Permissions On The Database' AS 'Topic'

INSERT INTO #SecMenu
SELECT 
'Security Policy Information' AS 'Topic'

INSERT INTO #SecMenu
SELECT 
'Login Last Password Change' AS 'Topic'

INSERT INTO #SecMenu
SELECT 
'Schema Owners w\Number of Objects' AS 'Topic'

INSERT INTO #SecMenu
SELECT 
'Schema Objects' AS 'Topic'

INSERT INTO #SecMenu
SELECT 
'Dropped Logins' AS 'Topic'

INSERT INTO #SecMenu
SELECT 
'Dropped DB Users' AS 'Topic'

SELECT * FROM #SecMenu
ORDER BY MenuItem

DROP TABLE #SecMenu</CommandText>
      </Query>
      <Fields>
        <Field Name="MenuItem">
          <DataField>MenuItem</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
      </Fields>
    </DataSet>
    <DataSet Name="BackupsDRHA">
      <Query>
        <DataSourceName>Local</DataSourceName>
        <CommandText>CREATE TABLE #BackRestore
			(MenuItem VARCHAR(100))



INSERT INTO #BackRestore
SELECT 
'Backup(Full and Differential) Information' AS 'Topic'


INSERT INTO #BackRestore
SELECT 
'Backup(Full and Differential) Information For a Database Past 45 Days' AS 'Topic'


INSERT INTO #BackRestore
SELECT 
'Backup(Log) Information For a Database Past 14 Days' AS 'Topic'

INSERT INTO #BackRestore
SELECT 
'Backup(Full and Differential) Information - Past 7 Days' AS 'Topic'


INSERT INTO #BackRestore
SELECT 
'Replication Information' AS 'Topic'

INSERT INTO #BackRestore
SELECT 
'Availablity Group Information' AS 'Topic'


INSERT INTO #BackRestore
SELECT 
'Restore Information' AS 'Topic'



INSERT INTO #BackRestore
SELECT 
'Missing Backups' AS 'Topic'


INSERT INTO #BackRestore
SELECT 
'Backup Speed Rate' AS 'Topic'


INSERT INTO #BackRestore
SELECT 
'Restore Progress' AS 'Topic'


INSERT INTO #BackRestore
SELECT 
'Backup Progress' AS 'Topic'



INSERT INTO #BackRestore
SELECT 
'Backup (TLog Only) Information' AS 'Topic'


INSERT INTO #BackRestore
SELECT 
'Backup (All Other Types) Information' AS 'Topic'

INSERT INTO #BackRestore
SELECT 
'Cluster Node Information' AS 'Topic'

INSERT INTO #BackRestore
SELECT 
'Mirrored Database Information' AS 'Topic'

INSERT INTO #BackRestore
SELECT 
'Log Shipping Databases' AS 'Topic'





SELECT * FROM #BackRestore
ORDER BY MenuItem

DROP TABLE #BackRestore</CommandText>
      </Query>
      <Fields>
        <Field Name="MenuItem">
          <DataField>MenuItem</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
      </Fields>
    </DataSet>
    <DataSet Name="ServerProperty">
      <Query>
        <DataSourceName>Local</DataSourceName>
        <CommandText>SELECT ServerProperty('EngineEdition') AS 'EngineEdition'</CommandText>
      </Query>
      <Fields>
        <Field Name="EngineEdition">
          <DataField>EngineEdition</DataField>
          <rd:TypeName>System.Object</rd:TypeName>
        </Field>
      </Fields>
    </DataSet>
    <DataSet Name="PerformanceReports">
      <Query>
        <DataSourceName>Local</DataSourceName>
        <CommandText>CREATE TABLE #PerfWait
			(MenuItem VARCHAR(100))



INSERT INTO #PerfWait
SELECT 
'Perf. Counters Last 120 Min' AS 'Topic'



INSERT INTO #PerfWait
SELECT 
'Waits Last 120 Min' AS 'Topic'

INSERT INTO #PerfWait
SELECT 
'Read Write Latency Last 120 Min' AS 'Topic'

INSERT INTO #PerfWait
SELECT 
'Windows Performance Counters'

INSERT INTO #PerfWait
SELECT 
'Deadlock Information'

INSERT INTO #PerfWait
SELECT 
'Blocking Information'

INSERT INTO #PerfWait
SELECT 
'Server Activity'

INSERT INTO #PerfWait
SELECT 
'Query Timeouts by Time Period'

INSERT INTO #PerfWait
SELECT 
'Query Timeout Detail Past 60\Min.'

INSERT INTO #PerfWait
SELECT 
'Baseline History'

INSERT INTO #PerfWait
SELECT 
'Database Growth'

INSERT INTO #PerfWait
SELECT 
'Monitor Configuration'


INSERT INTO #PerfWait
SELECT 
'Deploy Monitor DB'

INSERT INTO #PerfWait
SELECT 
'Deploy Part of Monitor Solution'


INSERT INTO #PerfWait
SELECT 
'View Monitor Solution Code'


INSERT INTO #PerfWait
SELECT 
'Monitor Solution Directions'

INSERT INTO #PerfWait
SELECT 
'Monitor Help'





SELECT * FROM #PerfWait

DROP TABLE #PerfWait</CommandText>
      </Query>
      <Fields>
        <Field Name="MenuItem">
          <DataField>MenuItem</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
      </Fields>
    </DataSet>
    <DataSet Name="AdminMonitorExists">
      <Query>
        <DataSourceName>Local</DataSourceName>
        <CommandText>DECLARE @DatabaseExists BIT

SELECT @DatabaseExists = COUNT(name)
FROM sysdatabases
WHERE Name = 'AdminMonitor'

SELECT @databaseExists AS 'DBExists'</CommandText>
      </Query>
      <Fields>
        <Field Name="DBExists">
          <DataField>DBExists</DataField>
          <rd:TypeName>System.Object</rd:TypeName>
        </Field>
      </Fields>
    </DataSet>
    <DataSet Name="DefaultTraceEnabled">
      <Query>
        <DataSourceName>Local</DataSourceName>
        <CommandText>SELECT Count(*) AS 'Default'
FROM master.sys.traces
where is_default = 1</CommandText>
      </Query>
      <Fields>
        <Field Name="Default">
          <DataField>Default</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
      </Fields>
    </DataSet>
    <DataSet Name="FileGrowthExtendedEventSessionExists">
      <Query>
        <DataSourceName>Local</DataSourceName>
        <CommandText>
SELECT 
   COUNT(sv.FilePath)  AS 'SessionExists'
FROM 
    Master.sys.dm_xe_sessions AS s
INNER JOIN 
    Master.sys.dm_xe_session_events AS e 
		ON s.address = e.event_session_address
INNER JOIN	
	(SELECT n.value('(@name)[1]', 'varchar(255)') AS FilePath,
		  tab.address
		, tab.name
	 FROM (
			SELECT CAST(t.target_data AS XML) target_data
			, s.address
			, s.name
			FROM Master.sys.dm_xe_sessions s
				INNER JOIN Master.sys.dm_xe_session_targets t 
					ON t.event_session_address = s.address
			WHERE t.target_name = N'event_file') AS tab
			CROSS APPLY [target_data].nodes('EventFileTarget/File') AS [q] ([n])) sv
	  ON s.name = sv.name
WHERE e.event_name IN 
			('databases_data_file_size_changed'
				, 'databases_log_file_size_changed')</CommandText>
      </Query>
      <Fields>
        <Field Name="SessionExists">
          <DataField>SessionExists</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
      </Fields>
    </DataSet>
  </DataSets>
  <rd:ReportUnitType>Inch</rd:ReportUnitType>
  <rd:ReportID>f42f444f-1ae7-4ff4-bfc3-8d830ed3465b</rd:ReportID>
</Report>