Select a Range of Cells

On the Request Wizard: Step 2, when you enable Custom Layout for a trended request, you can map the request to a range of cells.

Click the Range Selector select_cell_icon.png next to the item you want to map.

  • All Cells in Range: Requires you to select a group of cells for a Custom Layout style request.
  • First Cell of Range: Lets you select the top-left cell of the range, and displays the Range orientation to specify the horizontal or vertical orientation of input and output cells (column or row). Use this option to have Report Builder select cells for you.
  • Range Orientation: Lets you orient the cell ranges as columns or rows.
  • Select Upper Cell Location of Range: Displays the cell references.

Techniques for selecting cells

You select the data by clicking the Range Selection icon select_cell_icon.png

and click-dragging the mouse over the desired range of cells of the spreadsheet. A continuous selection is outlined by a black border.

Separate selected rows have a thin white border around each row.

To map separate rows in one request, use the Control key, then click and drag the cursor over the desired cells. You would do this if your request calls for four areas with ten cells each, rather than one continuous area with 40 cells together.

After you select cells, click the Range Selector again on the Range Selection form to return to the Request Wizard: Step 2.