Defining Order and Overall Formatting for Search Results
On the Results subtab for advanced and saved searches, you can set the order in which columns appear, the sort order for rows, and overall formatting for the search results page.
To set the order in which fields appear as results page columns:
-
Select a field in the grid, and use the Move Up, Move Down, Move To Top, or Move To Bottom buttons.
-
Click Done.
To define primary, secondary, third sort fields for a search's returned records:
-
Select fields 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 in the alphabetical order specific to your NetSuite language settings, but you can use the U.S. English sort order instead. To learn more about the Search Sorting option, see General Personal Preferences.
Make sure you sort using the field with the most unique values, or sort using multiple fields. Sorting with a single field that has multiple identical values can cause the result rows to be in a different order 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 indicates a list page format.
-
Report indicates a results page formatted like a report.
-
Grid indicates a worksheet format with grid lines.
-
Graph indicates a bar graph of search results.
-
The graph output type is no longer the preferred view option for reports and saved searches. To see your data in a graph, you can use the SuiteAnalytics Workbook chart capabilities instead. For more information about how to use charts in SuiteAnalytics Workbook, 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