Handling Semicolon when user selecting multiple prompt value

building reports webintelligence
1

Hi All

Im using a character prompt in report. Ex: List of product name.
By default semicolon would be the delimiter if the user selects more than one product.
Ex: PROD1;PROD2;PROD3

But in database level itself the product values are look like
‘PROD1;1.1’
‘PROD2;2.1’
‘PROD3;3.1’

so when i select the above list of products in Infoview, it return no data to retrieve. The reason is, it delimits the value till semicolon (like ‘PROD1’ ) so its not taking the full char value (like ‘PROD1;1.1’) . it took till semicolon and says no data to fetch

The same report which i run in BO Deski, it returned the data and it handle the prompt value as a whole string like @{PROD1;1.1}@

kindly help me how to handle this issue

Thanks in advance
msbo

msbo :india: (BOB member since 2008-04-14)

2

Please do not cross-post. It leads to fragmented discussions and is against our forum rules.

The same post is here:
https://bobj-board.org/t/143293

This topic is now closed.

Marek Chladny :slovakia: (BOB member since 2003-11-27)