function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Sahil GavaliSahil Gavali 

"This report has more results than we can show (up to 2,000 rows).

Salesforce report displays a message as "This report has more results than we can show (up to 2,000 rows). Summary information is calculated from full report results." How to increase the number.

 
HarshHarsh (Salesforce Developers) 
Hi Sahil,
  • Salesforce will simply show the first 2000 in the UI, and to get the rest you can press the Export button on the top-right corner.
  • You need to export the report to see all the data.
  Please follow the following Documentation for more information.
https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/apex_analytics_limitations.htm 

For some common report limits please refer below links 
 https://help.salesforce.com/s/articleView?id=sf.faq_reports_common_limits.htm&type=5

You can refer to Trailblazer Community for the same.
https://trailhead.salesforce.com/trailblazer-community/feed/0D54S00000A91wOSAR

You can also refer to the same question on Stack Exchange.
https://salesforce.stackexchange.com/questions/120236/how-can-i-get-a-report-to-return-more-than-2-000-rows-using-the-reportresults



Please mark it as Best Answer if the above information was helpful.

Thanks.
Naresh Kaneriya 9Naresh Kaneriya 9
Hi Sahil Gavali,

Salesforce has a limitation of displaying a maximum of 2,000 rows in a report to ensure performance and usability. However, you can overcome this limitation by using some alternative methods to access and work with your data:

If you need to work with all the data, you can export the report as an Excel or CSV file. This will allow you to access and analyze the complete dataset in a different tool like Microsoft Excel or Google Sheets.

Please mark it as best answer if the information is informative.so that question is removed from an unanswered question and appear as a proper solution.
Thanks, Naresh
Sahil GavaliSahil Gavali
Thank You, Naresh....!!!

In this context, I'd like to mention an additional step: you can establish a connection between the Salesforce report and an Excel file to retrieve data. This process allows data to be fetched automatically. However, it's important to note that only a subset of the data, specifically 2,000 rows, is fetched initially. This might not completely meet your requirements.