function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Kuliza DevKuliza Dev 

How to get number of records in each report?

Reports = [select Id, Name from Report where Format = 'Tabular' order by Name];
          for(Report report : Reports)
          {
              ReportModel rm = new ReportModel();
              rm.ReportId = (string)report.get('Id');
              rm.ReportName = (string)report.get('Name');
              options.Add(rm);
          }
I'm trying to fetch the number of records in each Report. I tried using getRecords() but it is saying invalid function. I am flexible to implement this through Apex or SOQL. 
sandeep@Salesforcesandeep@Salesforce
To fetch object level information of report you need to use metadata api way. 

Please go through :
https://developer.salesforce.com/forums/?id=906F0000000AmszIAC

Thanks
Sandeep Singhal
Amit Chaudhary 8Amit Chaudhary 8
you can try the salesforce analytic Api for same
1) https://resources.docs.salesforce.com/sfdc/pdf/salesforce_analytics_rest_api.pdf

Sample code
1) https://glazeforce.wordpress.com/2016/03/29/workaround-to-2000-record-limits-in-report-analytics-api-salesforce/
2) https://blog.force365.com/2013/09/28/salesforce-analytics-api/

Let us know if this will help you