HI,
I am trying to create a report with prompts that will ask for user input. I created the report with “Type a new prompt” in Query panel and it is working well…It asks for user input to type the values or select from List of Values…but for my user, if they have to select all values from the list(List is big), instead of selecting all values is there a way to suppy a value like “ALL” which gets all the data from the LOVs??? Any suggestions?? Thanks in advance…
JOHN
Thanks Andreas,
I created an object with @select(CLass/Object) in @ Prompt(‘Select Product Numbers or enter * for all Products’ , ‘a’, ’ Class\Object’, multi, free) )
When i select this object into query i have an SQL error Msg:
ORA-00923: FROM keyword not found where expected :-923
When i view the SQL i have two Sql queries…One for each context i guess… How to rectify this error? thanks
JOHN