Select Display Items

Explanation

This activity is used to select a combination of Measure, Light and/or Dimension Items in order to create a basic design section.

Prerequisites

Before creating a design using these elements make sure to have selected the required information sources from the Select Information Sources dialog box.

System Effects

As a result of this activity, display items selected will be included in the report design.

Related Process Model

Apply Design Elements

Related Activity

Apply Repeater
Apply Filter Criteria
Apply Structure Repeaters
Apply Microsoft Excel Functionality

Procedure

1. Expand a folder from the Display Items pane.
2. Select the required display items from the folder and drag them to the Microsoft Excel worksheet where the items would be aligned to form a cell, row or a column. You can drag a number of display items from any folder on to a row or column as required.

To copy a design row/column:

1. Select any Microsoft Excel design row or design column that you need to copy.
2. Right-click and click the Copy Design Row or Copy Design Column option, as appropriate
3. Select a Microsoft Excel row or column to copy the design row or column.
4. Right-click and then click Paste Design Row or Paste Design Column option.

To copy a design cell:

1. Right-click and click Copy Design Cell.
2. Go to the location where you want the design cell to be copied and right-click and then click Paste Design Cell.
   

To display absolute cell values:

1. Right-click and click Copy Design Cell.
2. Select Display Absolute Value check box from the Cell Options tab if you want to display the cell value without the equal sign and quotation mark. This makes is possible to use the cell as an argument in an Excel® function and get the correct result.