Arrow Storage Products EN106 Guia do Utilizador descarregar pdf (Página 174)

develops drill-through reports specifies whether you can customize a report and whether you

need to log in to access the drill-through report and the relational data source.

5 Follow the steps in “Selecting Drill-Through Reports to View or Customize” on page 174 to select a report

to customize.

Selecting Drill-Through Reports to View or Customize

After you launch the drill-through process from the Linked Objects Browser dialog box,

Integration Services displays the Select Drill-Through Report dialog box under one or the other

of the following conditions:

● More than one drill-through report exists for the cell or cell range that you select in the

spreadsheet.

● Only one report exists, but you have the option of customizing it using the Drill-Through

Wizard.

The Select Drill-Through Report dialog box displays the list of drill-through reports available

for the cells that you select in the spreadsheet. Depending on how a report is defined in

Integration Services Console, you may have access only to view, not customize, the report.

Note:

Tasks that you should not perform as part of the tutorial are shown in light colored boxes.

This task is optional. Optional tasks do not need to be performed as part of the tutorial. They are provided for information

only.

The sample report used for this tutorial is the Measures Detail report. You will use the Drill-Through Wizard to customize

this sample report.

To execute a predefined drill-through report without customizing it, perform these tasks:

1. Select the report that you want to view from the Available Reports list box.

2. Click Execute.

Integration Services retrieves the data from the relational source and displays the results in a new spreadsheet. The

new sheet is added before the current sheet.

➤ To customize the sample drill-through report:

1 In the Essdt.xls file, select the Measures Detail tab, as shown in Figure 186.

174

Using Drill-Through

1 2 ... 169 170 171 172 173 174 175 176 177 178 179 ... 199 200

Sem comentários

Arrow Storage Products EN106 Guia do Utilizador Página 174