Row Limitations for Report Results
Report size is measured by the number of database rows retrieved for a report. Note that the number of rows that must be retrieved for a report may be greater than the number of rows displayed, for example when report results are segmented across multiple classifications.
Report results are truncated if they exceed the following row limitations. These limits are enforced for performance reasons. Limits for retrieved rows are consistent across all NetSuite reports, with higher limits for reports executed in the background, such as scheduled, emailed, and exported reports.
The limits for retrieved rows per report are:
-
100,000 rows — for a report executed on demand (synchronously)
-
1,000,000 rows — for a report executed in the background (asynchronously)
If a report is being truncated, you can try the following:
-
Set additional filters to limit report results. See Filtering Data on Reports.
-
Create a saved search to return the desired data. Saved searches do not have row limitations like reports, although you may be unable to export search results with extremely large data sets. See Defining a Saved Search. To learn how to persist saved search results for searches that contain a high volume of data, see Persisting Search Results.
-
Obtain access to NetSuite SuiteAnalytics Connect service. See SuiteAnalytics Connect.