Report List in XML
Salesforce doesn’t provide a native way to get the report information via Apex or VisualForce but there is a way to get the list of reports in XML. From the XML result, you can just parse the contents and
https://INSTANCE.salesforce.com/servlet/servlet.ReportList
If you need to embed a report into an iFrame to be shown in a VisualForce page you may use the following parameter to show the report without the header:
https://INSTANCE.salesforce.com/REPORT_ID?isdtp=mn
Direct links to export the report
Export as csv:
https://INSTANCE.salesforce.com/REPORT_ID?isdtp=mn?export=1&enc=UTF-8&xf=csv
Export as excel:
https://INSTANCE.salesforce.com/REPORT_ID?isdtp=mn?export=1&enc=UTF-8&xf=xls
Printable view:
https://INSTANCE.salesforce.com/REPORT_ID?excel=1
Notes:
- Make sure to change the INSTANCE (Ex. na1, na6, na7.) and the REPORT_ID (Ex. 00O80000003lfzv)
- These are undocumented features so Salesforce can change these anytime.
http://www.cloudjedi.com/blog/salesforce/salesforce-report-links/