BI Publisher (MOSC)

MOSC Banner

Need Help with "Search" option in "Parameter Types"

edited Mar 20, 2013 2:23AM in BI Publisher (MOSC) 1 commentAnswered
Hello,

We have a paramater in the BI Publisher Report. The parameter type is set as "Search" , the values may contain spaces in between for Example "UNITED    STATES" .

The spaces may be more than 1 in between.

Issue Description:

When User Type Exact string (without searchign) for example "UNITED    STATES"  with 4 spaces in between, the report runs fine.

When User selects this particular value from the "Search" option, the report does not return any record. We noticed that when we select it from the "Search Box" it passes only 1 spaces in between instead of actual spaces (4 in the above example).

The Report output is set as PDF, we also noticed that even if we supply 4 spaces in the search box , the report runs however after running the report when we copy the text in the PDF output, it shows one space.

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