List of Change Requests

ServiceManager.Report.ChangeManagement.ListOfRFCs (Report)

This report provides a list of change requests as well as several of their important attributes including their current status, category, who they are assigned to and more.
Element properties:

Accessibility	Public
Visible	True
Report Localization:

*ReportName*	List of Change Requests
*ReportDescriptionLabel*	Expand this section to see a full description of this report and any applicable filter criteria
*ReportDescription*	This report provides a list of change requests as well as several of their important attributes including their current status, category, who they are assigned to and more.
*ReportGeneratedLabel*	Report generated
*StartEndDateLabel*	Start and End Date
*DateFilterLabel*	Date Filter
*IDLabel*	ID
*Status*	Status
*Impact*	Impact
*Category*	Category
*AssignedTo*	Assigned To
*Description*	Description
*Priority*	Priority
*Risk*	Risk
*ChangeResult*	Change Result
*CreatedBy*	Created By
*CreatedOn*	Created Date
*RFCName*	Name
*ScheduledStart*	Scheduled Start Date
*ScheduledEnd*	Scheduled End Date
*ActualStart*	Actual Start
*ActualEnd*	Actual End
*Format.StartEndDateFormat*	From {0} to {1}
*Link.RFCDetailReport*	Change Request Details report
*AllLabel*	(All)
Source Code:

<Report ID="ServiceManager.Report.ChangeManagement.ListOfRFCs" Accessibility="Public" Target="Change!System.WorkItem.ChangeRequest" Visible="true">

  <Dependencies>

    <Dimension>DWBase!UserDim</Dimension>

    <Dimension>ChangeDW!ChangeRequestDim</Dimension>

    <DataWarehouseScript>SMReportCommon!ServiceManager.Report.Common.SP.ReportOptimizations.Script</DataWarehouseScript>

    <DataWarehouseScript>ServiceManager.Report.ChangeManagement.SP.ReportOptimizations.Script</DataWarehouseScript>

    <DataWarehouseScript>ServiceManager.Report.ChangeManagement.SP.GetListOfRFCs.Script</DataWarehouseScript>

    <DataWarehouseScript>SMReportCommon!ServiceManager.Report.Common.Function.fn_CSVToTableString.Script</DataWarehouseScript>

    <DataWarehouseScript>SMReportCommon!ServiceManager.Report.Common.Function.fn_CSVToTableInt.Script</DataWarehouseScript>

    <ReportResource>SMReportCommon!Report_Header_Potrait.png</ReportResource>

    <ReportResource>SMReportCommon!Report_Header_Landscape.png</ReportResource>

    <ReportResource>SMReportCommon!horizontal_line_gradient.png</ReportResource>

  </Dependencies>

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

    <Controls>

      <Control rowSpan="2" columnSpan="2" type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.RelativeDatePickerValueEditor">

        <ReportParameters>

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

            <Prompt>ServiceManager.ChangeManagement.Report.Library!ReportParameter.TimeZone</Prompt>

          </ReportParameter>

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

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

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

            <Prompt>ServiceManager.ChangeManagement.Report.Library!ReportParameter.StartDate</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>ServiceManager.ChangeManagement.Report.Library!ReportParameter.EndDate</Prompt>

          </ReportParameter>

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

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

        </ReportParameters>

      </Control>

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

        <ReportParameters>

          <ReportParameter name="Category">

            <Prompt>ServiceManager.ChangeManagement.Report.Library!ReportParameter.Category</Prompt>

          </ReportParameter>

        </ReportParameters>

        <Properties>

          <Property name="MinHeight">

            <Value>40</Value>

          </Property>

          <Property name="MinWidth">

            <Value>100</Value>

          </Property>

          <Property name="OutriggerTypeName">

            <Value>ChangeCategory</Value>

          </Property>

          <Property name="OutriggerTypeMPName">

            <Value>ServiceManager.ChangeManagement.Library.Datawarehouse</Value>

          </Property>

          <Property name="OutriggerSelectAllValue">

            <Value>-1</Value>

          </Property>

        </Properties>

      </Control>

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

        <ReportParameters>

          <ReportParameter name="Status">

            <Prompt>ServiceManager.ChangeManagement.Report.Library!ReportParameter.Status</Prompt>

          </ReportParameter>

        </ReportParameters>

        <Properties>

          <Property name="MinHeight">

            <Value>40</Value>

          </Property>

          <Property name="MinWidth">

            <Value>100</Value>

          </Property>

          <Property name="OutriggerTypeName">

            <Value>ChangeStatus</Value>

          </Property>

          <Property name="OutriggerTypeMPName">

            <Value>ServiceManager.ChangeManagement.Library.Datawarehouse</Value>

          </Property>

          <Property name="OutriggerSelectAllValue">

            <Value>-1</Value>

          </Property>

        </Properties>

      </Control>

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

        <ReportParameters>

          <ReportParameter name="ChangeResult">

            <Prompt>ServiceManager.ChangeManagement.Report.Library!ReportParameter.ChangeResult</Prompt>

          </ReportParameter>

        </ReportParameters>

        <Properties>

          <Property name="MinHeight">

            <Value>40</Value>

          </Property>

          <Property name="MinWidth">

            <Value>100</Value>

          </Property>

          <Property name="OutriggerTypeName">

            <Value>ChangeImplementationResults</Value>

          </Property>

          <Property name="OutriggerTypeMPName">

            <Value>ServiceManager.ChangeManagement.Library.Datawarehouse</Value>

          </Property>

          <Property name="OutriggerSelectAllValue">

            <Value>-1</Value>

          </Property>

        </Properties>

      </Control>

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

        <ReportParameters>

          <ReportParameter name="Impact">

            <Prompt>ServiceManager.ChangeManagement.Report.Library!ReportParameter.Impact</Prompt>

          </ReportParameter>

        </ReportParameters>

        <Properties>

          <Property name="MinHeight">

            <Value>40</Value>

          </Property>

          <Property name="MinWidth">

            <Value>100</Value>

          </Property>

          <Property name="OutriggerTypeName">

            <Value>ChangeImpact</Value>

          </Property>

          <Property name="OutriggerTypeMPName">

            <Value>ServiceManager.ChangeManagement.Library.Datawarehouse</Value>

          </Property>

          <Property name="OutriggerSelectAllValue">

            <Value>-1</Value>

          </Property>

        </Properties>

      </Control>

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

        <ReportParameters>

          <ReportParameter name="Risk">

            <Prompt>ServiceManager.ChangeManagement.Report.Library!ReportParameter.Risk</Prompt>

          </ReportParameter>

        </ReportParameters>

        <Properties>

          <Property name="MinHeight">

            <Value>40</Value>

          </Property>

          <Property name="MinWidth">

            <Value>100</Value>

          </Property>

          <Property name="OutriggerTypeName">

            <Value>ChangeRisk</Value>

          </Property>

          <Property name="OutriggerTypeMPName">

            <Value>ServiceManager.ChangeManagement.Library.Datawarehouse</Value>

          </Property>

          <Property name="OutriggerSelectAllValue">

            <Value>-1</Value>

          </Property>

        </Properties>

      </Control>

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

        <ReportParameters>

          <ReportParameter name="Priority">

            <Prompt>ServiceManager.ChangeManagement.Report.Library!ReportParameter.Priority</Prompt>

          </ReportParameter>

        </ReportParameters>

        <Properties>

          <Property name="MinHeight">

            <Value>40</Value>

          </Property>

          <Property name="MinWidth">

            <Value>100</Value>

          </Property>

          <Property name="OutriggerTypeName">

            <Value>ChangePriority</Value>

          </Property>

          <Property name="OutriggerTypeMPName">

            <Value>ServiceManager.ChangeManagement.Library.Datawarehouse</Value>

          </Property>

          <Property name="OutriggerSelectAllValue">

            <Value>-1</Value>

          </Property>

        </Properties>

      </Control>

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

        <ReportParameters>

          <ReportParameter name="ID">

            <Prompt>ServiceManager.ChangeManagement.Report.Library!ReportParameter.ID</Prompt>

          </ReportParameter>

        </ReportParameters>

      </Control>

      <Control rowSpan="2" columnSpan="2" type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.DimensionInstancePickerValueParameterEditor">

        <ReportParameters>

          <ReportParameter name="CreatedBy">

            <Prompt>ServiceManager.ChangeManagement.Report.Library!ReportParameter.CreatedBy</Prompt>

          </ReportParameter>

        </ReportParameters>

        <Properties>

          <Property name="IsSingleSelect">

            <Value>True</Value>

          </Property>

          <Property name="DimensionTypeName">

            <Value>UserDim</Value>

          </Property>

          <Property name="DimensionTypeMPName">

            <Value>Microsoft.SystemCenter.Datawarehouse.Base</Value>

          </Property>

          <Property name="MaxDimessionInstances">

            <Value>500</Value>

          </Property>

          <Property name="ColumnDefinitions">

            <Value>Name</Value>

          </Property>

        </Properties>

      </Control>

      <Control rowSpan="2" columnSpan="2" type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.DimensionInstancePickerValueParameterEditor">

        <ReportParameters>

          <ReportParameter name="AssignedTo">

            <Prompt>ServiceManager.ChangeManagement.Report.Library!ReportParameter.AssignedTo</Prompt>

          </ReportParameter>

        </ReportParameters>

        <Properties>

          <Property name="IsSingleSelect">

            <Value>True</Value>

          </Property>

          <Property name="DimensionTypeName">

            <Value>UserDim</Value>

          </Property>

          <Property name="DimensionTypeMPName">

            <Value>Microsoft.SystemCenter.Datawarehouse.Base</Value>

          </Property>

          <Property name="MaxDimessionInstances">

            <Value>500</Value>

          </Property>

          <Property name="ColumnDefinitions">

            <Value>Name</Value>

          </Property>

        </Properties>

      </Control>

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

        <ReportParameters>

          <ReportParameter name="Description">

            <Prompt>ServiceManager.ChangeManagement.Report.Library!ReportParameter.Description</Prompt>

          </ReportParameter>

        </ReportParameters>

      </Control>

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

        <ReportParameters>

          <ReportParameter name="StartDate_ScheduledStart">

            <Prompt>ServiceManager.ChangeManagement.Report.Library!ReportParameter.StartDate_ScheduledStart</Prompt>

          </ReportParameter>

        </ReportParameters>

      </Control>

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

        <ReportParameters>

          <ReportParameter name="EndDate_ScheduledStart">

            <Prompt>ServiceManager.ChangeManagement.Report.Library!ReportParameter.EndDate_ScheduledStart</Prompt>

          </ReportParameter>

        </ReportParameters>

      </Control>

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

        <ReportParameters>

          <ReportParameter name="StartDate_ScheduledEnd">

            <Prompt>ServiceManager.ChangeManagement.Report.Library!ReportParameter.StartDate_ScheduledEnd</Prompt>

          </ReportParameter>

        </ReportParameters>

      </Control>

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

        <ReportParameters>

          <ReportParameter name="EndDate_ScheduledEnd">

            <Prompt>ServiceManager.ChangeManagement.Report.Library!ReportParameter.EndDate_ScheduledEnd</Prompt>

          </ReportParameter>

        </ReportParameters>

      </Control>

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

        <ReportParameters>

          <ReportParameter name="StartDate_ActualStart">

            <Prompt>ServiceManager.ChangeManagement.Report.Library!ReportParameter.StartDate_ActualStart</Prompt>

          </ReportParameter>

        </ReportParameters>

      </Control>

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

        <ReportParameters>

          <ReportParameter name="EndDate_ActualStart">

            <Prompt>ServiceManager.ChangeManagement.Report.Library!ReportParameter.EndDate_ActualStart</Prompt>

          </ReportParameter>

        </ReportParameters>

      </Control>

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

        <ReportParameters>

          <ReportParameter name="StartDate_ActualEnd">

            <Prompt>ServiceManager.ChangeManagement.Report.Library!ReportParameter.StartDate_ActualEnd</Prompt>

          </ReportParameter>

        </ReportParameters>

      </Control>

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

        <ReportParameters>

          <ReportParameter name="EndDate_ActualEnd">

            <Prompt>ServiceManager.ChangeManagement.Report.Library!ReportParameter.EndDate_ActualEnd</Prompt>

          </ReportParameter>

        </ReportParameters>

      </Control>

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

        <ReportParameters>

          <ReportParameter name="IncludeDeleted">

            <Prompt>ServiceManager.ChangeManagement.Report.Library!ReportParameter.IncludeDeleted</Prompt>

          </ReportParameter>

        </ReportParameters>

      </Control>

    </Controls>

  </ParameterBlock>

  <ReportDefinition>ServiceManager.Report.ChangeManagement.ListOfRFCs.ReportRdl</ReportDefinition>

  <ReportStrings>

    <ReportString ID="ReportName"/>

    <ReportString ID="ReportDescriptionLabel"/>

    <ReportString ID="ReportDescription"/>

    <ReportString ID="ReportGeneratedLabel"/>

    <ReportString ID="StartEndDateLabel"/>

    <ReportString ID="DateFilterLabel"/>

    <ReportString ID="IDLabel"/>

    <ReportString ID="Status"/>

    <ReportString ID="Impact"/>

    <ReportString ID="Category"/>

    <ReportString ID="AssignedTo"/>

    <ReportString ID="Description"/>

    <ReportString ID="Priority"/>

    <ReportString ID="Risk"/>

    <ReportString ID="ChangeResult"/>

    <ReportString ID="CreatedBy"/>

    <ReportString ID="CreatedOn"/>

    <ReportString ID="RFCName"/>

    <ReportString ID="ScheduledStart"/>

    <ReportString ID="ScheduledEnd"/>

    <ReportString ID="ActualStart"/>

    <ReportString ID="ActualEnd"/>

    <ReportString ID="Format.StartEndDateFormat"/>

    <ReportString ID="Link.RFCDetailReport"/>

    <ReportString ID="AllLabel"/>

  </ReportStrings>

</Report>