I'm trying to insert a parameter which allows the user to input a list of email addresses for a certain date range and it will return a list of orders for those customers. I've looked at several other similar posts however have been unable to come up with a solution for the problem that I'm having.
I created the followin parameter: {?Email}
which is a string and selected the option to allow multiple values then in the record select expert i inserted the following formula.
{WM_ORDER.DT_PLACED}={?Date Range} and
{WM_ORDER.EMAIL} in split({?Email},",");
I receive an error message that the array must be subscripted. A few things to note:
WM_order.email is a sting [80]
Any help would greatly be appreciated.
I created the followin parameter: {?Email}
which is a string and selected the option to allow multiple values then in the record select expert i inserted the following formula.
{WM_ORDER.DT_PLACED}={?Date Range} and
{WM_ORDER.EMAIL} in split({?Email},",");
I receive an error message that the array must be subscripted. A few things to note:
WM_order.email is a sting [80]
Any help would greatly be appreciated.