Sorting Data on Reports
NetSuite sorts all reports by one or more columns by default. You can remove these default settings, add your own sorting options, or do both.
For financial statements, use sorting on the Financial Report Builder Edit Layout Page instead of the Sorting page. Sorting you set on the Edit Layout page overrides any Sorting page settings.
To remove sorting options from your report:
-
Click Customize in the footer of the report.
-
On the Report Builder (or Financial Report Builder) page, click Sorting.
-
In the Choose Sort Order pane, click the X next to the sorting option you want to remove.
-
Click Save.
To add sorting options to your report:
-
Click Customize in the footer of the report.
-
On the Report Builder (or Financial Report Builder) page, click Sorting.
-
In the Add Fields pane, select the field you want to sort the report by.
You can browse the Add Fields pane or type the name of the field in Search Fields and click Search.
When you select the field, it automatically adds a line for that field to the sorting options list.
-
(Optional) Check the Descending box to sort the data in descending order.
-
Click Add.
-
Repeat steps 3-5 to add more sorting options.
-
Click Save.
Sorting options are applied in the order they're listed. Use the Move Up and Move Down buttons or drag the columns to set the sort order.
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 show 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