Selecting Reports to View or Customize

If multiple drill-through reports exist for the cell or cell range that you select in the spreadsheet, Integration Services displays the Select Drill-Through Report dialog box. This dialog box displays the list of drill-through reports available for the cells that you select in the spreadsheet. Depending on how the report was defined in Integration Services Console, your access may be only to view, and not to customize, reports.

  To view a drill-through report:

  1. From Available Reports, select a report.

  2. Click Execute.

    Integration Services retrieves the data from the relational source and displays the results in a spreadsheet. The worksheet is added before the current active worksheet.

  To customize a drill-through report:

  1. From Available Reports, select a report.

  2. Click Customize.

  3. Click Next to display the Select Columns and Display Order.

  4. Follow the steps in Selecting and Ordering Columns to select and order columns for the customized report.

Note:

The Customize button may be enabled or disabled for a given report, depending on how the report was defined in Integration Services Console.

Related Topics

Accessing Drill-Through

Customizing Reports with Drill-Through Wizard