on 05-20-2015 6:33 PM
Hi All,
In my report i am using county column .
County colum contains 7 values (Australia,France,Germany,Holland,Japan,UK,US) .
so i enable LOV in universe ,Now user can select LOV in report as required .
Issue : Now user came up that he don't want to select 7 county values(Australia,France,Germany,Holland,Japan,UK,US)
instead of that he need ALL Values in A
ex: (Australia,France,Germany,Holland,Japan,UK,US) in A
so that if user select in LOV A all values should select.
How to implement this concept
I tried with diff concepts still
Thanks,
Or lookup for solutions here - http://www.forumtopics.com/busobj/viewtopic.php?p=99071#99071
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Which version of BO are you on? Can't you just make the prompt optional if you're on BO 4.x?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
My suggestion, In the report make this an an optional prompt and advise the user that if they don't select anything "all values" are selected by default.
If you still want to show "All Values" build a custom list of values with "All Values" as a value and use the case statement in the filter, something like
CASE WHEN country like 'All Values' Then 'India,US,Australia,China ELSE country END
Regards,
Naras
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Use input control. The best option in my opinion for situations like this. Just came to my mind.
To do at the universe level follow the screenshots to get the all values option.
Custom List of Values:
SELECT Country.Country
FROM Country
Union all
SELECT DISTINCT 'All Countries'
FROM Country
Filter & output:
@Select(Country\Country) =(
CASE
WHEN @Prompt('Enter value(s) for Country','A','Country List':'Country',Mono,Free,Persistent)='All Countries'
THEN @Select(Country\Country)
ELSE @Prompt('Enter value(s) for Country','A','Country List':'Country',Mono,Free,Persistent)
END
)
Hi Raghu,
I guess that you need a link,just a link to a new report. The link is called A and the report is the info from (Australia,France,Germany,Holland,Japan,UK,US)
Correct?
Check it, the hiperlink with paramters, it's not with country names but it's a example with city names.
And I add this link also: BOBJ Tricks: Cascading Prompts
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.