Drillthrough Context Parameter Values

Report Builder users can create reports and drill through to them from other Report Builder reports. To use a Report Builder report as a drillthrough report, the Report Builder user must select the Drillthrough check box in the Report Properties dialog box. This sets the EnableDrillthrough property to True for the semantic query. In addition, a drillthrough context parameter is added to the Report Definition Language (RDL). This parameter is passed through to the semantic query. Once the property is set in Report Builder, you can set one of the drillthrough properties of an entity to point to the report using SQL Server Management Studio.

A drillthrough context parameter is a top-level element. The structure of a drillthrough context parameter value is as follows:

<DrillthroughContext>
    <SemanticQuery>...</SemanticQuery>
    <SelectedItems>
        <SelectedItemName>ItemName</SelectedItemName>
        ...
    </SelectedItems>
    <SelectedPath>Path</SelectedPath>
    <GroupingValues>
        <GroupingValue Name="GroupingName">Value</GroupingValue>
        ...
    </GroupingValues>
</DrillthroughContext>

The following table describes the items within the structure.

Item	Description
SemanticQuery	An element that contains the source query from which the filter expression for the drillthrough should be derived. This element cannot contain parameters.
ItemName	The name of an expression that determines what data is drilled into and displayed to the user. The ItemName corresponds to the name of an expression in the query. SelectedItems must contain a reference to a single grouping expression, or references to expressions that are all in the same measure group or in the same Details collection.
Path	The XML for the Path from the selected item(s) to the target entity that is being drilled to.
GroupingName	The name of a grouping whose value is needed to identify the selected instance of the selected item.
Value	The value of the GroupingName for the selected item. To specify a null as the value of a grouping, do not specify the Value element and add xsi:nil="true" to the GroupingValue element.

See Also

Concepts

Model Designer Object Properties
Model Designer Query Properties
Model Designer Data Types
Ad Hoc Reporting with Report Models
Working with Model Designer

Help and Information

Getting SQL Server 2005 Assistance