Drop Down List to a Text Box on InfoView

[dideb]

Hello All,

I have a report created in BO 6.5.1
In the SQL of the report, we placed the following in its Where clause:
where AI LIKE @prompt('Action Item:','a' ,{'%', 'A', 'B', 'C', 'D', 'E', 'F', 'G'} ,mono ,free)

When the report is published to InfoView, the prompt appears as a Drop Down List, not a Text Box with a "Show Values" button although i am using the option "free".

So, how can i change the Drop Down List to a Text Box on InfoView?


Thank you,

Diaa

 

[bertdijks]

Question: Did you only adjust the SQL in the report, or dir you also change it in the universe?

 

[sh4kil]

You see a list box, but you there should be a text box above it for you to type in a FREE value.

You cannot change SQL manually in WebI 6.5.