Procedure: Enable Drillthrough from the Primary Report to a
Targeted Detail Report
The next steps in constructing the
specified drillthrough capability include the creation of the targeted
detail report that the Purchasing consumers have specified. We will create the
new report itself first, and then return to the primary report to enact
settings to enable and align the drillthrough action. Because the
primary report must reference a report parameter within the targeted
report as part of aligning the two, we will create the targeted report, with
its parameter, first.
a New Detail Report
create a basic detail report, to serve as the report we target from drillthrough
within our primary report, in the steps that follow:
the Reports folder in the Solution Explorer.
Select Add from
the context menu that appears.
New Item from the cascading menu that appears next, as depicted in Illustration
New Item - RS022_MDX_DRILLTHROUGH dialog appears.
in the Templates pane to create a new empty report.
following into the Name box at the bottom of the dialog:
New Item - RS022_MDX_DRILLTHROUGH dialog appears as shown in Illustration
Illustration 57: The Add
New Item - RS022_MDX_DRILLTHROUGH Dialog with Our Input
to create the new report.
RS022_DRILLTHROUGH_TARGET.rdl appears in the Reports folder of the Solution
Explorer, as depicted in Illustration 58.
Illustration 58: The New
Report Appears in the Reports Folder - Solution Explorer
will first create the Dataset for the new report, before designing it
further in Layout view.
Click the Data
tab within the Report Designer.
Dataset ...> in the Dataset selector, as shown in Illustration
Illustration 59: Select
<New Dataset ...>
Link Properties dialog appears, defaulted to the Connection tab.
Click the Provider
list under Select the data you want to connect to, select Microsoft OLE
DB Provider for OLAP Services 8.0, as depicted in Illustration 60.
Illustration 60: Select
Microsoft OLE DB Provider for OLAP Services 8.0
Click Next to
navigate to the Connection tab.
server name into the Data Source box (mine is MOTHER1).
complete the appropriate authentication choices for your environment, within
the section labeled Enter information to log on to the server.
selector labeled Enter the initial catalog to use, select FoodMart
Link Properties dialog Connection tab appears as shown in Illustration
Illustration 61: The
Data Link Properties Dialog Connection Tab
Click the Test
Connection button, in the bottom right corner of the dialog.
that our input is correct in the settings for the Data Link Properties
dialog, we will receive a message box indicating a successful connection, as
depicted in Illustration 62.
Illustration 62: Testing
Positive for Connectivity via the Test Connection Button ...
to dismiss the message box.
Click OK on
the Data Link Properties dialog to accept settings and close the dialog.
returned to the Data tab of the Report Designer, where we see the FoodMart_2000
appears in the Dataset selector.