LAPI 9 - Need to pass comma delimited list input parameter to LiveReport

Pamela_Weller

I need to pass an input parameter to a LiveReport that contains a comma delimited list of values that can be used in a SQL statement that looks something like this: "SELECT...FROM...WHERE name IN (%1)". I have been told that the input parameter value gets passed in to the query inside quotation marks, which then defeats the "IN" clause. So if %1="Fred,Martha,George", the query sees the list as ('Fred,Martha,George') instead of (Fred,Martha,George). Does anyone know of some way to get the comma delimited list into the LiveReport Select statement without the quotes?