Report Has Exceeded Maximum Records Warning

When running a report, if you receive a warning that states that the report has exceeded the maximum number of records, this may be due to the Select Row Set value for the report. The row set options specify which data to be used in a report. When you use the "Retrieve record count" option, the report will display data up to the number of records specified, even if more than the specified number of records match the query conditions. The default for this field is 500, but this value can be configured differently for your company and can also be overridden when you run a report or add a new report, if you want to limit the number of records retrieved.

When you select the "Use current data in grid" option as your Select Row Set value, the report displays only the data from the grid, so you may receive this warning if there are more records matching the query conditions than the current data in the grid.

Finally, when you use the "Retrieve all records" option, you will receive this warning if the number of records exceeds the system limit.

If the report data is limited due to this setting, you receive the following pop-up warning: "Warning! Report has exceeded the maximum number of records specified. Results shown are incomplete." The report still runs if you click OK on this warning; however, it only returns a subset of the applicable data based on the value specified in the Retrieve record count field.

Note: The report is limited by the number of rows specified in the report data set as explained above, but it is also limited by the system limit. If the system limit is lower than the report data set limit, the system enforces the lower data limit. For example, if a One View report has a data set limit of 10000 rows whereas the system has a limit of 5000 rows, the One View report is limited to 5000 rows.

See the "Running One View Reports chapter, Layout Tab section" in the JD Edwards EnterpriseOne Applications One View Reporting User Guide for more information.