How to Sort data in Business Objects(BO)-Beginners Tutorial-7

How to Sort data In Business Objects (BO): The order in which the data appears in rows and columns is changed by applying a sort on the data.
For example, you can sort a column of city names to have the cities appear in alphabetical order. You can apply a sort on text, dates, or numbers.

• The sorts are applied from the Sorts toolbar.
• There are three types of sorts that you can apply to data.
• The default sort order for all types of data is ascending.

You apply sorts from the Sorts toolbar. To access this toolbar,click Sorts on the Report toolbar.

Applying a sort on report data:

• Click the cell, column, row, or chart element containing the data which needs to be sorted.
• Click the toolbar button for the sort need to be applied. The data appears in order, and the clicked button remains pushed, to show that the data has been sorted.

Adding sorts from the sorts dialog box:
The add, remove, and re‐organize sorts can be done using Sorts dialog box:
1. Click inside a block or a master cell, then click the Sorts command on the Format menu.
2. Click the tab you want to work in.
3. Click Add.
4. Choose the variable to sort and click OK.
5. The new sort appears in the Current Sorts box.

6. Set the sort options you want to apply and click OK.

Removing a sort:
Click the Sort in the current sorts list and click Remove.

Applying a custom sort:

1. Click the cell, column, row, or chart element where the data that needs sort is present.
2. Click Custom Sort on the toolbar.
3. The Custom Sort dialog box opens.
4. Use the Move Up and Move Down
5. buttons to place the values in the desired order or choose an option
6. from the sort order list box.
7. Click OK to close the Custom Sort dialog box.

Managing multiple sorts ‐ define sort priority in a report:

• The order in which sorts are applied can be changed:
• Click inside the block or master cell containing sorted data
• Click the Sorts on the Format menu
• The Sorts dialog box appears

Note: If the report contains a table or a 2‐D chart, the dialog box contains one tab only. If the report contains a crosstab or a matrix chart, the dialog box has both tabs, Across Edge and Down Edge. The Down Edge tab displays the sorts applied to columns. The Across Edge tab displays the sorts applied to rows or on the Z‐axis of the chart.

1. Click the tab you want to work in, then click the sort that you want to prioritize.
2. Click Move Up to give the sort higher priority, or Move Down to give it lower priority. The sort icon moves up or down one place in the list of sorts.
3. Click OK or Apply. The sort priority you defined is applied to the report.