Getting Report Info using Apex

Question

I was looking to see if I could gather the following highlighted parts from a report programmatically using Apex. These are the headings you would see if you go to the folder where the report is located.

The only part I was able to get was the Created On date from the getStandardFilters() method. Is there any way that I can get the rest of the parts programmatically? Any help is much appreciated. Thanks.

Answer 1

Yes. Use the describeReport method in the ReportManager class, then call the getReportExtendedMetadata method on the ReportDescribeResult class, and finally call the getDetailColumnInfo from the ReportExtendedMetadata class. This gives you a Map<String,Reports.DetailColumn> value that contains the various details, including API name and label for each column.

Reports.ReportDescribeResult reportInfo = ReportManager.describeReport(reportId);
Reports.ReportExtendedMetadata reportMeta = reportInfo.getReportExtendedMetadata();
Map<String, Reports.DetailColumn> columnData = reportMeta.getDetailColumnInfo();
for(Reports.DetailColumn column: columnData.values()) {
  System.debug(column.getName());
  System.debug(column.getLabel());
}