Can report data be accessed programmatically through Salesforce Apex?

Hi Ratnakar,

You can refer to the standard salesforce api guide and search "RUN REPORTS" for this. Or you can use the below piece of code.

// Get the report ID
List <Report> reportList = [SELECT Id,DeveloperName FROM Report where
DeveloperName = 'Closed_Sales_This_Quarter'];
String reportId = (String)reportList.get(0).get('Id');

// To run a report synchronously
Reports.ReportResults results = Reports.ReportManager.runReport(reportId, true);
System.debug('Synchronous results: ' + results);

// To run a report asynchronously
Reports.ReportInstance instance = Reports.ReportManager.runAsyncReport(reportId, true);
System.debug('Asynchronous instance: ' + instance);

Hope this helps you.

Hi @Pranav,

I want to see a report owned by an owner (report link on VF Page) when he/she logs in.

For Eg;- I have created a report and Report Owner is ‘X’. Now when X logs in and access the VF Page(Report Link is already added), and clicks on report link, he should be redirected to his report.

Similarly, when Y logs in and clicks on report link(on VF Page), he should be redirected to the report assigned to him.

Any information would be a great help.

Thanks,