BusinessObjects Board

problem with prompts in a report

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


john_ed (BOB member since 2004-09-08)

Please, take a look at this entry in Designer FAQ.

There is no solution for Reporter, you will need Designer.


Andreas :de: (BOB member since 2002-06-20)

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


john_ed (BOB member since 2004-09-08)