The recipients of a scheduled Classic Designer report can be determined by the
result set of a report. When scheduling
a report from the Report Scheduler page in the Admin - Manage Access tab, select Report Driven for the Distribution field in the
New Report Schedule dialog then select the report containing the recipients.
A report for report-driven distribution must contain a table and no chart, where the logical name of the first column in the report is Email and contains the email addresses of the recipients (multiple values need to be separated by a semicolon). The logical name of the column must be "Email". It's not sufficient to rename the column in the report.
Report-driven distribution can be used in conjunction with report bursting. For example, assume the ditribution report contains two columns: Email and Store ID. The content report can be filtered by the Store ID value provided in the distribution report if the content report contains a prompted filter for Store ID with the prompt name matching the Store ID column name.
If the column name is Store ID, the prompt name needs to be Store ID as well (not Stores.Store ID). See Setting Up Report Bursting.
An optional second column in the distribution report with the logical column name Username that contains email addresses of existing Birst users can be used to control data-level visibility. Birst automatically instantiates the session variable USER when it creates an instance of the scheduled report for a Birst user.
The logical name of the column must be "Username". It is not sufficient to rename the column in the report.
See Also
Scheduling Reports in Admin
Setting Up Exception Reporting
Setting Up Report Bursting