Microsoft.Exchange.2010.Reports.Transport.Platform.DistributionGroupUsage (Report)

Element properties:

Report Localization:

Source Code:

<Report ID="Microsoft.Exchange.2010.Reports.Transport.Platform.DistributionGroupUsage" Accessibility="Public" Visible="true">

  <Dependencies>

    <DataWarehouseScript>Microsoft.Exchange.2010.Reports.Script</DataWarehouseScript>

  </Dependencies>

  <Definition>

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

      <DataSources>

        <DataSource Name="Data Warehouse Main">

          <rd:DataSourceID>f6757a9d-7a7a-4da5-9c73-f016fa05eb64</rd:DataSourceID>

          <DataSourceReference>/Data Warehouse Main</DataSourceReference>

        </DataSource>

      </DataSources>

      <InteractiveHeight>1000in</InteractiveHeight>

      <Description>Distribution Group Usage Report</Description>

      <ReportParameters>

        <ReportParameter Name="IntervalStartDateTime">

          <DataType>DateTime</DataType>

          <Nullable>true</Nullable>

          <DefaultValue>

            <Values>

              <Value>=DateAdd(DateInterval.Day, -8, Today)</Value>

            </Values>

          </DefaultValue>

          <Prompt>Interval Start DateTime</Prompt>

        </ReportParameter>

        <ReportParameter Name="IntervalEndDateTime">

          <DataType>DateTime</DataType>

          <Nullable>true</Nullable>

          <DefaultValue>

            <Values>

              <Value>=DateAdd(DateInterval.Day, -1, Today)</Value>

            </Values>

          </DefaultValue>

          <Prompt>Interval End DateTime</Prompt>

        </ReportParameter>

        <ReportParameter Name="FilterString">

          <DataType>String</DataType>

          <Nullable>true</Nullable>

          <Prompt>Filter String</Prompt>

        </ReportParameter>

        <ReportParameter Name="LT_Report">

          <DataType>String</DataType>

          <DefaultValue>

            <DataSetReference>

              <DataSetName>LT_Report_Query</DataSetName>

              <ValueField>ValueXml</ValueField>

            </DataSetReference>

          </DefaultValue>

          <ValidValues>

            <DataSetReference>

              <DataSetName>LT_Report_Query</DataSetName>

              <ValueField>ValueXml</ValueField>

              <LabelField>ValueName</LabelField>

            </DataSetReference>

          </ValidValues>

          <Hidden>true</Hidden>

        </ReportParameter>

      </ReportParameters>

      <rd:DrawGrid>true</rd:DrawGrid>

      <InteractiveWidth>8.5in</InteractiveWidth>

      <rd:SnapToGrid>true</rd:SnapToGrid>

      <RightMargin>1in</RightMargin>

      <LeftMargin>1in</LeftMargin>

      <PageHeader>

        <PrintOnFirstPage>true</PrintOnFirstPage>

        <ReportItems>

          <Image Name="logo">

            <Sizing>Fit</Sizing>

            <Top>0.125in</Top>

            <Width>0.75in</Width>

            <Source>Embedded</Source>

            <Style/>

            <ZIndex>1</ZIndex>

            <Left>0.125in</Left>

            <Value>exlabs_logo_atom_50</Value>

          </Image>

          <Textbox Name="reportHeader">

            <Top>0.375in</Top>

            <Width>4.25in</Width>

            <Style></Style>

              <FontFamily>Tahoma</FontFamily>

              <FontSize>14pt</FontSize>

              <FontWeight>700</FontWeight>

              <TextAlign>Left</TextAlign>

              <PaddingLeft>2pt</PaddingLeft>

              <PaddingRight>2pt</PaddingRight>

              <PaddingTop>2pt</PaddingTop>

              <PaddingBottom>2pt</PaddingBottom>

            </Style>

            <CanGrow>true</CanGrow>

            <Left>1in</Left>

            <Height>0.375in</Height>

            <Value>=Code.GetLocTable("LT_Report").GetString("R.LocStr1", "[Distribution Group Usage]")</Value>

          </Textbox>

        </ReportItems>

        <Height>0.875in</Height>

        <PrintOnLastPage>true</PrintOnLastPage>

      </PageHeader>

      <BottomMargin>1in</BottomMargin>

      <rd:ReportID>0350ea2b-847a-4b25-8938-7cd675854d39</rd:ReportID>

      <EmbeddedImages>

        <EmbeddedImage Name="exlabs_logo_atom_50">

          <MIMEType>image/png</MIMEType>

          <ImageData>

				iVBORw0KGgoAAAANSUhEUgAAADkAAAA7CAYAAADB0CKOAAAABGdBTUEAAK/INwWK6QAAABl0RVh0U29mdHdhcmUAQWRvYmUgSW1hZ2VSZWFkeXHJZTwAABUBSURBVHja7FoJWBRH2q7ungNmmBu5ZDgGkENARfEmIoggQdCIV7x1dRONudQk3nFN4mo0iRo1q0H8jYlRo6IgioqEAKICIuABitwDcg3MwABzdPdWj43bmSBGk81u9vnreb6ne2Zquuqt76y3C4D/b/8bDflPjZsw2lPSB0MGtmh1VVG55RXwO4KWPz/IrMmBCj5JbsB1hgCtVpfE1huDSJ2xJb25bfHqquYm2AX/U5vNjVkjA4pmjqg4O97vZfhRBEVAyXlfx9cyfPr+BO95UFh/WoC5C8cE3F4wJv2dABc5/CiEYgmFA4UNxeKKp/2eJJc+r1H3UDDaytD/oEs9X7u+JERxb+m4ihVD3SiAVlC4DCBUQ9fZiex/dO1TCO/F0VHjw787Ev9/69eu/Ijui/6W8f8I00AlfO6pQqVq9o4bDzXws4EWghEXkKte/cWuMjH4bvPUwsChgXJ3937g4MG4avjbTihtULr+W0EiJe9HbdR26s/HHr9+mwZnhELS2kFnz5wyKSQ0ZK6trd1ENzd3YGFpCeRyJ1BZWQl0Or18fNiY6IuX0k/AvvoXjb7/VpA5KyNdERSdNGjXxZfoqEkBBBMjQ91Gjx79pqOj4xzv/r5iSwtLgGIYYLFYwM7OHnR1dYHExESwePFiIBIJp0GQZ+HfOv4bQaIygeXBB3Wta6kPgYMHCEeNHBbp6eX1hmc/rwEya2uAQWAmgeAogFKpDHC5XBAXFwciIyMBSZLAyclpfMAgX8XN/NsF9EKRvzdIk0lVJ340hjAYwc3i6sLJa+Ja6YEI+trjoHc3xQZ34bjy8zIjumPb5n0KhVukws1dRHkggiAAQ1kQHGoCyGaxAZ/Ph1oTgVsFt4BMJgP29vYA

				x3Hg7z8AjA0OjoQg79Im+9wgnxaekUfpn421ZKGfkUbCRd+pu00YccAiSV+AEyKjzvCTUW8o1LR1nvVZuiudUa08CSZlf5+RlqC11Y6JmREpEooejwSnRxA4FAJAMzZpj81mQ+EAGxsb0NHRAeLj48GiRYtMfSiQBNTmlcsXa2KnzR4In9AduH67JuuzvoAAWadqapvW+Uz+8CgDALJi6kviicO9/RwlVpEivsXXtQdXCDs79N/WNam/Gf3h4Xyq390t08focKL2fFbuCZGzd6SPjw9wdnYGLAiGzWYBDpttGocCQoHmci0ACkHv378fzJw58zE4GiDVx9fXzzEsdHTwpdTMC7TJEr9Vk6gmd+9p5SPVJe+odd/RJmJgmEl3gqbyHHZ2zcwBnraSmTwWNpPSbrNau9eKZ5yVlFexceWxbOWundtzrARCeU11NeBwONDvpEChUAAvLy/g4OBgMl2qpaWlAQsLCzBo0ECg1xuA0WCAIAlAmhaCAD+d/BQE8Ita+ZacArhQJIqgP8KVSZBOTix4EZBY+819TVYBr7vDex2dn5gOjzAEpcGy3o0cKpsx1CuqD5/7PoLj8rJHre+EfHHq6Dtvv75qzdr1K6g/ksRjzdy/XwIqKipAXd0jIBaLTSZrYWkBZkyf8QQ01QwQqF6vh1c9yLlxXbP8zbeH7Floi/q6iuw5bFYMtPn5UA5JJyW887wgWW15+0pPXcydNG91XAkNlHjGM1Da9Nk3tkzfTmgBW8bmjtd1GaqSyxpOjXxjzXY3d4/Hy4SQpiuFRSSWAi7UbkN9PdDpdfCe+yTScjhsaNYcaOLsJwMtWbLonQNff/N1dzpRJUyCzg41iiAJ0piTm57HJ0mcIAqHD1CMgvf3f4XJkww/ISVW3P4eqw9Ph/cbcucOOzG6tW57Xfp54OqiMC0HlRaoxudbARQibW1tAQajwaRBCiiA0t2HhObaoe0ATU1Nyry8vNPF9x5cY1gRgBpUq87

				EzqdAwo/PB7KzS58oFfInwfvDtJZ+laPf37dgol5nvJM83ibWjoOtRBsq5biBAO030kB77DxTDqQaFU0pjWm1WtDS0sIA9a/sUFVZAR6WPTxzMeXS6R9OJWbDrzppDTLjA5DG/FDQcnaay/NGV/JqfumZsGHen37zyULFnDUHSxg5kWniT0z921HeYnsrboChuno+WV4aJOezRISRNP0BgxpyVVWBkoI84BMw1GSmfCuByddaVM2m6AoeWzDQtreByuyr4NzNW5uysq9fKC4praNjgo4Wg3lBoDo7LQYmpB+fG+SUN/eoatO2750wyncP/ByV6NU3SGrBHg0zOMziGAJgEqfuEVitkPCq4+pqrMXqD0BFkxPAf56rjSRZ22whrq3MTHPwGjjEgcfjAaPRaAKEQzOlgkt1dVXbndt3rqRcuvzNjIL81+Oa2o7SRXk7DQ5/WrWDk8hkgAkK6QBI9NSnJ5DIP+zF4lvv/UMTuG7OqOt/iUguSsvfekXTuf/zWpWK4YemgHNzoXytFCBb4GgigpGmtUYyp0xtOD07u/kHABrwYWqeb+D0hjNU8W3o0AJlTTVoLLwJmsvv3ue1KnOlJHk7WKjvEmEInwanpU3U+LQqp/zo5BCUJZinbDFG0lgMvwYkmtZX8haBoYoSZdNxWVvH/H6zw3Z+3dR290BCloYRYJCMRfJBNhboAQRWXoSBfPLkTiNZ8lNt55YV11syaB+iJopfzynILLiVf1vdqpZcu5adlJh0/sJya9Y0BY8bdb1OlcKSyxoCXW09+0j4ffPd7d9GWdjDW1WNp+Z9mawyKyNN7fzWEJkVX3pQT7KT/Wd/fZWx+L2mECTNVvQFfGLylHp1Bv0bqzr5k60cFPG1jVgd2Z0z773r+habBOtJAykmoe9RIA0E1nazun3HvMuNx2AfNQ1Qx1hdVnRUuNfZpJQWZjA7HDowzEfI+6xJ27Wj5FZpkR2CjJper/703Aev9PN0tJ6AsT

				CSQJGKnNK6szO2nTYBTvkkRjLI2+YyZsF2Wbs/a8hXpwvqGVp/OshUa8ECGOdqY5vaM+nOlNaQz96N7TM3IvBCR0dX1r4vd32yYLDoYxYJ5pi0B8VoIDUqVJjb5uSjiVh9bBUNsJ2x/2NWSmxaAGNC2JFg/0HeAt5enUaLVJTVnni1unlvtwVQc8jaNm+A3EY0G8YDUtOhyewjRdawLdn+yTmV42dvSs6jTVv/LE0iqdZWO0Ob2lfTDzYwWDNW4va/9hvaz+6qNv+EBtHr5BQ4CmRrO5568Kb646ipE0JgmFRFrjl+hBEsiGdYDhM8a4WPk83UvrLvYa0g3lFcPfl4TZOSnnh3Hyxr26QQDydZEmbJAlXN+vhBC+PX0UV7Z28s3xPuBFZcaobtMydICGtThF0F3wGM0MsfRzSguV7TtWzIgaqFe/PUdzydZAGVDZor9GC97eDJHrZnVF/DjrtVjc3FVa2dOH5vhYfDqc99nd3o+ZnmVP7VzLXuDuIklI2CWw+bPqh6ZLhTfHTFjqQdC+TdW8JngoQJgdwj5jkzKwrqWvihW4DChnMe5jeRqZ7kSkGKRrFh1om6JHoV2/k8juPrX1wo7y0S/pqqyRJF5cFphW9pjXj2aIkgI97PZVj8ktHelXum51lasNfCtKXJK21cEvruycMxa47EJWbdWzmoX99ZlYlr59NugPUGkiw1Eru8ueyt68U8SffKFH3sHiAVsC5ByGKqU4XKsCe7w21t6NCBfzuzcc5gCvNPe+fLcYIs6ikCPk+Lc5aJ4W6LWrSukIw7q5Wdug39rSwSh8isMkkU9Yf+U5NwrXxG+PsJZ7oXd9WXyfV9J370N2pv2pi6+Ws6W2C9+Qh60kY4WMbCtqfqDNMdooUgeqDwGszmzkY9qbl8p33poiO1FAGsv7Zr2VRna+Huppb2pZgEJ1ESSLxm7d1NR1/ji4C86G4bCjfo48IrGrdeWDZmtIM1fwtRr/U1FNYDLNi1Z

				N2lOzOTc6pq6CCjY/igyV9rUjbOh4W9s13o+s1mbODP7JiY0qC5maEzTAvmWxyI9LG6CE3U2YCTyh/yNbMgwDTYh6I+Woe/uedgwcO6IGsBbwuP5Cy7X6MqBk/2/i/G6rFQJFhvK1Defi9sn6edMFHA5/ry+lmDDit2riapmCQfNOsZJR5u5tNGx/BNh1BYjF0+sExhxun+wlmJ9c3tKoe3pUkcPuanbcTBh4fq5644/iifjppddGDpilh/KOfWw9ooThcmd2GJXqbZcMystsXMB+wJYHy0v7XYzz7aJ9h9N/TvGRgHAziC3DuTVxU95mLRNJwkCtfAyLu0j0j8lABDLa6xXKk67O1mN9GceUd7in5iK9ZqnZG8u/90c3SEzmJmklffN+P62TswJk/1M0zY9E1el8hYI7DgjCj94vVv1saMtKVo/uHDhti+t3L5orTUlCsxE8Om0gtgPhZ6LNLXunDBiE0jHSX3BS4yf4SNAUqq1Z273Vedilz1bc512K8ptKhyMdyhtMZK+H9nLOYvgDartS0YiorMF/UXtWvZTnk0RdV/m9U6/dPbKipipu9V2Pb1EVjOzhysEGlJcDb8Zlk3eUWibEy94nDKXz+cEvThojH+yQNCIu4IPfwjAgOHiThwa2XvIH9EuRxdcJvAnQ71UrhIeOs4PPYczAQMBfA5QIsTOQevlKz6PLWkmFExGU3xQtU2c6qIn5Xsars8srx+Zw+5GBnu57K8rLY58VnMAFK907qstt1q3bC1FecYZRmgVw9NGewWzeeygmDEA+yXPKuVMsnge+192zw83Mf3tzA4CqoLAeEXDGyHjQPHjh0DCoWrZv78BcPLK2qUV0a7h4usuG/AauUl1JINMCjUldq4XHvYtH7hhTvf037fXcEwfY9z0KlPYD82di6rrTPo/Qb1fUaVgzambZ5PkkiATci698yY+p+DVH7Gn2ckkQXOK9ondCdpxmp1UxysoFGBbmFDAmYH+Hi/

				J/HxBwKh0LRPJGBFweloBfybKaCe4ADW0Ajg7uMLds2acnl4Y4WnkM+Vc3gc0A2Q4GDKB2263Xhh3bzYu8pIxvaqpxKNGp+T4mKzkUOQQWOrGk219L1jq+Q21oINLe1dye4xnyTR4IzMBfqZuSIwwiEEOERrEDDNITIiVOzl6fHK0KHDYmxsbaNkMmsTUcOiGXBYSJtIYomLCyjDLIDxyglgnXkCtMEU7RcUPA4/cxiQ1D4UmiWOIsqSlo7dsWcLjy2Ty+zCxbxBNLgOhuX0FKzw8IqGLelO1q+mx47c1nfaKAGLzSr4Njlv9Zs7zrQyXkXgT/VJBEFcWBhyqIeyDLG2Fo99benyAxSxBJ2bpioes2/UfCjiSSyWmL7PKSgEkxa+DzpLboHOpENAamkNGjgcyiwfsNlcooXFvWhlK7E7Nn/sQDu1NgKiUV8cN3CETMjT8Sw5OMZmkQj2eGPO4bKdod86IyxMjANEYyAJ6aPT167qr96LdP/h6jAz0+6RkzULPEgFBZQKNuYdDx85ec7WzlHt7uEhsuljAzw8+gEXV1fAYbNMxDBFCFO86rHvvwcx0dGmdxwcd1+AWzsC27QfgHSAlzazrO7kkmPXDtM7la4Lr4WP4DRpRtb1td7II0hEZ8RRUmcECE4ACiTFPDxqUF+dsPn4UbM4wvnRQVKwV2o1Yqmq/SJDe+Sz6Q8EOYQgaMKjL2UVdm80p5vXll6enudiJk9+tb6+HlSUV4Ds7KsmM6X41ICAANDa2gr6+/oCypQpioNiy6nfOsJmAKXFZWKE4fLcW4sjg8tVmi2TT2ZeabpxX8Vio3deScrLZORgsoe0Zn7FuwjyWxcMHQ/vU55VTv7C7h/tllKk7SEoFXApEyDoH0kEBR16BEt5KBka8dbxLZaWlvRopOkBIpEElJaWgpYWFfDz9TNxpY+5U87jjSMErFTWgClTpsRu9bHxd+RZvGU0GIs0dY3qisaWE7PzKxNpszP0Mln

				m9+hpG9E4ASA3jGvQTOhtw9xjnrRbrqIKYMmjPbYx8DoQrsPbCEDElhwUjFOo0cLCgqrBg4c4dffn8fgmc7Wx6QN9UgTa2tv+RS9CoYC2a7WgvLz8sp2dHWv8d6l7lwxQHJrr7bRUZC1Z6SUSSI/LpC3TLudfYhQazyoPSVjBdXMuzzxT8NRXd3bL6imwZ8y+5n7yUdEm/wED3qcGoABQGlOpmk0cKpM7bYdglTU1927cuHEqIyMrJS09q5xe8a79BWXqSCG7vJkEB3lSicZDyPsyP3o4zAL6PblNmoR3bpaqnvFqEOEiiDMcS/3vOMeDjR0z3Hvbp9uLJBIpEApFJlNs06gf13kGPahTKpUPSh9cTko6f/J8SmohgzPVM5I0khPun/fZXeWUo9XNlOrxS+GDpwsR5GUOQUTqDcakDp0hsbq986e5hRXl5rxvoqMsWEQQxx/oDPMWNbenMt7X/C4gqf6WcQe+vBYWFu5H7eO02nZKY5qamprUH9PTL8Yf+u4CDcicEH7y+i/75YFjUZxYNOxC4TIGcFOx8ZrCXhpjL4kSwtTMJohRpBEnjXpjEXUFRvgYI+6MG3CkRqdfN6tenUTn1l5fzj7v63STwqB/7atvqN+rqSvWnDiXtT0jMzv5zt3iOkaENPRCCCOWbNaGjMaW5TQ4fbd2qfuvyuooiadfUWAL7SXiECHfj8RxBAIFbQajeplSVUQ/W/+MYPXCx87QoJFDbPkCocPaqYpZJeWNOX/5+EwqXbEwafweB772SmAoRpALAxNyX6cnac4JMV8LMgVhBCaCkRuJFw48vTQi42puA1VI71k6sAt9zK109LCZ7XGBeFzWjvSq5jmMiRJPIbsIM9DALPr+6g36i550wmlQaY59hN6/ckCkaF7Qxg6cOL88636lOUXxDBfp9mf8RXik33KciyhTqvJ51Iugn692jy17fhB1pmfs8OPXtzB2Cv+Wo5+/J0gQtvRQC3yAYPPisWLQ+2

				E/FFYTp4pbtat7MdP/TpCU2XTpDEemjfWO6oXLQYvfjohv0Rm/ij2de5uhRfKPAon9VpDD+zuWejvKdol4nNNX8is7zTSE3f9gYrzegLOGfJW6lfZD/R+pxRdNIb9YqLKjyxaySRAsf3XPX7v3dglLwyR+NoK4jg6d0m/budWMnGgAf3BDfqdnsIvj/rJAgGHLOtq6EllGXA70xgEPa1vWjNuZkmmW9EnwJ22Ub1OnHgQZm2Nfjn8txA/86/i1JZ2P/2MnkJHfGSiTTCZ7oyT+7O3PdXb8f6X9U4ABAGSeZNakbULSAAAAAElFTkSuQmCC

			</ImageData>

        </EmbeddedImage>

      </EmbeddedImages>

      <DataSets>

        <DataSet Name="DistributionGroupUsage">

          <Fields>

            <Field Name="DateTime">

              <DataField>DateTime</DataField>

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

            </Field>

            <Field Name="DistributionGroup">

              <DataField>DistributionGroup</DataField>

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

            </Field>

            <Field Name="TenantName">

              <DataField>TenantName</DataField>

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

            </Field>

            <Field Name="Messages">

              <DataField>Messages</DataField>

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

            </Field>

          </Fields>

          <Query>

            <DataSourceName>Data Warehouse Main</DataSourceName>

            <CommandType>StoredProcedure</CommandType>

            <CommandText>Exchange2010.Transport-Platform-DistributionGroup-Report</CommandText>

            <QueryParameters>

              <QueryParameter Name="@IntervalStartDateTime">

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

              </QueryParameter>

              <QueryParameter Name="@IntervalEndDateTime">

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

              </QueryParameter>

              <QueryParameter Name="@FilterString">

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

              </QueryParameter>

            </QueryParameters>

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

          </Query>

        </DataSet>

        <DataSet Name="DistributionGroupDistribution">

          <Fields>

            <Field Name="Messages">

              <DataField>Messages</DataField>

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

            </Field>

            <Field Name="Count">

              <DataField>Count</DataField>

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

            </Field>

          </Fields>

          <Query>

            <DataSourceName>Data Warehouse Main</DataSourceName>

            <CommandType>StoredProcedure</CommandType>

            <CommandText>Exchange2010.Transport-Platform-DistributionGroupHistogram-Report</CommandText>

            <QueryParameters>

              <QueryParameter Name="@IntervalStartDateTime">

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

              </QueryParameter>

              <QueryParameter Name="@IntervalEndDateTime">

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

              </QueryParameter>

            </QueryParameters>

          </Query>

        </DataSet>

        <DataSet Name="LT_Report_Query">

          <Fields>

            <Field Name="ValueXml">

              <DataField>f1</DataField>

            </Field>

            <Field Name="ValueName">

              <Value>="LT"</Value>

            </Field>

          </Fields>

          <Query>

            <DataSourceName>Data Warehouse Main</DataSourceName>

            <CommandText>create table #myTestTable

(

  f1 nvarchar(max)

)



--

-- This code is taken from 'ReportDisplayStringGet' stored procedure

-- That stored procedure had a limitation of returning only 4K bytes

-- (2000 Unicode characters), which were not enough to return data

-- for all loc strings, and hence this change is made here.

--

;With CTEResult(c1)

AS

(

  SELECT

     1 AS Tag

    ,NULL AS Parent

    ,rds.ReportDisplayStringSystemName AS [S!1!N]

    ,ISNULL(ds.[Name], rds.ReportDisplayStringDefaultName) AS [S!1!!ELEMENT]

  FROM ManagementGroup mg

        CROSS JOIN ManagementPack mp

        JOIN ManagementPackVersion mpv ON (mp.ManagementPackRowId = mpv.ManagementPackRowId)

        JOIN ManagementGroupManagementPackVersion mgmpv ON (mgmpv.ManagementGroupRowId = mg.ManagementGroupRowId) AND (mgmpv.ManagementPackVersionRowId = mpv.ManagementPackVersionRowId)

        JOIN Report r ON (r.ManagementPackRowId = mp.ManagementPackRowId)

        JOIN ReportDisplayString rds ON (r.ReportRowId = rds.ReportRowId) AND (mpv.ManagementPackVersionRowId = rds.ManagementPackVersionRowId)

        LEFT JOIN DisplayString ds ON (ds.ElementGuid = rds.ReportDisplayStringGuid) AND (ds.LanguageCode = @LanguageCode)

  WHERE (mg.ManagementGroupGuid = @ManagementGroupGuid)

    AND (mp.ManagementPackSystemName = @ManagementPackSystemName)

    AND (mgmpv.LatestVersionInd = 1)

    AND (r.ReportSystemName = @ReportSystemName)

    AND ((@Scope IS NULL) OR (rds.ReportDisplayStringSystemName like @Scope))

  FOR XML EXPLICIT, ROOT('R')

)

insert into #myTestTable (f1)

select c1 from CTEResult



select f1 from #myTestTable</CommandText>

            <QueryParameters>

              <QueryParameter Name="@ManagementGroupGuid">

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

              </QueryParameter>

              <QueryParameter Name="@ManagementPackSystemName">

                <Value>Microsoft.Exchange.2010.Reports</Value>

              </QueryParameter>

              <QueryParameter Name="@ReportSystemName">

                <Value>Microsoft.Exchange.2010.Reports.Transport.Platform.DistributionGroupUsage</Value>

              </QueryParameter>

              <QueryParameter Name="@LanguageCode">

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

              </QueryParameter>

              <QueryParameter Name="@Scope">

                <Value>R.%</Value>

              </QueryParameter>

            </QueryParameters>

          </Query>

        </DataSet>

      </DataSets>

      <Width>6.375in</Width>

      <Body><Script>

        <ReportItems>

          <Textbox Name="textbox1">

            <Top>0.625in</Top>

            <Width>4.23in</Width>

            <Style></Style>

              <Color>Gray</Color>

              <FontFamily>Tahoma</FontFamily>

              <TextAlign>Left</TextAlign>

              <PaddingLeft>2pt</PaddingLeft>

              <PaddingRight>2pt</PaddingRight>

              <PaddingTop>2pt</PaddingTop>

              <PaddingBottom>2pt</PaddingBottom>

            </Style>

            <ZIndex>10</ZIndex>

            <CanGrow>true</CanGrow>

            <Left>2.02in</Left>

            <Height>0.25in</Height>

            <Value>=IIF( ISNothing(Parameters!FilterString.Value), "", Parameters!FilterString.Value)</Value>

          </Textbox>

          <Textbox Name="textbox4">

            <Top>0.625in</Top>

            <Width>0.375in</Width>

            <Style></Style>

              <Color>Gray</Color>

              <FontFamily>Tahoma</FontFamily>

              <TextAlign>Left</TextAlign>

              <PaddingLeft>2pt</PaddingLeft>

              <PaddingRight>2pt</PaddingRight>

              <PaddingTop>2pt</PaddingTop>

              <PaddingBottom>2pt</PaddingBottom>

            </Style>

            <ZIndex>9</ZIndex>

            <CanGrow>true</CanGrow>

            <Left>1.645in</Left>

            <Height>0.25in</Height>

            <Value>=":"</Value>

          </Textbox>

          <Textbox Name="textbox5">

            <Top>0.625in</Top>

            <Width>1.645in</Width>

            <Style></Style>

              <Color>Gray</Color>

              <FontFamily>Tahoma</FontFamily>

              <TextAlign>Left</TextAlign>

              <PaddingLeft>2pt</PaddingLeft>

              <PaddingRight>2pt</PaddingRight>

              <PaddingTop>2pt</PaddingTop>

              <PaddingBottom>2pt</PaddingBottom>

            </Style>

            <ZIndex>8</ZIndex>

            <CanGrow>true</CanGrow>

            <Height>0.25in</Height>

            <Value>=Code.GetLocTable("LT_Report").GetString("R.LocStr2", "[Filter String]")</Value>

          </Textbox>

          <CustomReportItem Name="enterpriseManagementChartControl1">

            <CustomData>

              <DataSetName>DistributionGroupDistribution</DataSetName>

              <DataColumnGroupings>

                <DataGroupings>

                  <DataGrouping>

                    <Grouping Name="enterpriseManagementChartControl1_DCG_Messages1">

                      <GroupExpressions>

                        <GroupExpression>=Fields!Messages.Value</GroupExpression>

                      </GroupExpressions>

                    </Grouping>

                    <CustomProperties>

                      <CustomProperty>

                        <Name>GroupLabel</Name>

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

                      </CustomProperty>

                    </CustomProperties>

                  </DataGrouping>

                </DataGroupings>

              </DataColumnGroupings>

              <DataRowGroupings>

                <DataGroupings>

                  <DataGrouping>

                    <Static>true</Static>

                    <CustomProperties>

                      <CustomProperty>

                        <Name>ID</Name>

                        <Value>3c8f6f36-042b-4acb-b0f4-2e4118aa4645</Value>

                      </CustomProperty>

                      <CustomProperty>

                        <Name>BorderColor</Name>

                        <Value>Black</Value>

                      </CustomProperty>

                      <CustomProperty>

                        <Name>SmartLabels.Enabled</Name>

                        <Value>False</Value>

                      </CustomProperty>

                      <CustomProperty>

                        <Name>SeriesLabel</Name>

                        <Value>Count</Value>

                      </CustomProperty>

                      <CustomProperty>

                        <Name>ChartArea</Name>

                        <Value>Default</Value>

                      </CustomProperty>

                      <CustomProperty>

                        <Name>Type</Name>

                        <Value>SplineArea</Value>

                      </CustomProperty>

                    </CustomProperties>

                  </DataGrouping>

                </DataGroupings>

              </DataRowGroupings>

              <DataRows>

                <DataRow>

                  <DataCell>

                    <DataValue>

                      <Name>ID</Name>

                      <Value>3c8f6f36-042b-4acb-b0f4-2e4118aa4645</Value>

                    </DataValue>

                    <DataValue>

                      <Name>Y0</Name>

                      <Value>=Sum(Fields!Count.Value)</Value>

                    </DataValue>

                  </DataCell>

                </DataRow>

              </DataRows>

            </CustomData>

            <AltReportItem>

              <Textbox xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" Name="enterpriseManagementChartControl1_Textbox">

                <Value>=Code.GetLocTable("LT_Report").GetString("R.LocStr3", "[The Dundas Chart for Reporting Services report item is unavailable.]")</Value>

              </Textbox>

            </AltReportItem>

            <Top>1in</Top>

            <Type>EnterpriseManagementChartControl</Type>

            <Width>6.125in</Width>

            <CustomProperties>

              <CustomProperty>

                <Name>Chart.Palette</Name>

                <Value>Excel</Value>

              </CustomProperty>

              <CustomProperty>

                <Name>Chart.BorderLineColor</Name>

                <Value>Black</Value>

              </CustomProperty>

              <CustomProperty>

                <Name>Chart.NoDataMessage.Text</Name>

                <Value>=Code.GetLocTable("LT_Report").GetString("R.LocStr4", "[*****  No Data  *****]")</Value>

              </CustomProperty>

              <CustomProperty>

                <Name>Chart.Legends.0.Legend.Name</Name>

                <Value>Default</Value>

              </CustomProperty>

              <CustomProperty>

                <Name>Chart.Legends.0.Legend.Enabled</Name>

                <Value>False</Value>

              </CustomProperty>

              <CustomProperty>

                <Name>Chart.Legends.0.Legend.BackColor</Name>

                <Value>White</Value>

              </CustomProperty>

              <CustomProperty>

                <Name>Chart.ChartAreas.0.ChartArea.BackColor</Name>

                <Value>Silver</Value>

              </CustomProperty>

              <CustomProperty>

                <Name>Chart.ChartAreas.0.ChartArea.BorderStyle</Name>

                <Value>Solid</Value>

              </CustomProperty>

              <CustomProperty>

                <Name>Chart.ChartAreas.0.ChartArea.BackImageTranspColor</Name>

                <Value>White</Value>

              </CustomProperty>

              <CustomProperty>

                <Name>Chart.ChartAreas.0.ChartArea.ShadowColor</Name>

                <Value>White</Value>

              </CustomProperty>

              <CustomProperty>

                <Name>Chart.ChartAreas.0.ChartArea.Name</Name>

                <Value>Default</Value>

              </CustomProperty>

              <CustomProperty>

                <Name>Chart.ChartAreas.0.ChartArea.AxisY.ValueType</Name>

                <Value>Int</Value>

              </CustomProperty>

              <CustomProperty>

                <Name>Chart.ChartAreas.0.ChartArea.AxisY.Title</Name>

                <Value>=Code.GetLocTable("LT_Report").GetString("R.LocStr5", "[Number Of Groups]")</Value>

              </CustomProperty>

              <CustomProperty>

                <Name>Chart.ChartAreas.0.ChartArea.AxisY.MajorGrid.Enabled</Name>

                <Value>False</Value>

              </CustomProperty>

              <CustomProperty>

                <Name>Chart.ChartAreas.0.ChartArea.AxisY.MajorTickMark.Enabled</Name>

                <Value>False</Value>

              </CustomProperty>

              <CustomProperty>

                <Name>Chart.ChartAreas.0.ChartArea.AxisX.ValueType</Name>

                <Value>Int</Value>

              </CustomProperty>

              <CustomProperty>

                <Name>Chart.ChartAreas.0.ChartArea.AxisX.Title</Name>

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

              </CustomProperty>

              <CustomProperty>

                <Name>Chart.ChartAreas.0.ChartArea.AxisX.Margin</Name>

                <Value>False</Value>

              </CustomProperty>

              <CustomProperty>

                <Name>Chart.ChartAreas.0.ChartArea.AxisX.MajorGrid.Enabled</Name>

                <Value>False</Value>

              </CustomProperty>

              <CustomProperty>

                <Name>Chart.ChartAreas.0.ChartArea.AxisX.MajorTickMark.Enabled</Name>

                <Value>False</Value>

              </CustomProperty>

              <CustomProperty>

                <Name>Chart.ChartAreas.0.ChartArea.AxisX2.MajorGrid.Enabled</Name>

                <Value>False</Value>

              </CustomProperty>

              <CustomProperty>

                <Name>Chart.ChartAreas.0.ChartArea.AxisX2.MajorTickMark.Enabled</Name>

                <Value>False</Value>

              </CustomProperty>

              <CustomProperty>

                <Name>Chart.ChartAreas.0.ChartArea.AxisY2.MajorGrid.Enabled</Name>

                <Value>False</Value>

              </CustomProperty>

              <CustomProperty>

                <Name>Chart.ChartAreas.0.ChartArea.AxisY2.MajorTickMark.Enabled</Name>

                <Value>False</Value>

              </CustomProperty>

              <CustomProperty>

                <Name>Chart.ChartAreas.0.ChartArea.Area3DStyle.WallWidth</Name>

                <Value>4</Value>

              </CustomProperty>

              <CustomProperty>

                <Name>Chart.ChartAreas.0.ChartArea.Area3DStyle.XAngle</Name>

                <Value>10</Value>

              </CustomProperty>

              <CustomProperty>

                <Name>Chart.ChartAreas.0.ChartArea.Area3DStyle.YAngle</Name>

                <Value>10</Value>

              </CustomProperty>

              <CustomProperty>

                <Name>Chart.BorderSkin.FrameBackGradientEndColor</Name>

                <Value>White</Value>

              </CustomProperty>

            </CustomProperties>

            <ZIndex>7</ZIndex>

            <Left>0.125in</Left>

            <Height>3in</Height>

          </CustomReportItem>

          <Table Name="table1">

            <ZIndex>6</ZIndex>

            <DataSetName>DistributionGroupUsage</DataSetName>

            <Top>4.125in</Top>

            <TableGroups>

              <TableGroup>

                <Grouping Name="table1_DateTimeGroup">

                  <GroupExpressions>

                    <GroupExpression>=Fields!TenantName.Value</GroupExpression>

                  </GroupExpressions>

                </Grouping>

                <Header>

                  <TableRows>

                    <TableRow>

                      <TableCells>

                        <TableCell>

                          <ReportItems>

                            <Textbox Name="DateTimeSummary">

                              <Style></Style>

                                <BackgroundColor>#e8eef7</BackgroundColor>

                                <BorderColor>

                                  <Right>#cbdaec</Right>

                                  <Top>#cbdaec</Top>

                                  <Bottom>#cbdaec</Bottom>

                                </BorderColor>

                                <BorderStyle>

                                  <Left>None</Left>

                                  <Right>Solid</Right>

                                  <Top>Solid</Top>

                                  <Bottom>Solid</Bottom>

                                </BorderStyle>

                                <BorderWidth>

                                  <Right>1pt</Right>

                                  <Top>1pt</Top>

                                  <Bottom>1pt</Bottom>

                                </BorderWidth>

                                <FontFamily>Tahoma</FontFamily>

                                <FontSize>8pt</FontSize>

                                <TextAlign>Left</TextAlign>

                              </Style>

                              <ZIndex>5</ZIndex>

                              <CanGrow>true</CanGrow>

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

                            </Textbox>

                          </ReportItems>

                        </TableCell>

                        <TableCell>

                          <ReportItems>

                            <Textbox Name="textbox2">

                              <Style></Style>

                                <BackgroundColor>#e8eef7</BackgroundColor>

                                <BorderColor>

                                  <Left>#cbdaec</Left>

                                  <Right>#cbdaec</Right>

                                  <Top>#cbdaec</Top>

                                  <Bottom>#cbdaec</Bottom>

                                </BorderColor>

                                <BorderStyle>

                                  <Left>Solid</Left>

                                  <Right>Solid</Right>

                                  <Top>Solid</Top>

                                  <Bottom>Solid</Bottom>

                                </BorderStyle>

                                <BorderWidth>

                                  <Left>1pt</Left>

                                  <Right>1pt</Right>

                                  <Top>1pt</Top>

                                  <Bottom>1pt</Bottom>

                                </BorderWidth>

                                <FontFamily>Tahoma</FontFamily>

                                <FontSize>8pt</FontSize>

                                <TextAlign>Left</TextAlign>

                              </Style>

                              <ZIndex>4</ZIndex>

                              <CanGrow>true</CanGrow>

                              <Value>=Sum(Fields!Messages.Value)</Value>

                            </Textbox>

                          </ReportItems>

                        </TableCell>

                      </TableCells>

                      <Height>0.25in</Height>

                    </TableRow>

                  </TableRows>

                </Header>

              </TableGroup>

              <TableGroup>

                <Grouping Name="table1_Group_Tenant">

                  <GroupExpressions>

                    <GroupExpression>=Fields!DistributionGroup.Value</GroupExpression>

                  </GroupExpressions>

                </Grouping>

                <Visibility>

                  <Hidden>true</Hidden>

                  <ToggleItem>DateTimeSummary</ToggleItem>

                </Visibility>

                <Header>

                  <TableRows>

                    <TableRow>

                      <TableCells>

                        <TableCell>

                          <ReportItems>

                            <Textbox Name="TenantSummary">

                              <Style></Style>

                                <BackgroundColor>White</BackgroundColor>

                                <BorderColor>

                                  <Right>#cbdaec</Right>

                                  <Top>#cbdaec</Top>

                                  <Bottom>#cbdaec</Bottom>

                                </BorderColor>

                                <BorderStyle>

                                  <Left>None</Left>

                                  <Right>Solid</Right>

                                  <Top>Solid</Top>

                                  <Bottom>Solid</Bottom>

                                </BorderStyle>

                                <BorderWidth>

                                  <Right>1pt</Right>

                                  <Top>1pt</Top>

                                  <Bottom>1pt</Bottom>

                                </BorderWidth>

                                <FontFamily>Tahoma</FontFamily>

                                <FontSize>8pt</FontSize>

                                <TextAlign>Left</TextAlign>

                              </Style>

                              <ZIndex>3</ZIndex>

                              <CanGrow>true</CanGrow>

                              <Value>=Space(5) + Fields!DistributionGroup.Value</Value>

                            </Textbox>

                          </ReportItems>

                        </TableCell>

                        <TableCell>

                          <ReportItems>

                            <Textbox Name="textbox23">

                              <Style></Style>

                                <BackgroundColor>White</BackgroundColor>

                                <BorderColor>

                                  <Left>#cbdaec</Left>

                                  <Right>#cbdaec</Right>

                                  <Top>#cbdaec</Top>

                                  <Bottom>#cbdaec</Bottom>

                                </BorderColor>

                                <BorderStyle>

                                  <Left>Solid</Left>

                                  <Right>Solid</Right>

                                  <Top>Solid</Top>

                                  <Bottom>Solid</Bottom>

                                </BorderStyle>

                                <BorderWidth>

                                  <Left>1pt</Left>

                                  <Right>1pt</Right>

                                  <Top>1pt</Top>

                                  <Bottom>1pt</Bottom>

                                </BorderWidth>

                                <FontFamily>Tahoma</FontFamily>

                                <FontSize>8pt</FontSize>

                                <TextAlign>Left</TextAlign>

                              </Style>

                              <ZIndex>2</ZIndex>

                              <CanGrow>true</CanGrow>

                              <Value>=Sum(Fields!Messages.Value)</Value>

                            </Textbox>

                          </ReportItems>

                        </TableCell>

                      </TableCells>

                      <Height>0.25in</Height>

                    </TableRow>

                  </TableRows>

                </Header>

              </TableGroup>

            </TableGroups>

            <Width>3.5in</Width>

            <Details>

              <TableRows>

                <TableRow>

                  <TableCells>

                    <TableCell>

                      <ReportItems>

                        <Textbox Name="DateTime">

                          <Style></Style>

                            <BackgroundColor>White</BackgroundColor>

                            <BorderColor>

                              <Right>#cbdaec</Right>

                              <Top>#cbdaec</Top>

                            </BorderColor>

                            <BorderStyle>

                              <Left>None</Left>

                              <Right>Solid</Right>

                              <Top>Solid</Top>

                              <Bottom>None</Bottom>

                            </BorderStyle>

                            <BorderWidth>

                              <Right>1pt</Right>

                              <Top>1pt</Top>

                            </BorderWidth>

                            <FontFamily>Tahoma</FontFamily>

                            <FontSize>8pt</FontSize>

                            <TextAlign>Left</TextAlign>

                          </Style>

                          <ZIndex>1</ZIndex>

                          <CanGrow>true</CanGrow>

                          <Value>=Space(10) + Code.FormatDateTime("d",Fields!DateTime.Value)</Value>

                        </Textbox>

                      </ReportItems>

                    </TableCell>

                    <TableCell>

                      <ReportItems>

                        <Textbox Name="textbox40">

                          <Style></Style>

                            <BackgroundColor>White</BackgroundColor>

                            <BorderColor>

                              <Left>#cbdaec</Left>

                              <Right>#cbdaec</Right>

                              <Top>#cbdaec</Top>

                            </BorderColor>

                            <BorderStyle>

                              <Left>Solid</Left>

                              <Right>Solid</Right>

                              <Top>Solid</Top>

                              <Bottom>None</Bottom>

                            </BorderStyle>

                            <BorderWidth>

                              <Left>1pt</Left>

                              <Right>1pt</Right>

                              <Top>1pt</Top>

                            </BorderWidth>

                            <FontFamily>Tahoma</FontFamily>

                            <FontSize>8pt</FontSize>

                            <TextAlign>Left</TextAlign>

                          </Style>

                          <CanGrow>true</CanGrow>

                          <Value>=Sum(Fields!Messages.Value)</Value>

                        </Textbox>

                      </ReportItems>

                    </TableCell>

                  </TableCells>

                  <Height>0.25in</Height>

                </TableRow>

              </TableRows>

              <Grouping Name="table1_Details_Group">

                <GroupExpressions>

                  <GroupExpression>=Fields!DateTime.Value</GroupExpression>

                </GroupExpressions>

              </Grouping>

              <Visibility>

                <Hidden>true</Hidden>

                <ToggleItem>TenantSummary</ToggleItem>

              </Visibility>

            </Details>

            <Style></Style>

              <Color>White</Color>

              <BackgroundColor>White</BackgroundColor>

            </Style>

            <Header>

              <TableRows>

                <TableRow>

                  <TableCells>

                    <TableCell>

                      <ReportItems>

                        <Textbox Name="textbox43">

                          <Style></Style>

                            <BackgroundColor>White</BackgroundColor>

                            <BorderColor>

                              <Right>#cbdaec</Right>

                              <Bottom>#cbdaec</Bottom>

                            </BorderColor>

                            <BorderStyle>

                              <Left>None</Left>

                              <Right>Solid</Right>

                              <Top>None</Top>

                              <Bottom>Solid</Bottom>

                            </BorderStyle>

                            <BorderWidth>

                              <Right>1pt</Right>

                              <Bottom>1pt</Bottom>

                            </BorderWidth>

                            <FontFamily>Tahoma</FontFamily>

                            <FontSize>8pt</FontSize>

                            <TextAlign>Left</TextAlign>

                            <PaddingLeft>2pt</PaddingLeft>

                            <PaddingRight>2pt</PaddingRight>

                            <PaddingTop>2pt</PaddingTop>

                            <PaddingBottom>2pt</PaddingBottom>

                          </Style>

                          <ZIndex>7</ZIndex>

                          <CanGrow>true</CanGrow>

                          <Value/>

                        </Textbox>

                      </ReportItems>

                    </TableCell>

                    <TableCell>

                      <ReportItems>

                        <Textbox Name="textbox44">

                          <Style></Style>

                            <BackgroundColor>White</BackgroundColor>

                            <BorderColor>

                              <Left>#cbdaec</Left>

                              <Right>#cbdaec</Right>

                              <Bottom>#cbdaec</Bottom>

                            </BorderColor>

                            <BorderStyle>

                              <Left>Solid</Left>

                              <Right>Solid</Right>

                              <Top>None</Top>

                              <Bottom>Solid</Bottom>

                            </BorderStyle>

                            <BorderWidth>

                              <Left>1pt</Left>

                              <Right>1pt</Right>

                              <Bottom>1pt</Bottom>

                            </BorderWidth>

                            <FontFamily>Tahoma</FontFamily>

                            <FontSize>8pt</FontSize>

                            <TextAlign>Left</TextAlign>

                            <PaddingLeft>2pt</PaddingLeft>

                            <PaddingRight>2pt</PaddingRight>

                            <PaddingTop>2pt</PaddingTop>

                            <PaddingBottom>2pt</PaddingBottom>

                          </Style>

                          <ZIndex>6</ZIndex>

                          <CanGrow>true</CanGrow>

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

                        </Textbox>

                      </ReportItems>

                    </TableCell>

                  </TableCells>

                  <Height>0.25in</Height>

                </TableRow>

              </TableRows>

            </Header>

            <TableColumns>

              <TableColumn>

                <Width>2.375in</Width>

              </TableColumn>

              <TableColumn>

                <Width>1.125in</Width>

              </TableColumn>

            </TableColumns>

            <Height>1in</Height>

            <Left>1.5in</Left>

          </Table>

          <Textbox Name="textbox16">

            <Top>0.375in</Top>

            <Width>4.23in</Width>

            <Style></Style>

              <Color>Gray</Color>

              <FontFamily>Tahoma</FontFamily>

              <TextAlign>Left</TextAlign>

              <PaddingLeft>2pt</PaddingLeft>

              <PaddingRight>2pt</PaddingRight>

              <PaddingTop>2pt</PaddingTop>

              <PaddingBottom>2pt</PaddingBottom>

            </Style>

            <ZIndex>5</ZIndex>

            <CanGrow>true</CanGrow>

            <Left>2.02in</Left>

            <Height>0.25in</Height>

            <Value>=IIF( ISNothing(Parameters!IntervalStartDateTime.Value) OR IsNothing(Parameters!IntervalEndDateTime.Value), "", Code.FormatDateTime("d",Parameters!IntervalStartDateTime.Value) + " to " + Code.FormatDateTime("d",Parameters!IntervalEndDateTime.Value))</Value>

          </Textbox>

          <Textbox Name="textbox17">

            <Top>0.125in</Top>

            <Width>4.23in</Width>

            <Style></Style>

              <Color>Gray</Color>

              <FontFamily>Tahoma</FontFamily>

              <TextAlign>Left</TextAlign>

              <PaddingLeft>2pt</PaddingLeft>

              <PaddingRight>2pt</PaddingRight>

              <PaddingTop>2pt</PaddingTop>

              <PaddingBottom>2pt</PaddingBottom>

            </Style>

            <ZIndex>4</ZIndex>

            <CanGrow>true</CanGrow>

            <Left>2.02in</Left>

            <Height>0.25in</Height>

            <Value>=Code.FormatDateTime("g",Now.ToString())</Value>

          </Textbox>

          <Textbox Name="textbox3">

            <Top>0.375in</Top>

            <Width>0.375in</Width>

            <Style></Style>

              <Color>Gray</Color>

              <FontFamily>Tahoma</FontFamily>

              <TextAlign>Left</TextAlign>

              <PaddingLeft>2pt</PaddingLeft>

              <PaddingRight>2pt</PaddingRight>

              <PaddingTop>2pt</PaddingTop>

              <PaddingBottom>2pt</PaddingBottom>

            </Style>

            <ZIndex>3</ZIndex>

            <CanGrow>true</CanGrow>

            <Left>1.645in</Left>

            <Height>0.25in</Height>

            <Value>=":"</Value>

          </Textbox>

          <Textbox Name="textbox10">

            <Top>0.125in</Top>

            <Width>0.375in</Width>

            <Style></Style>

              <Color>Gray</Color>

              <FontFamily>Tahoma</FontFamily>

              <TextAlign>Left</TextAlign>

              <PaddingLeft>2pt</PaddingLeft>

              <PaddingRight>2pt</PaddingRight>

              <PaddingTop>2pt</PaddingTop>

              <PaddingBottom>2pt</PaddingBottom>

            </Style>

            <ZIndex>2</ZIndex>

            <CanGrow>true</CanGrow>

            <Left>1.645in</Left>

            <Height>0.25in</Height>

            <Value>=":"</Value>

          </Textbox>

          <Textbox Name="reportDuration">

            <Top>0.375in</Top>

            <Width>1.645in</Width>

            <Style></Style>

              <Color>Gray</Color>

              <FontFamily>Tahoma</FontFamily>

              <TextAlign>Left</TextAlign>

              <PaddingLeft>2pt</PaddingLeft>

              <PaddingRight>2pt</PaddingRight>

              <PaddingTop>2pt</PaddingTop>

              <PaddingBottom>2pt</PaddingBottom>

            </Style>

            <ZIndex>1</ZIndex>

            <CanGrow>true</CanGrow>

            <Height>0.25in</Height>

            <Value>=Code.GetLocTable("LT_Report").GetString("R.LocStr7", "[Report Duration]")</Value>

          </Textbox>

          <Textbox Name="reportTime">

            <Top>0.125in</Top>

            <Width>1.645in</Width>

            <Style></Style>

              <Color>Gray</Color>

              <FontFamily>Tahoma</FontFamily>

              <TextAlign>Left</TextAlign>

              <PaddingLeft>2pt</PaddingLeft>

              <PaddingRight>2pt</PaddingRight>

              <PaddingTop>2pt</PaddingTop>

              <PaddingBottom>2pt</PaddingBottom>

            </Style>

            <CanGrow>true</CanGrow>

            <Height>0.25in</Height>

            <Value>=Code.GetLocTable("LT_Report").GetString("R.LocStr8", "[Report Time]")</Value>

          </Textbox>

        </ReportItems>

        <Height>8.375in</Height>

        <Style></Style>

          <BackgroundColor>White</BackgroundColor>

        </Style>

      </Script></Body>

      <Language>en-US</Language>

      <TopMargin>1in</TopMargin>

      <Code><Script>Function GetCallingManagementGroupId() As String

    Return Microsoft.EnterpriseManagement.Reporting.ReportingConfiguration.ManagementGroupId

End Function



Function GetReportLocLanguageCode() As String

    Return ReportCulture.ThreeLetterWindowsLanguageName

End Function



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



Const TimeZoneParameterName As String = "TimeZone"

Const IsRelativeTimeSupported As Boolean = True

Const TimeTypeParameterName As String = "TimeType"

Const TimeWeekMapParameterName As String = "TimeWeekMap"

Const DataAggregationParameterName As String = "DataAggregation"



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

Dim ReportTimeZone As Microsoft.EnterpriseManagement.Reporting.TimeZoneCoreInformation

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

Dim ReportCulture As System.Globalization.CultureInfo

Dim ParameterProcessor As Microsoft.EnterpriseManagement.Reporting.ParameterProcessor



Protected Overrides Sub OnInit()

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

    ReportTimeZone = Nothing

    ReportTime = Nothing

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

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

End Sub





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

    Dim LocTable As Microsoft.EnterpriseManagement.Reporting.XmlStringTable



    If Not LocTables.TryGetValue(Name, LocTable) Then

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

        LocTables.Add(Name, LocTable)

    End If



    Return LocTable

End Function



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

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

    Return ReportTimeZone

End Function



Public Function ToDbDate(ByVal DateValue As DateTime) As DateTime

    Return GetReportTimeZone.ToUniversalTime(DateValue)

End Function



Public Function ToReportDate(ByVal DateValue As DateTime) As DateTime

    Return GetReportTimeZone.ToLocalTime(DateValue)

End Function



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

    Return Value.ToString(Format, ReportCulture)

End Function



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

    Return Value.ToString(Format, ReportCulture)

End Function



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

    Return String.Format(ReportCulture, Format, Values)

End Function



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

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

End Function</Script></Code>

      <CodeModules>

        <CodeModule>Microsoft.EnterpriseManagement.Reporting.Code, Version=6.0.0.0, Culture=neutral</CodeModule>

      </CodeModules>

    </Report>

  </Definition>

  <ReportStrings>

    <ReportString ID="R.LocStr1"/>

    <ReportString ID="R.LocStr2"/>

    <ReportString ID="R.LocStr3"/>

    <ReportString ID="R.LocStr4"/>

    <ReportString ID="R.LocStr5"/>

    <ReportString ID="R.LocStr6"/>

    <ReportString ID="R.LocStr7"/>

    <ReportString ID="R.LocStr8"/>

  </ReportStrings>

</Report>