Burst to multiple email addresses stored in a parameter
Summary:
Burst to multiple email addresses stored in a parameter
Content (please ensure you mask any confidential information):
I would like to have Bursting to multiple email addresses that are stored in a parameter (either as Fixed Data LOV, or dummy SQL query from DUAL). The issue I am having is that when the report runs, it is only bursting to the first email address stored in the parameter.
SQL Dummy Query LOV:
Fixed Data LOV:
Parameter definitions for the above LOV's (with Multiple Selection checked):
Bursting Query:
In the bursting query you can see I have tried passing in both parameters (P_EmailAddress , P_EmailAddress2), however only the first email address listed in either LOV is what email address is being bursted to. When I run the report, I am using the 'All' value for the Parameter.