Have you ever encountered a scenario where you would like to send a scheduled report to a specific user but they are not in the list of options? This is mainly because the user doesn't have access to the report because of the report folder settings.
In order to solve this issue, we just need to do the following steps:
- Pick a time when there are lease number of people using the system since we will
- Go to the report folder where the report to be sent is stored and then change the setting to "This folder is accessible by all users, except for portal users"
- Go back to the scheduler page of the report and you should be able to see all the users in the system
- As soon as the report is scheduled, go back to the report folder settings and then put back the old security settings
The process is a bit kludgy but its the only way to do it at this time until Salesforce fixes the issue.