system
April 21, 2008, 1:38pm
#1
Hi all,
I am new to BO and webi. I have a requirement to use prompt in my report for order number.
user can either enter the order number in prompt or it should take ‘*’ to display all the orders.
how can I do this in prompts?
can anybody tell me please.
thanks.
ramcste (BOB member since 2007-10-24)
system
April 21, 2008, 1:42pm
#2
Hi,
The technique how to make prompt to accept ‘*’ (or ‘ALL’) and how to include it into LOV can be found in these 2 Designer’s FAQ:
Is there any way to set up a prompt that will allow a user to select one value, many values, or type ‘ALL’ for all values in a list?
Yes. Below is a sample of the syntax required to allow a user to select one, many, or all values from a prompt.
(@Select(Sales Geography\Country Group) IN @Prompt('Select Country Group or
enter * for all groups','a','Sales Geography\Country Group',multi,free) ) OR
('*' in @Prompt('Select Country Group or enter * for all groups','a','Sales
Geography\Co…
Now that my LOV lets me use ALL for all values, how do I get the ALL in the list?
Author: Dwayne Hoffpauir
There are two approaches - overriding the LOV SQL, and creating a universe object.
Overriding the LOV SQL
Press the SQL button in the query panel of the LOV
Add the phrase UNION SELECT ‘ALL’ FROM DUAL or similar dummy table for your particular database. For SQL Server (if you don’t care if the object parses or not) add SELECT xx From xx UNION SELECT ‘ALL’ (You don’t need a FRO…
Marek Chladny (BOB member since 2003-11-27)
system
April 21, 2008, 1:58pm
#3
you can create a predefined condition, something like :
( table.column in @prompt('prompt text','A','Class\objects',Multi,Free) or '*' in @prompt(''prompt text','A','Class\objects,Multi,Free) )
then, the user can select one or several values (the in sql operator", or all entering the ‘*’ value…
bernard timbal (BOB member since 2003-05-26)
system
April 21, 2008, 2:03pm
#4
thank you Marek and Bernard!!
Appreciate your immediate response.
ramcste (BOB member since 2007-10-24)