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
HemanthrulezHemanthrulez 

Display tables from reports

Hi,
 

I have few reports in my picklist. As I click on each report name, the output panel with iframe component is being rendered. But I dont want the entire report to be displayed. I just need the table in the report.How do extract the table information from the report?

 


Need help.

 

 

sfdcfoxsfdcfox

If you use "csv=1" as a URL parameter for the report, you can get just the CSV data, which you could then massage into a viewable table via JavaScript. Or you could use "excel=1" and you'll get a pretty XML-formatted Excel-compatible sheet. Finally, you can use the Console View parameter to show the report as a page without a sidebar or tabs using "isdtp=mn" as a parameter.

 

https://na1.salesforce.com/00O3000000XXXXX?csv=1

https://na1.salesforce.com/00O3000000XXXXX?excel=1

https://na1.salesforce.com/00O3000000XXXXX?isdtp=mn

 

The last choice changes the formatting for a smaller view space, but I think it might be what you're looking for.