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

Figure 194 Selecting Columns to Remove from the Drill-Through Report

2 Click to move the selected column from the Selected Columns list back to the Available Columns list.

Note:

To move a column from one list to another, click or . To move all columns from one list

to another, click

or .

3 Click Next to display the Select Data Sort Order dialog box, and follow the steps in the topic, “Ordering

Data” on page 180 to further customize the report.

Note:

When you finish customizing the report, click Finish at any time to generate the report and view

the results in a new sheet. The new sheet is placed before the current sheet.

Ordering Data

In the Select Data Sort Order dialog box, you can select an ascending or descending sort order

for the data in a column. Sort order determines the order in which rows will be displayed in the

drill-through report. For example, you can sort the contents of the Time.TRANSDATE column,

which represents the transaction dates, in ascending order in the drill-through report.

➤ To define the sort order of rows in the drill-through report:

1 In the Available Columns list, select the Time.TRANSDATE column.

The columns in the Available Columns list box are those that you selected in “Selecting and

Ordering Columns” on page 179. The columns in the Column list are those for which a sort

order has already been defined in Integration Services Console.

If a data sort order was selected when the report was created in Integration Services Console, the

Order By list displays that selection. Otherwise, the default sort order is Ascending.

180

Using Drill-Through

1 2 ... 175 176 177 178 179 180 181 182 183 184 185 ... 199 200

Sem comentários

Arrow Storage Products EN106 Guia do Utilizador Página 180