管理パックの履歴

Microsoft.SystemCenter.DataWarehouse.Report.ManagementPackHistory (Report)

管理パックの履歴レポート
Knowledge Base article:

概要

この管理パックの履歴レポートには、SCOM 管理サーバーでインストールまたは削除されたすべての管理パックが表示されます。
説明:
このレポートでは、選択された期間に管理サーバーで行われたすべての管理パックのインストールまたは削除の詳細が取得されます。結果には、管理パックの名前、バージョン、アクション (インストールまたは削除)、アクションを実行したユーザーが表示されます。
パラメーター:
日付/時刻選択:相対日付または指定日を使用して、レポートの期間を定義できます。
アクションの基準:アクション (インストールまたは削除) でフィルター処理できます
ユーザー名:ユーザー名でフィルター処理できます。複数のユーザー名を、セミコロン (;) で区切って入力できます
使用例:
シナリオ:前の週の月曜日から金曜日までに、Dan と Bob がインストールしたすべての管理パックについてのレポートを作成します
手順:(選択するパラメーターは太字で示されています)
管理パックの履歴レポートを開きます
[From] (開始) ドロップダウンを選択し、[前の週] > [月曜日] を選択します
[To] (終了) ドロップダウンを選択し、[前の週] > [金曜日] を選択します
[アクションの基準] に [インストール] を選択します
ユーザー名に「Dan;Bob」と入力します
[実行] をクリックしてレポートを表示します。
Element properties:

Accessibility	Public
Visible	True
Report Localization:

*R.Description*	このレポートには、ある期間にインストールまたは削除されたすべての管理パックが表示されます
*R.DescriptionTitle*	このレポートの詳細な説明を表示するには、プラス記号をクリックしてください
*R.GeneratedTimeLabel*	レポート時間
*R.PageFormat*	{0}/{1} ページ
*R.StartEndTimeFormat*	{0} ～ {1}
*R.StartEndTimeLabel*	レポート期間
*R.Table1Title*	インストールされている MP のバージョン
*R.Table2Title*	オーバーライド
*R.Table3Title*	UI を使用して作成されたカスタム項目
*R.TimeZoneFormat*	すべての日付と時刻が {0} で表示されます
*R.Title*	管理パックの履歴レポート
*R.ActionCriteriaLabel*	アクションの基準
*R.UserCriteriaLabel*	ユーザーの基準
*R.Action_0*	すべてのアクション
*R.Action_1*	インストール
*R.Action_2*	削除
*RT.Column.ManagementPack*	管理パック
*RT.Column.Object*	オブジェクト
*RT.Column.OverrideObject*	オーバーライド
*RT.Column.Parameter*	パラメーター
*RT.Column.TargetClass*	ターゲット
*RT.Column.Value*	値
*RT.Column.Version*	バージョン
*RT.Column.Username*	ユーザー名
*RT.Column.Date*	日付
*RT.Column.Action*	アクション
Source Code:

<Report ID="Microsoft.SystemCenter.DataWarehouse.Report.ManagementPackHistory" Accessibility="Public" Visible="true">

  <ParameterBlock xmlns="http://schemas.microsoft.com/mom/reporting/2007/ReportParameterSettings" columns="1">

    <Controls>

      <Control type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.RelativeDateTimePicker" rowSpan="1" columnSpan="1">

        <ReportParameters>

          <ReportParameter name="TimeZone" binding="TimeZone">

            <Prompt>Microsoft.SystemCenter.DataWarehouse.Report.Library!Microsoft.SystemCenter.DataWarehouse.Report.ParameterPrompt.TimeZone</Prompt>

          </ReportParameter>

          <ReportParameter name="TimeZoneName" binding="TimeZoneName"/>

          <ReportParameter name="StartDate_BaseType" binding="StartDate_BaseType"/>

          <ReportParameter name="StartDate_BaseValue" binding="StartDate_BaseValue">

            <Prompt>Microsoft.SystemCenter.DataWarehouse.Report.Library!Microsoft.SystemCenter.DataWarehouse.Report.ParameterPrompt.StartDateTime</Prompt>

          </ReportParameter>

          <ReportParameter name="StartDate_OffsetType" binding="StartDate_OffsetType"/>

          <ReportParameter name="StartDate_OffsetValue" binding="StartDate_OffsetValue"/>

          <ReportParameter name="EndDate_BaseType" binding="EndDate_BaseType"/>

          <ReportParameter name="EndDate_BaseValue" binding="EndDate_BaseValue">

            <Prompt>Microsoft.SystemCenter.DataWarehouse.Report.Library!Microsoft.SystemCenter.DataWarehouse.Report.ParameterPrompt.EndDateTime</Prompt>

          </ReportParameter>

          <ReportParameter name="EndDate_OffsetType" binding="EndDate_OffsetType"/>

          <ReportParameter name="EndDate_OffsetValue" binding="EndDate_OffsetValue"/>

        </ReportParameters>

        <Properties>

          <Property name="MaxWidth">

            <Value>400</Value>

          </Property>

        </Properties>

      </Control>

      <Control type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.ComboBox">

        <ReportParameters>

          <ReportParameter name="ActionCriteriaID">

            <Prompt>Microsoft.SystemCenter.DataWarehouse.Report.Library!Microsoft.SystemCenter.DataWarehouse.Report.ParameterPrompt.ActionCriteria</Prompt>

          </ReportParameter>

        </ReportParameters>

      </Control>

      <Control type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.TextBox">

        <ReportParameters>

          <ReportParameter name="Username">

            <Prompt>Microsoft.SystemCenter.DataWarehouse.Report.Library!Microsoft.SystemCenter.DataWarehouse.Report.ParameterPrompt.Username</Prompt>

          </ReportParameter>

        </ReportParameters>

      </Control>

    </Controls>

  </ParameterBlock>

  <Definition>

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

      <AutoRefresh>0</AutoRefresh>

      <DataSources>

        <DataSource Name="DataWarehouseMain">

          <DataSourceReference>Data Warehouse Main</DataSourceReference>

          <rd:SecurityType>None</rd:SecurityType>

          <rd:DataSourceID>e4235c51-407f-4065-8519-a1e57374bc45</rd:DataSourceID>

        </DataSource>

      </DataSources>

      <DataSets>

        <DataSet Name="LT_Report_Query">

          <Query>

            <DataSourceName>DataWarehouseMain</DataSourceName>

            <QueryParameters>

              <QueryParameter Name="@ManagementGroupGuid">

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

              </QueryParameter>

              <QueryParameter Name="@ManagementPackSystemName">

                <Value>ODR</Value>

              </QueryParameter>

              <QueryParameter Name="@ReportSystemName">

                <Value>Microsoft.SystemCenter.DataWarehouse.Report.ManagementPackHistory</Value>

              </QueryParameter>

              <QueryParameter Name="@LanguageCode">

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

              </QueryParameter>

              <QueryParameter Name="@Scope">

                <Value>R.%</Value>

              </QueryParameter>

            </QueryParameters>

            <CommandType>StoredProcedure</CommandType>

            <CommandText>ReportDisplayStringGet</CommandText>

          </Query>

          <Fields>

            <Field Name="ValueXml">

              <DataField>XML_F52E2B61-18A1-11d1-B105-00805F49916B</DataField>

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

            </Field>

            <Field Name="ValueName">

              <Value>="LT"</Value>

            </Field>

          </Fields>

        </DataSet>

        <DataSet Name="LT_Table_Query">

          <Query>

            <DataSourceName>DataWarehouseMain</DataSourceName>

            <QueryParameters>

              <QueryParameter Name="@ManagementGroupGuid">

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

              </QueryParameter>

              <QueryParameter Name="@ManagementPackSystemName">

                <Value>ODR</Value>

              </QueryParameter>

              <QueryParameter Name="@ReportSystemName">

                <Value>Microsoft.SystemCenter.DataWarehouse.Report.ManagementPackHistory</Value>

              </QueryParameter>

              <QueryParameter Name="@LanguageCode">

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

              </QueryParameter>

              <QueryParameter Name="@Scope">

                <Value>RT.%</Value>

              </QueryParameter>

            </QueryParameters>

            <CommandType>StoredProcedure</CommandType>

            <CommandText>ReportDisplayStringGet</CommandText>

          </Query>

          <Fields>

            <Field Name="ValueXml">

              <DataField>XML_F52E2B61-18A1-11d1-B105-00805F49916B</DataField>

            </Field>

            <Field Name="ValueName">

              <Value>="LT"</Value>

            </Field>

          </Fields>

        </DataSet>

        <DataSet Name="ManagementGroups">

          <Query>

            <DataSourceName>DataWarehouseMain</DataSourceName>

            <QueryParameters>

              <QueryParameter Name="@LanguageCode">

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

              </QueryParameter>

            </QueryParameters>

            <CommandText>SELECT     vManagementGroup.ManagementGroupGuid, ISNULL(vDisplayString.Name, vManagementGroup.ManagementGroupDefaultName) AS DisplayName

FROM         vManagementGroup LEFT OUTER JOIN

                      vDisplayString ON vManagementGroup.ManagementGroupGuid = vDisplayString.ElementGuid AND vDisplayString.LanguageCode = @LanguageCode</CommandText>

          </Query>

          <Fields>

            <Field Name="ManagementGroupGuid">

              <DataField>ManagementGroupGuid</DataField>

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

            </Field>

            <Field Name="DisplayName">

              <DataField>DisplayName</DataField>

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

            </Field>

          </Fields>

        </DataSet>

        <DataSet Name="ManagementPacks">

          <Query>

            <DataSourceName>DataWarehouseMain</DataSourceName>

            <QueryParameters>

              <QueryParameter Name="@StartDate">

                <Value>=Code.ToDbDate(Code.GetReportStartDate())</Value>

              </QueryParameter>

              <QueryParameter Name="@EndDate">

                <Value>=Code.ToDbDate(Code.GetReportEndDate())</Value>

              </QueryParameter>

              <QueryParameter Name="@LanguageCode">

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

              </QueryParameter>

              <QueryParameter Name="@ActionCriteriaID">

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

              </QueryParameter>

              <QueryParameter Name="@Username">

                <Value>=Trim(Parameters!Username.Value)</Value>

              </QueryParameter>

            </QueryParameters>

            <CommandType>StoredProcedure</CommandType>

            <CommandText>Microsoft_SystemCenter_DataWarehouse_Report_Library_ManagementPackHistoryReportDataGet</CommandText>

          </Query>

          <Fields>

            <Field Name="ManagementPackSystemName">

              <DataField>ManagementPackSystemName</DataField>

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

            </Field>

            <Field Name="MPDisplayName">

              <DataField>MPDisplayName</DataField>

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

            </Field>

            <Field Name="ManagementPackVersion">

              <DataField>ManagementPackVersion</DataField>

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

            </Field>

            <Field Name="Username">

              <DataField>Username</DataField>

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

            </Field>

            <Field Name="Date">

              <DataField>Date</DataField>

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

            </Field>

            <Field Name="Action">

              <DataField>Action</DataField>

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

            </Field>

          </Fields>

        </DataSet>

      </DataSets>

      <ReportSections>

        <ReportSection>

          <Body><Script>

            <ReportItems>

              <Tablix Name="ManagementPackVersionTable">

                <TablixBody>

                  <TablixColumns>

                    <TablixColumn>

                      <Width>2in</Width>

                    </TablixColumn>

                    <TablixColumn>

                      <Width>1.55in</Width>

                    </TablixColumn>

                    <TablixColumn>

                      <Width>1.27708in</Width>

                    </TablixColumn>

                    <TablixColumn>

                      <Width>1.42292in</Width>

                    </TablixColumn>

                    <TablixColumn>

                      <Width>1.23958in</Width>

                    </TablixColumn>

                    <TablixColumn>

                      <Width>1.40625in</Width>

                    </TablixColumn>

                  </TablixColumns>

                  <TablixRows>

                    <TablixRow>

                      <Height>0.2in</Height>

                      <TablixCells>

                        <TablixCell>

                          <CellContents>

                            <Textbox Name="textbox42">

                              <CanGrow>true</CanGrow>

                              <UserSort>

                                <SortExpression>=Fields!MPDisplayName.Value</SortExpression>

                              </UserSort>

                              <KeepTogether>true</KeepTogether>

                              <Paragraphs>

                                <Paragraph>

                                  <TextRuns>

                                    <TextRun>

                                      <Value>=Code.GetLocTable("LT_Table").GetString("RT.Column.ManagementPack", "[Management Pack]")</Value>

                                      <Style></Style>

                                        <FontFamily>Tahoma</FontFamily>

                                        <FontSize>8pt</FontSize>

                                        <Color>White</Color>

                                      </Style>

                                    </TextRun>

                                  </TextRuns>

                                  <Style></Style>

                                    <FontFamily/>

                                    <TextAlign>Center</TextAlign>

                                  </Style>

                                </Paragraph>

                              </Paragraphs>

                              <ZIndex>5</ZIndex>

                              <DataElementOutput>NoOutput</DataElementOutput>

                              <Style></Style>

                                <Border>

                                  <Color>DimGray</Color>

                                  <Style></Style>Solid</Style>

                                </Border>

                                <BackgroundColor>Gray</BackgroundColor>

                                <VerticalAlign>Middle</VerticalAlign>

                                <PaddingLeft>4pt</PaddingLeft>

                                <PaddingRight>2pt</PaddingRight>

                                <PaddingTop>2pt</PaddingTop>

                                <PaddingBottom>2pt</PaddingBottom>

                              </Style>

                            </Textbox>

                          </CellContents>

                        </TablixCell>

                        <TablixCell>

                          <CellContents>

                            <Textbox Name="textbox43">

                              <CanGrow>true</CanGrow>

                              <UserSort>

                                <SortExpression>=Fields!ManagementPackVersion.Value</SortExpression>

                              </UserSort>

                              <KeepTogether>true</KeepTogether>

                              <Paragraphs>

                                <Paragraph>

                                  <TextRuns>

                                    <TextRun>

                                      <Value>=Code.GetLocTable("LT_Table").GetString("RT.Column.Version", "[Version]")</Value>

                                      <Style></Style>

                                        <FontFamily>Tahoma</FontFamily>

                                        <FontSize>8pt</FontSize>

                                        <Color>White</Color>

                                      </Style>

                                    </TextRun>

                                  </TextRuns>

                                  <Style></Style>

                                    <FontFamily/>

                                    <TextAlign>Center</TextAlign>

                                  </Style>

                                </Paragraph>

                              </Paragraphs>

                              <ZIndex>4</ZIndex>

                              <DataElementOutput>NoOutput</DataElementOutput>

                              <Style></Style>

                                <Border>

                                  <Color>DimGray</Color>

                                  <Style></Style>Solid</Style>

                                </Border>

                                <BackgroundColor>Gray</BackgroundColor>

                                <VerticalAlign>Middle</VerticalAlign>

                                <PaddingLeft>2pt</PaddingLeft>

                                <PaddingRight>2pt</PaddingRight>

                                <PaddingTop>2pt</PaddingTop>

                                <PaddingBottom>2pt</PaddingBottom>

                              </Style>

                            </Textbox>

                          </CellContents>

                        </TablixCell>

                        <TablixCell>

                          <CellContents>

                            <Textbox Name="textbox16">

                              <CanGrow>true</CanGrow>

                              <UserSort>

                                <SortExpression>=Fields!ManagementPackSystemName.Value</SortExpression>

                              </UserSort>

                              <KeepTogether>true</KeepTogether>

                              <Paragraphs>

                                <Paragraph>

                                  <TextRuns>

                                    <TextRun>

                                      <Value>Management Pack System Name</Value>

                                      <Style></Style>

                                        <FontFamily>Tahoma</FontFamily>

                                        <FontSize>8pt</FontSize>

                                        <Color>White</Color>

                                      </Style>

                                    </TextRun>

                                  </TextRuns>

                                  <Style/>

                                </Paragraph>

                              </Paragraphs>

                              <rd:DefaultName>textbox16</rd:DefaultName>

                              <ZIndex>3</ZIndex>

                              <DataElementOutput>NoOutput</DataElementOutput>

                              <Style></Style>

                                <Border>

                                  <Color>DimGray</Color>

                                  <Style></Style>Solid</Style>

                                </Border>

                                <BackgroundColor>Gray</BackgroundColor>

                                <VerticalAlign>Middle</VerticalAlign>

                                <PaddingLeft>2pt</PaddingLeft>

                                <PaddingRight>2pt</PaddingRight>

                                <PaddingTop>2pt</PaddingTop>

                                <PaddingBottom>2pt</PaddingBottom>

                              </Style>

                            </Textbox>

                          </CellContents>

                        </TablixCell>

                        <TablixCell>

                          <CellContents>

                            <Textbox Name="Textbox25">

                              <CanGrow>true</CanGrow>

                              <UserSort>

                                <SortExpression>=Fields!Date.Value</SortExpression>

                              </UserSort>

                              <KeepTogether>true</KeepTogether>

                              <Paragraphs>

                                <Paragraph>

                                  <TextRuns>

                                    <TextRun>

                                      <Value>=Code.GetLocTable("LT_Table").GetString("RT.Column.Date", "[Date]")</Value>

                                      <Style></Style>

                                        <FontFamily>Tahoma</FontFamily>

                                        <FontSize>8pt</FontSize>

                                        <Color>White</Color>

                                      </Style>

                                    </TextRun>

                                  </TextRuns>

                                  <Style/>

                                </Paragraph>

                              </Paragraphs>

                              <rd:DefaultName>Textbox25</rd:DefaultName>

                              <Style></Style>

                                <Border>

                                  <Color>DimGray</Color>

                                  <Style></Style>Solid</Style>

                                </Border>

                                <BackgroundColor>Gray</BackgroundColor>

                                <VerticalAlign>Middle</VerticalAlign>

                                <PaddingLeft>2pt</PaddingLeft>

                                <PaddingRight>2pt</PaddingRight>

                                <PaddingTop>2pt</PaddingTop>

                                <PaddingBottom>2pt</PaddingBottom>

                              </Style>

                            </Textbox>

                          </CellContents>

                        </TablixCell>

                        <TablixCell>

                          <CellContents>

                            <Textbox Name="Textbox22">

                              <CanGrow>true</CanGrow>

                              <UserSort>

                                <SortExpression>=Fields!Action.Value</SortExpression>

                              </UserSort>

                              <KeepTogether>true</KeepTogether>

                              <Paragraphs>

                                <Paragraph>

                                  <TextRuns>

                                    <TextRun>

                                      <Value>=Code.GetLocTable("LT_Table").GetString("RT.Column.Action", "[Action]")</Value>

                                      <Style></Style>

                                        <FontFamily>Tahoma</FontFamily>

                                        <FontSize>8pt</FontSize>

                                        <Color>White</Color>

                                      </Style>

                                    </TextRun>

                                  </TextRuns>

                                  <Style/>

                                </Paragraph>

                              </Paragraphs>

                              <rd:DefaultName>Textbox22</rd:DefaultName>

                              <Style></Style>

                                <Border>

                                  <Color>DimGray</Color>

                                  <Style></Style>Solid</Style>

                                </Border>

                                <BackgroundColor>Gray</BackgroundColor>

                                <VerticalAlign>Middle</VerticalAlign>

                                <PaddingLeft>2pt</PaddingLeft>

                                <PaddingRight>2pt</PaddingRight>

                                <PaddingTop>2pt</PaddingTop>

                                <PaddingBottom>2pt</PaddingBottom>

                              </Style>

                            </Textbox>

                          </CellContents>

                        </TablixCell>

                        <TablixCell>

                          <CellContents>

                            <Textbox Name="Textbox20">

                              <CanGrow>true</CanGrow>

                              <UserSort>

                                <SortExpression>=Fields!Username.Value</SortExpression>

                              </UserSort>

                              <KeepTogether>true</KeepTogether>

                              <Paragraphs>

                                <Paragraph>

                                  <TextRuns>

                                    <TextRun>

                                      <Value>=Code.GetLocTable("LT_Table").GetString("RT.Column.Username", "[Username]")</Value>

                                      <Style></Style>

                                        <FontFamily>Tahoma</FontFamily>

                                        <FontSize>8pt</FontSize>

                                        <Color>White</Color>

                                      </Style>

                                    </TextRun>

                                  </TextRuns>

                                  <Style/>

                                </Paragraph>

                              </Paragraphs>

                              <rd:DefaultName>Textbox20</rd:DefaultName>

                              <Style></Style>

                                <Border>

                                  <Color>DimGray</Color>

                                  <Style></Style>Solid</Style>

                                </Border>

                                <BackgroundColor>Gray</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.2in</Height>

                      <TablixCells>

                        <TablixCell>

                          <CellContents>

                            <Textbox Name="MPName_MPTable">

                              <CanGrow>true</CanGrow>

                              <DataElementStyle>Element</DataElementStyle>

                              <KeepTogether>true</KeepTogether>

                              <Paragraphs>

                                <Paragraph>

                                  <TextRuns>

                                    <TextRun>

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

                                      <Style></Style>

                                        <FontFamily>tahoma</FontFamily>

                                        <FontSize>8pt</FontSize>

                                      </Style>

                                    </TextRun>

                                  </TextRuns>

                                  <Style></Style>

                                    <FontFamily/>

                                    <TextAlign>Left</TextAlign>

                                  </Style>

                                </Paragraph>

                              </Paragraphs>

                              <ZIndex>2</ZIndex>

                              <DataElementName>DefaultName</DataElementName>

                              <Style></Style>

                                <Border>

                                  <Color>DarkGray</Color>

                                  <Style></Style>Solid</Style>

                                </Border>

                                <PaddingLeft>6pt</PaddingLeft>

                                <PaddingRight>2pt</PaddingRight>

                                <PaddingTop>2pt</PaddingTop>

                                <PaddingBottom>2pt</PaddingBottom>

                              </Style>

                            </Textbox>

                          </CellContents>

                        </TablixCell>

                        <TablixCell>

                          <CellContents>

                            <Textbox Name="ManagementPackVersion">

                              <CanGrow>true</CanGrow>

                              <DataElementStyle>Element</DataElementStyle>

                              <KeepTogether>true</KeepTogether>

                              <Paragraphs>

                                <Paragraph>

                                  <TextRuns>

                                    <TextRun>

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

                                      <Style></Style>

                                        <FontFamily>tahoma</FontFamily>

                                        <FontSize>8pt</FontSize>

                                      </Style>

                                    </TextRun>

                                  </TextRuns>

                                  <Style></Style>

                                    <FontFamily/>

                                    <TextAlign>Center</TextAlign>

                                  </Style>

                                </Paragraph>

                              </Paragraphs>

                              <rd:DefaultName>ManagementPackVersion</rd:DefaultName>

                              <ZIndex>1</ZIndex>

                              <DataElementName>Version</DataElementName>

                              <Style></Style>

                                <Border>

                                  <Color>DarkGray</Color>

                                  <Style></Style>Solid</Style>

                                </Border>

                                <PaddingLeft>2pt</PaddingLeft>

                                <PaddingRight>2pt</PaddingRight>

                                <PaddingTop>2pt</PaddingTop>

                                <PaddingBottom>2pt</PaddingBottom>

                              </Style>

                            </Textbox>

                          </CellContents>

                        </TablixCell>

                        <TablixCell>

                          <CellContents>

                            <Textbox Name="ManagementPackSystemName">

                              <CanGrow>true</CanGrow>

                              <DataElementStyle>Attribute</DataElementStyle>

                              <KeepTogether>true</KeepTogether>

                              <Paragraphs>

                                <Paragraph>

                                  <TextRuns>

                                    <TextRun>

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

                                      <Style></Style>

                                        <FontFamily>Tahoma</FontFamily>

                                        <FontSize>8pt</FontSize>

                                      </Style>

                                    </TextRun>

                                  </TextRuns>

                                  <Style/>

                                </Paragraph>

                              </Paragraphs>

                              <rd:DefaultName>ManagementPackSystemName</rd:DefaultName>

                              <DataElementName>SystemName</DataElementName>

                              <DataElementOutput>Output</DataElementOutput>

                              <Style></Style>

                                <Border>

                                  <Color>DarkGray</Color>

                                  <Style></Style>Solid</Style>

                                </Border>

                                <PaddingLeft>2pt</PaddingLeft>

                                <PaddingRight>2pt</PaddingRight>

                                <PaddingTop>2pt</PaddingTop>

                                <PaddingBottom>2pt</PaddingBottom>

                              </Style>

                            </Textbox>

                          </CellContents>

                        </TablixCell>

                        <TablixCell>

                          <CellContents>

                            <Textbox Name="Date">

                              <CanGrow>true</CanGrow>

                              <KeepTogether>true</KeepTogether>

                              <Paragraphs>

                                <Paragraph>

                                  <TextRuns>

                                    <TextRun>

                                      <Value>=Code.FormatDateTime("G",Code.ToReportDate(Min(Fields!Date.Value)))</Value>

                                      <Style></Style>

                                        <FontFamily>Tahoma</FontFamily>

                                        <FontSize>8pt</FontSize>

                                      </Style>

                                    </TextRun>

                                  </TextRuns>

                                  <Style/>

                                </Paragraph>

                              </Paragraphs>

                              <rd:DefaultName>Date</rd:DefaultName>

                              <Style></Style>

                                <Border>

                                  <Color>DarkGray</Color>

                                  <Style></Style>Solid</Style>

                                </Border>

                                <PaddingLeft>2pt</PaddingLeft>

                                <PaddingRight>2pt</PaddingRight>

                                <PaddingTop>2pt</PaddingTop>

                                <PaddingBottom>2pt</PaddingBottom>

                              </Style>

                            </Textbox>

                          </CellContents>

                        </TablixCell>

                        <TablixCell>

                          <CellContents>

                            <Textbox Name="Action">

                              <CanGrow>true</CanGrow>

                              <KeepTogether>true</KeepTogether>

                              <Paragraphs>

                                <Paragraph>

                                  <TextRuns>

                                    <TextRun>

                                      <Value>=Code.GetLocTable("LT_Report").GetString("R.Action_" + Fields!Action.Value.ToString(), "[" + Fields!Action.Value.ToString() + "]")</Value>

                                      <Style></Style>

                                        <FontFamily>Tahoma</FontFamily>

                                        <FontSize>8pt</FontSize>

                                      </Style>

                                    </TextRun>

                                  </TextRuns>

                                  <Style/>

                                </Paragraph>

                              </Paragraphs>

                              <rd:DefaultName>Action</rd:DefaultName>

                              <Style></Style>

                                <Border>

                                  <Color>DarkGray</Color>

                                  <Style></Style>Solid</Style>

                                </Border>

                                <PaddingLeft>2pt</PaddingLeft>

                                <PaddingRight>2pt</PaddingRight>

                                <PaddingTop>2pt</PaddingTop>

                                <PaddingBottom>2pt</PaddingBottom>

                              </Style>

                            </Textbox>

                          </CellContents>

                        </TablixCell>

                        <TablixCell>

                          <CellContents>

                            <Textbox Name="Username">

                              <CanGrow>true</CanGrow>

                              <KeepTogether>true</KeepTogether>

                              <Paragraphs>

                                <Paragraph>

                                  <TextRuns>

                                    <TextRun>

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

                                      <Style></Style>

                                        <FontFamily>Tahoma</FontFamily>

                                        <FontSize>8pt</FontSize>

                                      </Style>

                                    </TextRun>

                                  </TextRuns>

                                  <Style/>

                                </Paragraph>

                              </Paragraphs>

                              <rd:DefaultName>Username</rd:DefaultName>

                              <Style></Style>

                                <Border>

                                  <Color>DarkGray</Color>

                                  <Style></Style>Solid</Style>

                                </Border>

                                <PaddingLeft>2pt</PaddingLeft>

                                <PaddingRight>2pt</PaddingRight>

                                <PaddingTop>2pt</PaddingTop>

                                <PaddingBottom>2pt</PaddingBottom>

                              </Style>

                            </Textbox>

                          </CellContents>

                        </TablixCell>

                      </TablixCells>

                    </TablixRow>

                  </TablixRows>

                </TablixBody>

                <TablixColumnHierarchy>

                  <TablixMembers>

                    <TablixMember/>

                    <TablixMember/>

                    <TablixMember>

                      <Visibility>

                        <Hidden>true</Hidden>

                      </Visibility>

                    </TablixMember>

                    <TablixMember/>

                    <TablixMember/>

                    <TablixMember/>

                  </TablixMembers>

                </TablixColumnHierarchy>

                <TablixRowHierarchy>

                  <TablixMembers>

                    <TablixMember>

                      <KeepWithGroup>After</KeepWithGroup>

                      <RepeatOnNewPage>true</RepeatOnNewPage>

                      <KeepTogether>true</KeepTogether>

                    </TablixMember>

                    <TablixMember>

                      <Group Name="ManagementPackVersionTable_Details_Group">

                        <DataElementName>ManagementPack</DataElementName>

                      </Group>

                      <SortExpressions>

                        <SortExpression>

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

                          <Direction>Descending</Direction>

                        </SortExpression>

                      </SortExpressions>

                      <TablixMembers>

                        <TablixMember/>

                      </TablixMembers>

                      <DataElementName>ManagementPacks</DataElementName>

                      <DataElementOutput>Output</DataElementOutput>

                      <KeepTogether>true</KeepTogether>

                    </TablixMember>

                  </TablixMembers>

                </TablixRowHierarchy>

                <DataSetName>ManagementPacks</DataSetName>

                <Top>3.1in</Top>

                <Left>0.15in</Left>

                <Height>0.4in</Height>

                <Width>8.89583in</Width>

                <DataElementName>ManagementPacksTable</DataElementName>

                <DataElementOutput>Output</DataElementOutput>

                <Style></Style>

                  <FontFamily>Tahoma</FontFamily>

                  <FontSize>8pt</FontSize>

                  <TextAlign>Center</TextAlign>

                </Style>

              </Tablix>

              <Image Name="banner_image">

                <Source>External</Source>

                <Value>../banner_portrait.jpg</Value>

                <Top>0.11042in</Top>

                <Left>0.15in</Left>

                <Height>0.64583in</Height>

                <Width>8.04167in</Width>

                <ZIndex>1</ZIndex>

                <Style/>

              </Image>

              <Rectangle Name="rectangle2">

                <ReportItems>

                  <Textbox Name="textbox26">

                    <CanGrow>true</CanGrow>

                    <CanShrink>true</CanShrink>

                    <KeepTogether>true</KeepTogether>

                    <Paragraphs>

                      <Paragraph>

                        <TextRuns>

                          <TextRun>

                            <Value>=Code.GetLocTable("LT_Report").GetString("R.StartEndTimeLabel", "[Report Start/End Time Label]")</Value>

                            <Style></Style>

                              <FontFamily>Tahoma</FontFamily>

                              <FontSize>8pt</FontSize>

                            </Style>

                          </TextRun>

                        </TextRuns>

                        <Style/>

                      </Paragraph>

                    </Paragraphs>

                    <Top>0.25in</Top>

                    <Left>0.25in</Left>

                    <Height>0.2in</Height>

                    <Width>1.65in</Width>

                    <DataElementOutput>NoOutput</DataElementOutput>

                    <Style></Style>

                      <PaddingLeft>2pt</PaddingLeft>

                      <PaddingRight>2pt</PaddingRight>

                      <PaddingTop>2pt</PaddingTop>

                      <PaddingBottom>2pt</PaddingBottom>

                    </Style>

                  </Textbox>

                  <Textbox Name="textbox1">

                    <CanGrow>true</CanGrow>

                    <CanShrink>true</CanShrink>

                    <KeepTogether>true</KeepTogether>

                    <Paragraphs>

                      <Paragraph>

                        <TextRuns>

                          <TextRun>

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

                            <Style></Style>

                              <FontFamily>Tahoma</FontFamily>

                              <FontSize>8pt</FontSize>

                            </Style>

                          </TextRun>

                        </TextRuns>

                        <Style/>

                      </Paragraph>

                    </Paragraphs>

                    <Top>0.05in</Top>

                    <Left>0.25in</Left>

                    <Height>0.2in</Height>

                    <Width>1.65in</Width>

                    <ZIndex>1</ZIndex>

                    <DataElementOutput>NoOutput</DataElementOutput>

                    <Style></Style>

                      <PaddingLeft>2pt</PaddingLeft>

                      <PaddingRight>2pt</PaddingRight>

                      <PaddingTop>2pt</PaddingTop>

                      <PaddingBottom>2pt</PaddingBottom>

                    </Style>

                  </Textbox>

                  <Textbox Name="textbox2">

                    <CanGrow>true</CanGrow>

                    <CanShrink>true</CanShrink>

                    <KeepTogether>true</KeepTogether>

                    <Paragraphs>

                      <Paragraph>

                        <TextRuns>

                          <TextRun>

                            <Value>:</Value>

                            <Style></Style>

                              <FontFamily>Tahoma</FontFamily>

                              <FontSize>8pt</FontSize>

                            </Style>

                          </TextRun>

                        </TextRuns>

                        <Style/>

                      </Paragraph>

                    </Paragraphs>

                    <Top>0.05in</Top>

                    <Left>1.9in</Left>

                    <Height>0.2in</Height>

                    <Width>0.1in</Width>

                    <ZIndex>2</ZIndex>

                    <DataElementOutput>NoOutput</DataElementOutput>

                    <Style></Style>

                      <PaddingLeft>2pt</PaddingLeft>

                      <PaddingRight>2pt</PaddingRight>

                      <PaddingTop>2pt</PaddingTop>

                      <PaddingBottom>2pt</PaddingBottom>

                    </Style>

                  </Textbox>

                  <Textbox Name="textbox7">

                    <CanGrow>true</CanGrow>

                    <CanShrink>true</CanShrink>

                    <KeepTogether>true</KeepTogether>

                    <Paragraphs>

                      <Paragraph>

                        <TextRuns>

                          <TextRun>

                            <Value>:</Value>

                            <Style></Style>

                              <FontFamily>Tahoma</FontFamily>

                              <FontSize>8pt</FontSize>

                            </Style>

                          </TextRun>

                        </TextRuns>

                        <Style/>

                      </Paragraph>

                    </Paragraphs>

                    <Top>0.25in</Top>

                    <Left>1.9in</Left>

                    <Height>0.2in</Height>

                    <Width>0.1in</Width>

                    <ZIndex>3</ZIndex>

                    <DataElementOutput>NoOutput</DataElementOutput>

                    <Style></Style>

                      <PaddingLeft>2pt</PaddingLeft>

                      <PaddingRight>2pt</PaddingRight>

                      <PaddingTop>2pt</PaddingTop>

                      <PaddingBottom>2pt</PaddingBottom>

                    </Style>

                  </Textbox>

                  <Textbox Name="textbox9">

                    <CanGrow>true</CanGrow>

                    <CanShrink>true</CanShrink>

                    <DataElementStyle>Element</DataElementStyle>

                    <KeepTogether>true</KeepTogether>

                    <Paragraphs>

                      <Paragraph>

                        <TextRuns>

                          <TextRun>

                            <Value>=Code.FormatDateTime("g", Code.ToReportDate(DateTime.UtcNow))</Value>

                            <Style></Style>

                              <FontFamily>Tahoma</FontFamily>

                              <FontSize>8pt</FontSize>

                            </Style>

                          </TextRun>

                        </TextRuns>

                        <Style/>

                      </Paragraph>

                    </Paragraphs>

                    <Top>0.05in</Top>

                    <Left>2in</Left>

                    <Height>0.2in</Height>

                    <Width>6.05in</Width>

                    <ZIndex>4</ZIndex>

                    <DataElementName>Created</DataElementName>

                    <DataElementOutput>Output</DataElementOutput>

                    <Style></Style>

                      <PaddingLeft>2pt</PaddingLeft>

                      <PaddingRight>2pt</PaddingRight>

                      <PaddingTop>2pt</PaddingTop>

                      <PaddingBottom>2pt</PaddingBottom>

                    </Style>

                  </Textbox>

                  <Image Name="parameterBottomImage">

                    <Source>External</Source>

                    <Value>../gradient_portrait.gif</Value>

                    <Sizing>Fit</Sizing>

                    <Top>0.99792in</Top>

                    <Height>0.05in</Height>

                    <Width>8.05in</Width>

                    <ZIndex>5</ZIndex>

                    <Style/>

                  </Image>

                  <Textbox Name="textbox21">

                    <CanGrow>true</CanGrow>

                    <CanShrink>true</CanShrink>

                    <DataElementStyle>Element</DataElementStyle>

                    <KeepTogether>true</KeepTogether>

                    <Paragraphs>

                      <Paragraph>

                        <TextRuns>

                          <TextRun>

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

                            <Style></Style>

                              <FontSize>8pt</FontSize>

                            </Style>

                          </TextRun>

                        </TextRuns>

                        <Style/>

                      </Paragraph>

                    </Paragraphs>

                    <Top>0.25in</Top>

                    <Left>0.05in</Left>

                    <Height>0.2in</Height>

                    <Width>0.05in</Width>

                    <ZIndex>6</ZIndex>

                    <Visibility>

                      <Hidden>true</Hidden>

                    </Visibility>

                    <DataElementName>StartDate</DataElementName>

                    <DataElementOutput>Output</DataElementOutput>

                    <Style></Style>

                      <PaddingLeft>2pt</PaddingLeft>

                      <PaddingRight>2pt</PaddingRight>

                      <PaddingTop>2pt</PaddingTop>

                      <PaddingBottom>2pt</PaddingBottom>

                    </Style>

                  </Textbox>

                  <Textbox Name="textbox19">

                    <CanGrow>true</CanGrow>

                    <CanShrink>true</CanShrink>

                    <DataElementStyle>Element</DataElementStyle>

                    <KeepTogether>true</KeepTogether>

                    <Paragraphs>

                      <Paragraph>

                        <TextRuns>

                          <TextRun>

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

                            <Style></Style>

                              <FontSize>8pt</FontSize>

                            </Style>

                          </TextRun>

                        </TextRuns>

                        <Style/>

                      </Paragraph>

                    </Paragraphs>

                    <Top>0.25in</Top>

                    <Left>0.1in</Left>

                    <Height>0.2in</Height>

                    <Width>0.05in</Width>

                    <ZIndex>7</ZIndex>

                    <Visibility>

                      <Hidden>true</Hidden>

                    </Visibility>

                    <DataElementName>EndDate</DataElementName>

                    <DataElementOutput>Output</DataElementOutput>

                    <Style></Style>

                      <PaddingLeft>2pt</PaddingLeft>

                      <PaddingRight>2pt</PaddingRight>

                      <PaddingTop>2pt</PaddingTop>

                      <PaddingBottom>2pt</PaddingBottom>

                    </Style>

                  </Textbox>

                  <Textbox Name="textbox17">

                    <CanGrow>true</CanGrow>

                    <CanShrink>true</CanShrink>

                    <DataElementStyle>Element</DataElementStyle>

                    <KeepTogether>true</KeepTogether>

                    <Paragraphs>

                      <Paragraph>

                        <TextRuns>

                          <TextRun>

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

                            <Style></Style>

                              <FontSize>8pt</FontSize>

                            </Style>

                          </TextRun>

                        </TextRuns>

                        <Style/>

                      </Paragraph>

                    </Paragraphs>

                    <Top>0.25in</Top>

                    <Left>0.15in</Left>

                    <Height>0.2in</Height>

                    <Width>0.05in</Width>

                    <ZIndex>8</ZIndex>

                    <Visibility>

                      <Hidden>true</Hidden>

                    </Visibility>

                    <DataElementName>TimeZone</DataElementName>

                    <DataElementOutput>Output</DataElementOutput>

                    <Style></Style>

                      <PaddingLeft>2pt</PaddingLeft>

                      <PaddingRight>2pt</PaddingRight>

                      <PaddingTop>2pt</PaddingTop>

                      <PaddingBottom>2pt</PaddingBottom>

                    </Style>

                  </Textbox>

                  <Textbox Name="textbox28">

                    <CanGrow>true</CanGrow>

                    <CanShrink>true</CanShrink>

                    <KeepTogether>true</KeepTogether>

                    <Paragraphs>

                      <Paragraph>

                        <TextRuns>

                          <TextRun>

                            <Value>=Code.FormatString(Code.GetLocTable("LT_Report").GetString("R.StartEndTimeFormat", "{0} - {1}"), Code.FormatDateTime("g", Code.GetReportStartDate()), Code.FormatDateTime("g", Code.GetReportEndDate()))</Value>

                            <Style></Style>

                              <FontFamily>Tahoma</FontFamily>

                              <FontSize>8pt</FontSize>

                            </Style>

                          </TextRun>

                        </TextRuns>

                        <Style/>

                      </Paragraph>

                    </Paragraphs>

                    <Top>0.25in</Top>

                    <Left>2in</Left>

                    <Height>0.2in</Height>

                    <Width>6.05in</Width>

                    <ZIndex>9</ZIndex>

                    <DataElementOutput>NoOutput</DataElementOutput>

                    <Style></Style>

                      <PaddingLeft>2pt</PaddingLeft>

                      <PaddingRight>2pt</PaddingRight>

                      <PaddingTop>2pt</PaddingTop>

                      <PaddingBottom>2pt</PaddingBottom>

                    </Style>

                  </Textbox>

                  <Textbox Name="textbox27">

                    <CanGrow>true</CanGrow>

                    <CanShrink>true</CanShrink>

                    <KeepTogether>true</KeepTogether>

                    <Paragraphs>

                      <Paragraph>

                        <TextRuns>

                          <TextRun>

                            <Value>=Code.GetLocTable("LT_Report").GetString("R.ActionCriteriaLabel", "[Action Criteria]")</Value>

                            <Style></Style>

                              <FontFamily>Tahoma</FontFamily>

                              <FontSize>8pt</FontSize>

                            </Style>

                          </TextRun>

                        </TextRuns>

                        <Style/>

                      </Paragraph>

                    </Paragraphs>

                    <Top>0.46389in</Top>

                    <Left>0.25in</Left>

                    <Height>0.2in</Height>

                    <Width>1.65in</Width>

                    <ZIndex>10</ZIndex>

                    <DataElementOutput>NoOutput</DataElementOutput>

                    <Style></Style>

                      <PaddingLeft>2pt</PaddingLeft>

                      <PaddingRight>2pt</PaddingRight>

                      <PaddingTop>2pt</PaddingTop>

                      <PaddingBottom>2pt</PaddingBottom>

                    </Style>

                  </Textbox>

                  <Textbox Name="textbox820">

                    <CanGrow>true</CanGrow>

                    <CanShrink>true</CanShrink>

                    <KeepTogether>true</KeepTogether>

                    <Paragraphs>

                      <Paragraph>

                        <TextRuns>

                          <TextRun>

                            <Value>:</Value>

                            <Style></Style>

                              <FontFamily>Tahoma</FontFamily>

                              <FontSize>8pt</FontSize>

                            </Style>

                          </TextRun>

                        </TextRuns>

                        <Style/>

                      </Paragraph>

                    </Paragraphs>

                    <Top>0.46389in</Top>

                    <Left>1.9in</Left>

                    <Height>0.2in</Height>

                    <Width>0.1in</Width>

                    <ZIndex>11</ZIndex>

                    <DataElementOutput>NoOutput</DataElementOutput>

                    <Style></Style>

                      <PaddingLeft>2pt</PaddingLeft>

                      <PaddingRight>2pt</PaddingRight>

                      <PaddingTop>2pt</PaddingTop>

                      <PaddingBottom>2pt</PaddingBottom>

                    </Style>

                  </Textbox>

                  <Textbox Name="textbox29">

                    <CanGrow>true</CanGrow>

                    <CanShrink>true</CanShrink>

                    <KeepTogether>true</KeepTogether>

                    <Paragraphs>

                      <Paragraph>

                        <TextRuns>

                          <TextRun>

                            <Value>=Code.GetLocTable("LT_Report").GetString("R.Action_" + Parameters!ActionCriteriaID.Value.ToString(), "[" + Parameters!ActionCriteriaID.Value.ToString() + "]")</Value>

                            <Style></Style>

                              <FontFamily>Tahoma</FontFamily>

                              <FontSize>8pt</FontSize>

                            </Style>

                          </TextRun>

                        </TextRuns>

                        <Style/>

                      </Paragraph>

                    </Paragraphs>

                    <Top>0.46389in</Top>

                    <Left>2in</Left>

                    <Height>0.2in</Height>

                    <Width>6.05in</Width>

                    <ZIndex>12</ZIndex>

                    <DataElementOutput>NoOutput</DataElementOutput>

                    <Style></Style>

                      <PaddingLeft>2pt</PaddingLeft>

                      <PaddingRight>2pt</PaddingRight>

                      <PaddingTop>2pt</PaddingTop>

                      <PaddingBottom>2pt</PaddingBottom>

                    </Style>

                  </Textbox>

                  <Textbox Name="textbox30">

                    <CanGrow>true</CanGrow>

                    <CanShrink>true</CanShrink>

                    <KeepTogether>true</KeepTogether>

                    <Paragraphs>

                      <Paragraph>

                        <TextRuns>

                          <TextRun>

                            <Value>=Trim(Parameters!Username.Value)</Value>

                            <Style></Style>

                              <FontFamily>Tahoma</FontFamily>

                              <FontSize>8pt</FontSize>

                            </Style>

                          </TextRun>

                        </TextRuns>

                        <Style/>

                      </Paragraph>

                    </Paragraphs>

                    <Top>0.66389in</Top>

                    <Left>2in</Left>

                    <Height>0.2in</Height>

                    <Width>6.05in</Width>

                    <ZIndex>13</ZIndex>

                    <Visibility>

                      <Hidden>=IIF((Len(Trim(Parameters!Username.Value)) &gt; 0), False, True)</Hidden>

                    </Visibility>

                    <DataElementOutput>NoOutput</DataElementOutput>

                    <Style></Style>

                      <PaddingLeft>2pt</PaddingLeft>

                      <PaddingRight>2pt</PaddingRight>

                      <PaddingTop>2pt</PaddingTop>

                      <PaddingBottom>2pt</PaddingBottom>

                    </Style>

                  </Textbox>

                  <Textbox Name="textbox821">

                    <CanGrow>true</CanGrow>

                    <CanShrink>true</CanShrink>

                    <KeepTogether>true</KeepTogether>

                    <Paragraphs>

                      <Paragraph>

                        <TextRuns>

                          <TextRun>

                            <Value>:</Value>

                            <Style></Style>

                              <FontFamily>Tahoma</FontFamily>

                              <FontSize>8pt</FontSize>

                            </Style>

                          </TextRun>

                        </TextRuns>

                        <Style/>

                      </Paragraph>

                    </Paragraphs>

                    <Top>0.66389in</Top>

                    <Left>1.9in</Left>

                    <Height>0.2in</Height>

                    <Width>0.1in</Width>

                    <ZIndex>14</ZIndex>

                    <Visibility>

                      <Hidden>=IIF((Len(Trim(Parameters!Username.Value)) &gt; 0), False, True)</Hidden>

                    </Visibility>

                    <DataElementOutput>NoOutput</DataElementOutput>

                    <Style></Style>

                      <PaddingLeft>2pt</PaddingLeft>

                      <PaddingRight>2pt</PaddingRight>

                      <PaddingTop>2pt</PaddingTop>

                      <PaddingBottom>2pt</PaddingBottom>

                    </Style>

                  </Textbox>

                  <Textbox Name="textbox31">

                    <CanGrow>true</CanGrow>

                    <CanShrink>true</CanShrink>

                    <KeepTogether>true</KeepTogether>

                    <Paragraphs>

                      <Paragraph>

                        <TextRuns>

                          <TextRun>

                            <Value>=Code.GetLocTable("LT_Report").GetString("R.UserCriteriaLabel", "[User Criteria]")</Value>

                            <Style></Style>

                              <FontFamily>Tahoma</FontFamily>

                              <FontSize>8pt</FontSize>

                            </Style>

                          </TextRun>

                        </TextRuns>

                        <Style/>

                      </Paragraph>

                    </Paragraphs>

                    <Top>0.66389in</Top>

                    <Left>0.25in</Left>

                    <Height>0.2in</Height>

                    <Width>1.65in</Width>

                    <ZIndex>15</ZIndex>

                    <Visibility>

                      <Hidden>=IIF((Len(Trim(Parameters!Username.Value)) &gt; 0), False, True)</Hidden>

                    </Visibility>

                    <DataElementOutput>NoOutput</DataElementOutput>

                    <Style></Style>

                      <PaddingLeft>2pt</PaddingLeft>

                      <PaddingRight>2pt</PaddingRight>

                      <PaddingTop>2pt</PaddingTop>

                      <PaddingBottom>2pt</PaddingBottom>

                    </Style>

                  </Textbox>

                </ReportItems>

                <DataElementOutput>ContentsOnly</DataElementOutput>

                <Top>1.55625in</Top>

                <Left>0.1in</Left>

                <Height>1.6in</Height>

                <Width>8.1in</Width>

                <ZIndex>2</ZIndex>

                <Style/>

              </Rectangle>

              <Rectangle Name="rectangle3">

                <ReportItems>

                  <Textbox Name="reportDescription">

                    <CanGrow>true</CanGrow>

                    <KeepTogether>true</KeepTogether>

                    <Paragraphs>

                      <Paragraph>

                        <TextRuns>

                          <TextRun>

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

                            <Style></Style>

                              <FontFamily>Tahoma</FontFamily>

                              <FontSize>8pt</FontSize>

                            </Style>

                          </TextRun>

                        </TextRuns>

                        <Style/>

                      </Paragraph>

                    </Paragraphs>

                    <Left>0.2in</Left>

                    <Height>0.2in</Height>

                    <Width>7.8in</Width>

                    <DataElementOutput>NoOutput</DataElementOutput>

                    <Style></Style>

                      <PaddingLeft>2pt</PaddingLeft>

                      <PaddingRight>2pt</PaddingRight>

                      <PaddingTop>2pt</PaddingTop>

                      <PaddingBottom>2pt</PaddingBottom>

                    </Style>

                  </Textbox>

                </ReportItems>

                <DataElementOutput>ContentsOnly</DataElementOutput>

                <Top>1.30625in</Top>

                <Left>0.15in</Left>

                <Height>0.2in</Height>

                <Width>8.05in</Width>

                <ZIndex>3</ZIndex>

                <Visibility>

                  <Hidden>true</Hidden>

                  <ToggleItem>reportDescriptionTitle</ToggleItem>

                </Visibility>

                <Style></Style>

                  <BackgroundColor>Gainsboro</BackgroundColor>

                </Style>

              </Rectangle>

              <Rectangle Name="rectangle4">

                <ReportItems>

                  <Textbox Name="reportTitle">

                    <CanGrow>true</CanGrow>

                    <DataElementStyle>Element</DataElementStyle>

                    <KeepTogether>true</KeepTogether>

                    <Paragraphs>

                      <Paragraph>

                        <TextRuns>

                          <TextRun>

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

                            <Style></Style>

                              <FontFamily>Tahoma</FontFamily>

                              <FontSize>11pt</FontSize>

                              <FontWeight>Bold</FontWeight>

                            </Style>

                          </TextRun>

                        </TextRuns>

                        <Style/>

                      </Paragraph>

                    </Paragraphs>

                    <Top>0.05in</Top>

                    <Left>0.2in</Left>

                    <Height>0.25in</Height>

                    <Width>7.8in</Width>

                    <DataElementName>Title</DataElementName>

                    <DataElementOutput>Output</DataElementOutput>

                    <Style></Style>

                      <PaddingLeft>2pt</PaddingLeft>

                      <PaddingRight>2pt</PaddingRight>

                      <PaddingTop>2pt</PaddingTop>

                      <PaddingBottom>2pt</PaddingBottom>

                    </Style>

                  </Textbox>

                  <Textbox Name="reportDescriptionTitle">

                    <CanGrow>true</CanGrow>

                    <KeepTogether>true</KeepTogether>

                    <Paragraphs>

                      <Paragraph>

                        <TextRuns>

                          <TextRun>

                            <Value>=Code.GetLocTable("LT_Report").GetString("R.DescriptionTitle", "[Report Description Title]")</Value>

                            <Style></Style>

                              <FontFamily>Tahoma</FontFamily>

                              <FontSize>8pt</FontSize>

                              <Color>DimGray</Color>

                            </Style>

                          </TextRun>

                        </TextRuns>

                        <Style/>

                      </Paragraph>

                    </Paragraphs>

                    <Top>0.3in</Top>

                    <Height>0.2in</Height>

                    <Width>8in</Width>

                    <ZIndex>1</ZIndex>

                    <DataElementOutput>NoOutput</DataElementOutput>

                    <Style></Style>

                      <VerticalAlign>Middle</VerticalAlign>

                      <PaddingLeft>2pt</PaddingLeft>

                      <PaddingRight>2pt</PaddingRight>

                      <PaddingTop>2pt</PaddingTop>

                      <PaddingBottom>2pt</PaddingBottom>

                    </Style>

                  </Textbox>

                </ReportItems>

                <DataElementOutput>ContentsOnly</DataElementOutput>

                <Top>0.75625in</Top>

                <Left>0.15in</Left>

                <Height>0.55in</Height>

                <Width>8.05in</Width>

                <ZIndex>4</ZIndex>

                <Style></Style>

                  <BackgroundColor>Gainsboro</BackgroundColor>

                </Style>

              </Rectangle>

              <Rectangle Name="rectangle5">

                <DataElementOutput>ContentsOnly</DataElementOutput>

                <Top>1.50625in</Top>

                <Left>0.15in</Left>

                <Height>0.05in</Height>

                <Width>8.05in</Width>

                <ZIndex>5</ZIndex>

                <Style></Style>

                  <Border>

                    <Color>DarkGray</Color>

                  </Border>

                  <BottomBorder>

                    <Style></Style>Solid</Style>

                  </BottomBorder>

                  <BackgroundColor>Gainsboro</BackgroundColor>

                </Style>

              </Rectangle>

              <Textbox Name="textbox3">

                <CanGrow>true</CanGrow>

                <KeepTogether>true</KeepTogether>

                <Paragraphs>

                  <Paragraph>

                    <TextRuns>

                      <TextRun>

                        <Value>=Code.GetLocTable("LT_Report").GetString("R.Table1Title", "[What Version of MPs are installed]")</Value>

                        <Style></Style>

                          <FontFamily>Tahoma</FontFamily>

                          <FontWeight>Bold</FontWeight>

                        </Style>

                      </TextRun>

                    </TextRuns>

                    <Style/>

                  </Paragraph>

                </Paragraphs>

                <rd:DefaultName>textbox3</rd:DefaultName>

                <Top>2.85in</Top>

                <Left>0.15in</Left>

                <Height>0.25in</Height>

                <Width>8.05in</Width>

                <ZIndex>6</ZIndex>

                <DataElementOutput>NoOutput</DataElementOutput>

                <Style></Style>

                  <PaddingLeft>2pt</PaddingLeft>

                  <PaddingRight>2pt</PaddingRight>

                  <PaddingTop>2pt</PaddingTop>

                  <PaddingBottom>2pt</PaddingBottom>

                </Style>

              </Textbox>

            </ReportItems>

            <Height>5.5in</Height>

            <Style/>

          </Script></Body>

          <Width>9.6in</Width>

          <Page>

            <PageFooter>

              <Height>0.35in</Height>

              <PrintOnFirstPage>true</PrintOnFirstPage>

              <PrintOnLastPage>true</PrintOnLastPage>

              <ReportItems>

                <Textbox Name="textbox37">

                  <CanGrow>true</CanGrow>

                  <KeepTogether>true</KeepTogether>

                  <Paragraphs>

                    <Paragraph>

                      <TextRuns>

                        <TextRun>

                          <Value>=string.Format(Code.GetLocTable("LT_Report").GetString("R.TimeZoneFormat", "{0}"), Parameters!TimeZoneName.Value)</Value>

                          <Style></Style>

                            <FontFamily>Tahoma</FontFamily>

                            <FontSize>8pt</FontSize>

                            <Color>DimGray</Color>

                          </Style>

                        </TextRun>

                      </TextRuns>

                      <Style/>

                    </Paragraph>

                  </Paragraphs>

                  <Top>0.1in</Top>

                  <Left>0.15in</Left>

                  <Height>0.1875in</Height>

                  <Width>5.03125in</Width>

                  <Style></Style>

                    <PaddingLeft>2pt</PaddingLeft>

                    <PaddingRight>2pt</PaddingRight>

                    <PaddingTop>2pt</PaddingTop>

                    <PaddingBottom>2pt</PaddingBottom>

                  </Style>

                </Textbox>

                <Textbox Name="textbox8">

                  <CanGrow>true</CanGrow>

                  <KeepTogether>true</KeepTogether>

                  <Paragraphs>

                    <Paragraph>

                      <TextRuns>

                        <TextRun>

                          <Value>=string.Format(Code.GetLocTable("LT_Report").GetString("R.PageFormat", "{0}/{1}"), Globals!PageNumber, Globals!TotalPages)</Value>

                          <Style></Style>

                            <FontFamily>Tahoma</FontFamily>

                            <FontSize>8pt</FontSize>

                            <Color>DimGray</Color>

                          </Style>

                        </TextRun>

                      </TextRuns>

                      <Style></Style>

                        <TextAlign>Right</TextAlign>

                      </Style>

                    </Paragraph>

                  </Paragraphs>

                  <Top>0.1in</Top>

                  <Left>6.21875in</Left>

                  <Height>0.1875in</Height>

                  <Width>1.7in</Width>

                  <ZIndex>1</ZIndex>

                  <Style></Style>

                    <PaddingLeft>2pt</PaddingLeft>

                    <PaddingRight>2pt</PaddingRight>

                    <PaddingTop>2pt</PaddingTop>

                    <PaddingBottom>2pt</PaddingBottom>

                  </Style>

                </Textbox>

              </ReportItems>

              <Style/>

            </PageFooter>

            <TopMargin>0.2in</TopMargin>

            <Style/>

          </Page>

        </ReportSection>

      </ReportSections>

      <ReportParameters>

        <ReportParameter Name="LT_Report">

          <DataType>String</DataType>

          <DefaultValue>

            <DataSetReference>

              <DataSetName>LT_Report_Query</DataSetName>

              <ValueField>ValueXml</ValueField>

            </DataSetReference>

          </DefaultValue>

          <Hidden>true</Hidden>

          <ValidValues>

            <DataSetReference>

              <DataSetName>LT_Report_Query</DataSetName>

              <ValueField>ValueXml</ValueField>

              <LabelField>ValueName</LabelField>

            </DataSetReference>

          </ValidValues>

        </ReportParameter>

        <ReportParameter Name="LT_Table">

          <DataType>String</DataType>

          <DefaultValue>

            <DataSetReference>

              <DataSetName>LT_Table_Query</DataSetName>

              <ValueField>ValueXml</ValueField>

            </DataSetReference>

          </DefaultValue>

          <Hidden>true</Hidden>

          <ValidValues>

            <DataSetReference>

              <DataSetName>LT_Table_Query</DataSetName>

              <ValueField>ValueXml</ValueField>

              <LabelField>ValueName</LabelField>

            </DataSetReference>

          </ValidValues>

        </ReportParameter>

        <ReportParameter Name="ActionCriteriaID">

          <DataType>Integer</DataType>

          <DefaultValue>

            <Values>

              <Value>0</Value>

            </Values>

          </DefaultValue>

          <AllowBlank>true</AllowBlank>

          <Prompt>[Action Criteria]</Prompt>

          <ValidValues>

            <ParameterValues>

              <ParameterValue>

                <Value>0</Value>

                <Label>=Code.GetLocTable("LT_Report").GetString("R.Action_0", "[All]")</Label>

              </ParameterValue>

              <ParameterValue>

                <Value>1</Value>

                <Label>=Code.GetLocTable("LT_Report").GetString("R.Action_1", "[Install]")</Label>

              </ParameterValue>

              <ParameterValue>

                <Value>2</Value>

                <Label>=Code.GetLocTable("LT_Report").GetString("R.Action_2", "[Delete]")</Label>

              </ParameterValue>

            </ParameterValues>

          </ValidValues>

        </ReportParameter>

        <ReportParameter Name="StartDate_BaseType">

          <DataType>String</DataType>

          <DefaultValue>

            <Values>

              <Value>="Today"</Value>

            </Values>

          </DefaultValue>

          <Prompt>[Start Date Base]</Prompt>

        </ReportParameter>

        <ReportParameter Name="StartDate_BaseValue">

          <DataType>DateTime</DataType>

          <DefaultValue>

            <Values>

              <Value>=Now()</Value>

            </Values>

          </DefaultValue>

          <Prompt>[Start Date Value]</Prompt>

        </ReportParameter>

        <ReportParameter Name="StartDate_OffsetType">

          <DataType>String</DataType>

          <DefaultValue>

            <Values>

              <Value>="Day"</Value>

            </Values>

          </DefaultValue>

          <Prompt>[Start Date Offset Type]</Prompt>

        </ReportParameter>

        <ReportParameter Name="StartDate_OffsetValue">

          <DataType>Integer</DataType>

          <DefaultValue>

            <Values>

              <Value>=-7</Value>

            </Values>

          </DefaultValue>

          <AllowBlank>true</AllowBlank>

          <Prompt>[Start Date Offset]</Prompt>

        </ReportParameter>

        <ReportParameter Name="EndDate_BaseType">

          <DataType>String</DataType>

          <DefaultValue>

            <Values>

              <Value>="Today"</Value>

            </Values>

          </DefaultValue>

          <Prompt>[End Date Base]</Prompt>

        </ReportParameter>

        <ReportParameter Name="EndDate_BaseValue">

          <DataType>DateTime</DataType>

          <DefaultValue>

            <Values>

              <Value>=Now()</Value>

            </Values>

          </DefaultValue>

          <Prompt>[End Date Value]</Prompt>

        </ReportParameter>

        <ReportParameter Name="EndDate_OffsetType">

          <DataType>String</DataType>

          <DefaultValue>

            <Values>

              <Value>="None"</Value>

            </Values>

          </DefaultValue>

          <Prompt>[End Date Offset Type]</Prompt>

        </ReportParameter>

        <ReportParameter Name="EndDate_OffsetValue">

          <DataType>Integer</DataType>

          <DefaultValue>

            <Values>

              <Value>=0</Value>

            </Values>

          </DefaultValue>

          <AllowBlank>true</AllowBlank>

          <Prompt>[End Date Offset]</Prompt>

        </ReportParameter>

        <ReportParameter Name="TimeZone">

          <DataType>String</DataType>

          <Prompt>[Time Zone]</Prompt>

        </ReportParameter>

        <ReportParameter Name="TimeZoneName">

          <DataType>String</DataType>

          <Nullable>true</Nullable>

          <DefaultValue>

            <Values>

              <Value xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/>

            </Values>

          </DefaultValue>

          <AllowBlank>true</AllowBlank>

          <Prompt>[Time Zone Name]</Prompt>

        </ReportParameter>

        <ReportParameter Name="Interactive">

          <DataType>Boolean</DataType>

          <Nullable>true</Nullable>

          <DefaultValue>

            <Values>

              <Value>=False</Value>

            </Values>

          </DefaultValue>

          <Prompt>Interactive</Prompt>

          <Hidden>true</Hidden>

        </ReportParameter>

        <ReportParameter Name="Username">

          <DataType>String</DataType>

          <AllowBlank>true</AllowBlank>

          <Prompt>[Username]</Prompt>

        </ReportParameter>

      </ReportParameters>

      <ReportParametersLayout>

        <GridLayoutDefinition>

          <NumberOfColumns>8</NumberOfColumns>

          <NumberOfRows>10</NumberOfRows>

          <CellDefinitions>

            <CellDefinition>

              <ColumnIndex>0</ColumnIndex>

              <RowIndex>0</RowIndex>

              <ParameterName>LT_Report</ParameterName>

            </CellDefinition>

            <CellDefinition>

              <ColumnIndex>1</ColumnIndex>

              <RowIndex>0</RowIndex>

              <ParameterName>LT_Table</ParameterName>

            </CellDefinition>

            <CellDefinition>

              <ColumnIndex>0</ColumnIndex>

              <RowIndex>3</RowIndex>

              <ParameterName>StartDate_BaseType</ParameterName>

            </CellDefinition>

            <CellDefinition>

              <ColumnIndex>1</ColumnIndex>

              <RowIndex>3</RowIndex>

              <ParameterName>StartDate_BaseValue</ParameterName>

            </CellDefinition>

            <CellDefinition>

              <ColumnIndex>0</ColumnIndex>

              <RowIndex>4</RowIndex>

              <ParameterName>StartDate_OffsetType</ParameterName>

            </CellDefinition>

            <CellDefinition>

              <ColumnIndex>1</ColumnIndex>

              <RowIndex>4</RowIndex>

              <ParameterName>StartDate_OffsetValue</ParameterName>

            </CellDefinition>

            <CellDefinition>

              <ColumnIndex>0</ColumnIndex>

              <RowIndex>5</RowIndex>

              <ParameterName>EndDate_BaseType</ParameterName>

            </CellDefinition>

            <CellDefinition>

              <ColumnIndex>1</ColumnIndex>

              <RowIndex>5</RowIndex>

              <ParameterName>EndDate_BaseValue</ParameterName>

            </CellDefinition>

            <CellDefinition>

              <ColumnIndex>0</ColumnIndex>

              <RowIndex>6</RowIndex>

              <ParameterName>EndDate_OffsetType</ParameterName>

            </CellDefinition>

            <CellDefinition>

              <ColumnIndex>1</ColumnIndex>

              <RowIndex>6</RowIndex>

              <ParameterName>EndDate_OffsetValue</ParameterName>

            </CellDefinition>

            <CellDefinition>

              <ColumnIndex>0</ColumnIndex>

              <RowIndex>8</RowIndex>

              <ParameterName>ActionCriteriaID</ParameterName>

            </CellDefinition>

            <CellDefinition>

              <ColumnIndex>0</ColumnIndex>

              <RowIndex>7</RowIndex>

              <ParameterName>TimeZone</ParameterName>

            </CellDefinition>

            <CellDefinition>

              <ColumnIndex>1</ColumnIndex>

              <RowIndex>7</RowIndex>

              <ParameterName>TimeZoneName</ParameterName>

            </CellDefinition>

            <CellDefinition>

              <ColumnIndex>3</ColumnIndex>

              <RowIndex>3</RowIndex>

              <ParameterName>Interactive</ParameterName>

            </CellDefinition>

            <CellDefinition>

              <ColumnIndex>1</ColumnIndex>

              <RowIndex>8</RowIndex>

              <ParameterName>Username</ParameterName>

            </CellDefinition>

          </CellDefinitions>

        </GridLayoutDefinition>

      </ReportParametersLayout>

      <Code><Script>

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



Const TimeZoneParameterName As String = "TimeZone"

Const SD_BaseTypeParameterName As String = "StartDate_BaseType"

Const SD_BaseValueParameterName As String = "StartDate_BaseValue"

Const SD_OffsetTypeParameterName As String = "StartDate_OffsetType"

Const SD_OffsetValueParameterName As String = "StartDate_OffsetValue"

Const ED_BaseTypeParameterName As String = "EndDate_BaseType"

Const ED_BaseValueParameterName As String = "EndDate_BaseValue"

Const ED_OffsetTypeParameterName As String = "EndDate_OffsetType"

Const ED_OffsetValueParameterName As String = "EndDate_OffsetValue"

Const IsRelativeTimeSupported As Boolean = False

Const TimeTypeParameterName As String = "TimeType"

Const TimeWeekMapParameterName As String = "TimeWeekMap"



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

Dim ReportTimeZone As Microsoft.EnterpriseManagement.Reporting.TimeZoneCoreInformation

Dim ReportStartDate As DateTime

Dim ReportEndDate As DateTime

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

  ReportStartDate = DateTime.MinValue

  ReportEndDate = DateTime.MinValue

  ReportTime = Nothing

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

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

End Sub



Public Function GetCallingManagementGroupId() As String

   Return Microsoft.EnterpriseManagement.Reporting.ReportingConfiguration.ManagementGroupId

End Function



Public Function GetReportLocLanguageCode() As String

   Return ReportCulture.ThreeLetterWindowsLanguageName

End Function



Public Function GetLocTable(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 GetReportStartDate() As DateTime

  If (ReportStartDate = DateTime.MinValue) Then

    If (IsRelativeTimeSupported) Then

      ReportStartDate = ParameterProcessor.GetDateTime(ToReportDate(DateTime.UtcNow), Report.Parameters(SD_BaseTypeParameterName).Value, Report.Parameters(SD_BaseValueParameterName).Value, Report.Parameters(SD_OffsetTypeParameterName).Value, Report.Parameters(SD_OffsetValueParameterName).Value, Report.Parameters(TimeTypeParameterName).Value)

    Else

      ReportStartDate = ParameterProcessor.GetDateTime(ToReportDate(DateTime.UtcNow), Report.Parameters(SD_BaseTypeParameterName).Value, Report.Parameters(SD_BaseValueParameterName).Value, Report.Parameters(SD_OffsetTypeParameterName).Value, Report.Parameters(SD_OffsetValueParameterName).Value)

    End if

  End If

  return ReportStartDate

End Function



Public Function GetReportEndDate() As DateTime

  If (ReportEndDate = DateTime.MinValue) Then

    If (IsRelativeTimeSupported) Then

      ReportEndDate = ParameterProcessor.GetDateTime(ToReportDate(DateTime.UtcNow), Report.Parameters(ED_BaseTypeParameterName).Value, Report.Parameters(ED_BaseValueParameterName).Value, Report.Parameters(ED_OffsetTypeParameterName).Value, Report.Parameters(ED_OffsetValueParameterName).Value, Report.Parameters(TimeTypeParameterName).Value)

      If IsBusinessHours(GetReportTimeFilter()) Then ReportEndDate = ReportCulture.Calendar.AddDays(ReportEndDate, 1)

    Else

      ReportEndDate = ParameterProcessor.GetDateTime(ToReportDate(DateTime.UtcNow), Report.Parameters(ED_BaseTypeParameterName).Value, Report.Parameters(ED_BaseValueParameterName).Value, Report.Parameters(ED_OffsetTypeParameterName).Value, Report.Parameters(ED_OffsetValueParameterName).Value)

    End if

  End If

  return ReportEndDate

End Function



Public Function GetReportTimeFilter() As Microsoft.EnterpriseManagement.Reporting.ParameterProcessor.RelativeTime

  If IsNothing(ReportTime) Then ReportTime = New Microsoft.EnterpriseManagement.Reporting.ParameterProcessor.RelativeTime(Report.Parameters(TimeTypeParameterName).Value, Report.Parameters(SD_BaseValueParameterName).Value, Report.Parameters(ED_BaseValueParameterName).Value, CStr(Join(Report.Parameters(TimeWeekMapParameterName).Value, ",")))

  return ReportTime

End Function



Public Function IsBusinessHours(Value As Microsoft.EnterpriseManagement.Reporting.ParameterProcessor.RelativeTime) As Boolean

  return (Not IsNothing(Value)) And (Value.TimeType = Microsoft.EnterpriseManagement.Reporting.ParameterProcessor.RelativeTimeType.Business)

End Function



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

  return Value.ToString(Format, ReportCulture)

End Function



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

  return Value.ToString(Format, ReportCulture)

End Function



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

  return String.Format(ReportCulture, Format, Values)

End Function



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

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

End Function



Public Function FormatBusinessHours(Format As String, Value As Microsoft.EnterpriseManagement.Reporting.ParameterProcessor.RelativeTime) As String

  Dim result As String



  If IsBusinessHours(Value) Then

 

    Dim firstDay As DayOfWeek

    Dim days As System.Collections.Generic.List(Of String)



    firstDay = ReportCulture.DateTimeFormat.FirstDayOfWeek

    days = new System.Collections.Generic.List(Of String)()



    For loopDay As DayOfWeek = DayOfWeek.Sunday To DayOfWeek.Saturday

      Dim day As DayOfWeek

      day = CType((CInt(loopDay) + CInt(firstDay)) Mod 7, DayOfWeek)



      If value.WeekMap.Contains(day) Then days.Add(ReportCulture.DateTimeFormat.GetAbbreviatedDayName(day))

    Next loopDay



     result = FormatString(Format, DateTime.Today.Add(Value.StartTime).ToString(ReportCulture.DateTimeFormat.ShortTimePattern), DateTime.Today.Add(Value.EndTime).ToString(ReportCulture.DateTimeFormat.ShortTimePattern), String.Join(",", days.ToArray()))



  Else

     result = String.Empty

  End if

  

  return result

End Function



Public Function BuildXmlValueList(ByVal ValueList() As Object) As String

    Return Microsoft.EnterpriseManagement.Reporting.MultiValueParameter.ToXml("Data", "Value", ValueList)

End Function



REM ----------------------------------------



    Public Enum AggregationType

        Hourly = 0

        Daily = 1

        Monthly = 2

    End Enum



    Public Function FormatAggregatedTimeValue(ByVal TimeValue As DateTime, ByVal AggType As AggregationType) As DateTime

        Dim Result As DateTime



        Select Case (AggType)

            Case AggregationType.Hourly

                Result = New DateTime(TimeValue.Year, TimeValue.Month, TimeValue.Day, TimeValue.Hour, 0, 0, ReportCulture.Calendar)



            Case AggregationType.Daily

                Result = New DateTime(TimeValue.Year, TimeValue.Month, TimeValue.Day, ReportCulture.Calendar)



            Case AggregationType.Monthly

                Result = New DateTime(TimeValue.Year, TimeValue.Month, 1, ReportCulture.Calendar)

        End Select



        Return Result

    End Function



    Public Function FormatAggregatedTimeValueLabel(ByVal TimeValue As DateTime, ByVal AggType As AggregationType) As String

        Dim Format As String



        Select Case (AggType)

            Case AggregationType.Hourly

                Format = "g"



            Case AggregationType.Daily

                Format = "d"



            Case AggregationType.Monthly

                Format = "Y"

        End Select



        Return TimeValue.ToString(Format, ReportCulture)

    End Function

REM ---------------------------------



    Public Function FormatTimeInterval(ByVal TimeInSeconds As Integer) As String

        Dim Hours, Minutes, Seconds As Integer



        Hours = Math.Floor(TimeInSeconds / 3600)

        Minutes = Math.Floor((TimeInSeconds Mod 3600) / 60)

        Seconds = TimeInSeconds Mod 60



        Return FormatString("{0}:{1}:{2}", Hours.ToString(), Minutes.ToString("00"), Seconds.ToString("00"))

    End Function</Script></Code>

      <Language>en-US</Language>

      <CodeModules>

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

      </CodeModules>

      <ConsumeContainerWhitespace>true</ConsumeContainerWhitespace>

      <rd:ReportUnitType>Inch</rd:ReportUnitType>

      <rd:ReportID>ab518a51-343d-46c4-b1f8-4ec65faafd95</rd:ReportID>

    </Report>

  </Definition>

  <ReportStrings>

    <ReportString ID="R.Title"/>

    <ReportString ID="R.Description"/>

    <ReportString ID="R.DescriptionTitle"/>

    <ReportString ID="R.PageFormat"/>

    <ReportString ID="R.TimeZoneFormat"/>

    <ReportString ID="R.GeneratedTimeLabel"/>

    <ReportString ID="R.StartEndTimeLabel"/>

    <ReportString ID="R.StartEndTimeFormat"/>

    <ReportString ID="R.Table1Title"/>

    <ReportString ID="R.Table2Title"/>

    <ReportString ID="R.Table3Title"/>

    <ReportString ID="R.ActionCriteriaLabel"/>

    <ReportString ID="R.UserCriteriaLabel"/>

    <ReportString ID="R.Action_0"/>

    <ReportString ID="R.Action_1"/>

    <ReportString ID="R.Action_2"/>

    <ReportString ID="RT.Column.ManagementPack"/>

    <ReportString ID="RT.Column.Version"/>

    <ReportString ID="RT.Column.Username"/>

    <ReportString ID="RT.Column.Date"/>

    <ReportString ID="RT.Column.Action"/>

    <ReportString ID="RT.Column.OverrideObject"/>

    <ReportString ID="RT.Column.Parameter"/>

    <ReportString ID="RT.Column.TargetClass"/>

    <ReportString ID="RT.Column.Value"/>

    <ReportString ID="RT.Column.Object"/>

  </ReportStrings>

</Report>