Sorting Data on Reports

All reports in NetSuite are sorted by a column or multiple columns by default. You can choose to remove these default settings, add new sorting options to your report or both.

Important:

For financial statements, you should use sorting capabilities on the Financial Report Builder Edit Layout Page rather than defining sort order on the Sorting page. Sorting defined on the Edit Layout page overrides any sorting defined on the Sorting page.

To remove sorting options from your report:

1. Click Customize in the footer of the report.

2. On the Report Builder (or Financial Report Builder) page, click Sorting.

3. In the Choose Sort Order pane, click the X next to the sorting option you want to remove.

4. Click Save.

To add sorting options to your report:

1. Click Customize in the footer of the report.

2. On the Report Builder (or Financial Report Builder) page, click Sorting.

3. In the Add Fields pane, select the field you want to sort the report by.

   You can locate the field by browsing the list in the Add Fields pane or type the name of the field in the Search Fields name and click Search.

   When the field is selected, a line for that field is automatically added to the list of sorting options.

4. Check the Descending box if you want to sort the data in descending order. This setting is optional.

5. Click Add.

6. Repeat steps 3-5 to add more sorting options to your report.

7. Click Save.

Sorting options are applied in the order in which they are listed. You can use the Move Up and Move Down buttons or drag the lines representing the columns to choose the order in which the sorting options are applied.

Warning:

The way that Oracle handles the ORDER BY statement causes the following issue. If you sort report data by a field that can have a null value, such as Department, records with null values for the sorted field are listed last for ascending sort order and first for descending sort order. Also, null field values are displayed as 0.

Related Topics

• Report Customization
• Report Builder Interface
• Report Customization Permission
• Adding, Removing, or Reordering Report Columns
• Formatting Numbers on Reports
• Filtering Data on Reports
• Setting Additional Options for Custom Reports
• Arranging Data on Summary Reports
• Setting Up Cash Basis Reporting
• Sharing Custom Reports with Other Users
• Exporting a Saved Report as an Excel Web Query
• Example Report Format Changes
• Saving a Custom Report
• Deleting a Custom Report

General Notices