Hi all,
my query is how to show all of object values in the prompt without selecting from lov.
when refresh the report prompt value is fill up with all object values.
amitrathi1234 
(BOB member since 2007-10-15)
You will have to use ‘All’ or ‘*’ to run the report for all values.
Though it will not show all those selected values in the prompt
And the syntax for ‘All’ should be created in universe in the prompt condition object
Read syntax for ALL
.
haider 
(BOB member since 2005-07-18)
Thanxs…
can you give me a example or syntax how to apply on object in the designer…
amitrathi1234 (BOB member since 2007-10-15)
It is clearly given in the link provided by Haider. Anyhow create an object in the universe with the following code.
Below is a sample of the syntax required to allow a user to select one, many, or all values from a prompt.
Code:
(@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\Country Group’,multi,free))
In the sample, the asterisk is used as the wildcard. The first part of the formula…
Code:
(@Select(Sales Geography\Country) IN @Prompt(‘Select Country or
enter * for all countries’,‘a’,‘Sales Geography\Country’,multi,free) )
works when a user picks one or more values from the list. The second part…
Code:
OR
(’*’ in @Prompt(‘Select Country or enter * for all countries’,‘a’,‘Sales
Geography\Country’,multi,free))
works when the user selects the asterisk.
Jansi (BOB member since 2008-05-12)
I am not able to send a pdf which has more information.
Jansi (BOB member since 2008-05-12)
It has been sent to your mailbox
Jansi (BOB member since 2008-05-12)