You need to sign in to do that
Don't have an account?
Hemanthrulez
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.
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.