You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Burst to multiple email addresses stored in a parameter

Accepted answer
126
Views
3
Comments
edited Jan 18, 2024 5:37PM in Reporting and Analytics for ERP 3 comments

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!