BusinessObjects: Apply Sorts

Overview

By default, report tables are sorted according to column order. If you need to sort the data differently, you can apply your own sorts.

Reports must be in Design mode in order to apply a sort.

This procedure covers the following:

Note: This topic is also covered in the Applying Sorts webinar.

Add a Sort

  1. Right-click any data cell in the column you want to sort.
    • Be sure the cell is selected before right-clicking. The first time you click on the cell, the table is selected, as shown by a dark outline. The second time you click, the cell is selected and the column highlighted.
  2. Click Data and select Add Sort.
    • By default, sorts are in ascending order.
    • When you apply a sort, the Sort Panel opens on the right side of the screen. This displays the current sort and any other sorts applied to the report.
  3. To change the sort to descending, click the Sort Descending/Sort Ascending toggle on the Sort Panel.
  4. Screenshot of the Sort Panel showing the Sort Descending/Sort Ascending button

  5. Repeat steps 1-3 to apply any additional sorts.
    • Sorts are applied to the report in the order added. For example, if you applied a sort to the Date column, then the DeptID column, the report would sort by Date first, then DeptID. You can change the order of the sorts on the Sort Panel. Drag and drop the sort boxes so the primary sort is at the top of the list, secondary sort is second in the list, etc.

Sorts can also be added using the Properties Panel.

  1. Click the table or a cell to select it.
  2. Click the Properties Panel icon Property Panel icon
  3. Screenshot of the Properties panel showing the various icons used to open the panel and the menu to select a sort field.

  4. Click the Report Element Data icon Report Element Data icon.
  5. Click the Sort Panel icon Sort Panel icon
  6. Select the field by which you want to sort the report from the Add a sort drop-down list.

Remove a Sort

  1. Right-click any data cell in a column with a sort.
  2. Click Data and select Remove Sort.

There are two other methods for removing sorts:

  • Click on a sort in the Sort Panel. Click Delete Delete icon.
  • To remove all sorts, click the three-dot More menu on the Sort Panel and select Clear all Sorts.

Apply a Custom Sort

Use a custom sort to choose your own sort order or add values to the list of values. The custom order is applied to the entire document, not just the table or chart.

  1. Click on the Sort in the Sort Panel where the custom sort will be applied.
  2. Screenshot of the Sort Panel showing a value selected, and the More menu expanded.

  3. Click the three-dot More menu and select Create Custom Order.
  4. Click a value in the list.
  5. Screenshot of the Custom Order screen showing a value highlighted and the up and down arrows.

  6. Use the up and down arrows to position the value where you want it to be in the sort order.
    • The values can also be repositioned by dragging and dropping them within the list.
  7. Repeat steps 3-4 as needed until all values are positioned.
  8. Click OK.

Note: The Add Value button is active only if it is applicable to the custom sort. You can use it to add additional values to the list.

Remove a Custom Sort

If you want to apply an ascending or descending sort to a column with a custom sort, you must first remove the custom sort.

  1. Click on the Sort in the Sort Panel where the custom sort will be applied.
  2. Screenshot of the Sort Panel showing a value selected, and the More menu expanded.

  3. Click the three-dot More menu and select Create Custom Order.
  4. Click Reset Order.
  5. Screenshot of the Custom Order screen showing the Reset Order button

  6. Click OK.