Reading a report
The table, its totals and formats, full or compact numbers, paging, exporting, and what an error panel means.
A report page shows the stored result of one SuiteQL query as a table. The author may have added charts and stat tiles around it. This page covers the table and the controls around it.
How fresh the data is
A report shows a cached snapshot from its last run, not a live query. The top of the page says Updated 12 minutes ago, or Never run. A report that has never run starts its first run when you open it.
- Refresh asks for a new run now. A large report can take a minute or more. If you click again too soon, the app shows a "refreshed recently" message. This is a short cooldown, not an error.
- Full Refresh appears on reports set up for partial refresh. A partial run fetches only rows added or changed since the last run. A full run re-reads everything, and it is the only way a row deleted in NetSuite leaves the report. On such a report, the note beside the age says what the last run did, for example (partial: 12 added, 3 changed) or (full refresh).
A large result loads in parts. A progress bar shows the percentage, the rows received and the file count.
The table
- Headers stay in view. A table taller than the screen scrolls inside its box, with the header pinned at the top.
- Wide tables have a second horizontal scrollbar above the header, in step with the one at the bottom, so you can scroll sideways without holding Shift.
- Click a column header to sort by it. Drag the edge of a header to change the column's width.
- Rows per page starts at the author's default, and you can change it for your session.
- Row numbers appear when the author turned them on, which helps when you discuss a particular line.
- The Totals row, when the author added one, is the last row. It totals the columns the author chose, each with its own function: sum, count, average, min or max. The app works out totals over all the filtered rows, not only the current page, so they do not change when you page through.
The count above the table, for example "Showing 42 of 1,203 rows", tells you whether a filter is narrowing the result.
Column formats
The author gives each column a format, and the table displays values in that format:
| Format | Shows as |
|---|---|
| Text | As stored |
| Number | Digits with separators |
| Currency | Money |
| Percent | A percentage, for example 58.34% for a stored 0.5834 |
| Date, Datetime | Your local day. A date is never shifted to the previous evening. |
| Month | A month key such as 2026-03 |
| Yes / No | A yes or no value |
| Dropdown | Text whose filter is a checklist of the values present |
Some columns link to a NetSuite record, and their values show as links. A click opens the record in a new tab, so you keep your place. Other links open another report, as described in Drill-through.
Full or compact numbers
Numbers at the top of the page switches how money and numbers read:
- full: $9,809,607.48
- compact: $9.81M, 1.5K
The table, the totals row, every chart, the stat tiles and a statement all follow the choice. The page opens on the author's default. Your browser keeps your own choice for that report.
Exporting
Export above the table downloads a CSV or Excel file.
- Current view exports the rows and columns on screen, after your filters and sorting.
- All rows exports every row, ignoring filters.
Either way, the file holds the visible columns in their displayed order and is named after the report and the date. When a report is grouped by quarter or year, the export contains the grouped rows.
When a result is truncated
An administrator can set an optional row cap. When a result reaches it, a banner says Limited to the first N rows by the configured row cap, and the catalogue flags the report. The data is incomplete; this is not a display problem. Ask the author to narrow the query, or ask an administrator about the cap. By default there is no cap.
When a report fails
A failed report shows an error panel with one of five labels:
| Label | In plain terms | Who to go to |
|---|---|---|
| Query error | NetSuite rejected the query, or it failed while running. | The report's author. |
| Definition error | The report's setup is incomplete. | The report's author. |
| Result too large | The result passed a size limit set in Configuration. | The author to narrow it, or an administrator to raise the limit. |
| Storage error | The app could not save the result. This is a configuration problem, not a query problem. | An administrator. |
| Application error | A defect in Advanced Reports itself. | An administrator, or HiScale. |
An administrator can follow a failed run step by step in the execution log of the refresh script. Each run writes lines titled AR refresh <id>: <step>.
Related: Filters and the grain switch · Drill-through · Charts on a report · Refresh and scheduling