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.
See the "Running One View Reports chapter, Layout Tab section" in the JD Edwards EnterpriseOne Applications One View Reporting User Guide for more information.