I did fix this problem. What you need to do is
1) Create the report to use "dynamic = me". For example "opened by - is dynamic - me"
2) Create a template for the schedule you want to run
3) Create a Scheduled Script that will use the template to create new ScheduleOnce schedules for all users or groups you want. The script will set the "run as" field to the specific user and let the schedule run for that user.
In step 2) I originally used a Script Include to create the schedule:
var scheduled_report = new GlideRecord('sysauto_report');
//Set the scheduled job to active
scheduled_report.active = 'true';
//We add report title and user name to the name for clarity
scheduled_report.name = ''
+ 'Scheduled Email Report of '
+ report.title
+ ' - '
+ user.name;
//Run report as given user to show only his records
scheduled_report.run_as = user.sys_id;
//Sent report to same user, so he receives his own report
scheduled_report.user_list = user.sys_id;
//Only send the report once
//It will be rescheduled if needed
scheduled_report.run_type = 'once';
scheduled_report.report_title = subject;
scheduled_report.report_body = body;
scheduled_report.report = report.sys_id;
scheduled_report.omit_if_no_records = omit;
//Now, insert the newly created scheduled job to start running
//As it is a "once" job, it will run automatically
var answer = scheduled_report.insert();
The function had parameters like "user" and "report", but I just recently discovered that there is an OOTB script include for this functionality. So it might be better to check that one out as well. It's an object called "ScheduleOnce" and is an extension of the "Schedule" object.
