Defining Order and Overall Formatting for Search Results
On the Results subtab, you can set the column order, row sorting, and overall formatting for search results.
To set the order in which fields appear as results page columns:
-
Select a field in the grid, and use Move Up, Move Down, Move To Top, or Move To Bottom to reorder it.
-
Click Done.
To define primary, secondary, third sort fields for a search's returned records:
-
Select a field in the Sort By and Then By dropdown lists.
-
Check the Descending boxes to sort in reverse order, if needed.
By default, search results are sorted alphabetically according to your NetSuite language settings, but you can switch to U.S. English order. To learn more about the Search Sorting option, see General Personal Preferences.
Make sure you sort by a field that has the most unique values, or use multiple fields. Sorting by a field with duplicate values can cause the order to change each time the search is run.
To define the format for a search results page:
-
Select one of the following options from the Output Type dropdown list:
-
Normal – shows a list page layout.
-
Report – shows results formatted like a report.
-
Grid – shows a worksheet format with grid lines.
-
Graph – shows search results as bar graph.
-
The graph option isn't the preferred view option for reports and saved searches anymore. To see your data in a graph, use SuiteAnalytics Workbook chart instead. For more information, see Workbook Charts.
Related Topics
- Search Results Display Options
- Selecting Fields to Display in Search Results
- Entering Custom Labels for Search Results Columns
- Defining Summary Types to Roll Up Search Results
- Using When Ordered By Field for Search Results
- Showing Totals in Search Results
- Applying Functions to Search Results Columns