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
Nagarajan CNagarajan C 

Need to send report to non salesforce user

send Salesforce reports in excel format to non-salesforce users
and  schedule these reports to be sent form Sandbox


Can you please advice anyone any salesforce appexchange product available 
Bhawana Mehta SFDCBhawana Mehta SFDC
HI @Nagarajan : There are two you can achieve this.
a) Using some app exchange product like 'Report Builder' 'Report sender app' etc.
b) You can create these non-salesforce user as Chatter user in salesforce, assign them chatter free licenses and then you can schedule these user for your reports.

Option B is what I would suggest you to go for. And there are so many chatter free licenses that you dont really need to worry about the limits.
Jakub Kołodziej 7Jakub Kołodziej 7
Option C: You can probably do it using apex, i didn't try this soultion but in my view it is possibl. Try something like that: 
// Get the report ID
List <Report> reportList = [SELECT Id,DeveloperName FROM Report where 
    DeveloperName = 'reportname'];
String reportId = (String)reportList.get(0).get('Id');

// Run the report
Reports.ReportResults results = Reports.ReportManager.runReport(reportId, true);
System.debug('Synchronous results: ' + results);

// Send Email with result also

 
Pragati Mahale1Pragati Mahale1
Are you able to send reports to non salesforce users?
 
Nikita Meshram 2Nikita Meshram 2

@Bhawana Mehta SFDC, Please can you guide how to use this chatter license basically I created a chatter license for some users but I am unable to send an email to them because in the schedule report not getting those user names in Select From

Please can you guide how to send report to non salesforce user 
chakrapani reddy 1chakrapani reddy 1
Guys I'am also looking for the same solution for "how to send report to non salesforce user " if any one find the answer would be appriciated.
thanks in advance..