function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Steve Houghtalen 4Steve Houghtalen 4 

How to programatially initiate the export of many (say 25-50) SF reports such that a user doesn't have to do it one at a time?

I am hoping someone has done this before or knows how it can be done.  Thanks

Steve 
Best Answer chosen by Steve Houghtalen 4
Alain CabonAlain Cabon
Hi,

With VFP/Apex and a list of reports (with checkboxes), that should be possible according the following post (exported reports sent by email):

How to export(CSV/Excel) Salesforce Reports using Apex and send email​
https://codecracksblog.wordpress.com/2017/04/11/how-to-exportcsvexcel-salesforce-reports-using-apex-and-send-email/

ApexPages.PageReference('/00O90000008oZK1?excel=1');

select id,name,developername,foldername,format,description from report

All Answers

Alain CabonAlain Cabon
Hi,

With VFP/Apex and a list of reports (with checkboxes), that should be possible according the following post (exported reports sent by email):

How to export(CSV/Excel) Salesforce Reports using Apex and send email​
https://codecracksblog.wordpress.com/2017/04/11/how-to-exportcsvexcel-salesforce-reports-using-apex-and-send-email/

ApexPages.PageReference('/00O90000008oZK1?excel=1');

select id,name,developername,foldername,format,description from report
This was selected as the best answer
Steve Houghtalen 4Steve Houghtalen 4
Thank you Alain.  This will work very nicely.  Much appreciated.

Steve 
Alain CabonAlain Cabon
Hi Steve,

Big thanks for your feedback (always valuable).

Alain