I have got a custom report where the actual record count is 6 Million but when in UI after loading the report, I can see only "1,000,000 results returned ". Is there any limitation? I've observed similar behavior in OOB reports like Application installation details
Oct 12, 2023 08:01 PM
As you have found there is a limit of 1 million records for custom reports. This is also mentioned in the documentation found here in section 4.a.:
There are also some suggestions for working with this limit to get the 6 million records you expected.
Oct 13, 2023 10:32 AM - edited Oct 13, 2023 10:33 AM
The 1 million record limit that applies to custom reports does not apply to some built in grids, such as the All Evidence grid you are looking at.
This is not controlled by any permissions. The behaviors you are seeing are determined by the implementation of different parts of the system. For example - data shown custom reports gets pre-calculated cached, and so this data is limited to avoid using unacceptably large amounts of cache space. However data for the All Evidence grids is read directly from the underlying data when needed and is not pre-calculated & cached, and so the cache space concern is not a relevant factor.
Oct 30, 2023 02:51 AM