<?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 = "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 = "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 = "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 = "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 Information")
, 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 must it must be in 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 = "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 = "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>
                      </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 
'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 
'DBCC Command Progress' 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 
'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>