BI Publisher (MOSC)

MOSC Banner

How to pass multiple values for Parameter from a list?

I have a report, in which I want to use a list in the Parameter.

I set up the list and used a SQL Query. This works fine.

I set up the Parameter to use the list and it works fine when one item is checked.

When I select more than one item from the list I get an error.

My Data Set has the parameter in it. I tried to use the column IN(:PARAMETER), but BI Publisher wont accept the Parenthesis. It says failed to load SQL. If I use equals I get an error when selecting more than one item from the list.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center