Can some one say abt "ALL" in prompt ..
How to get the word "ALL" in the prompt along with the list of values?
Plz give me the steps?
Answers were Sorted based on User's Feedback
Answer / latha
yes,we can add ALL in lovs of any obj.In unv level double click on any obj,in properties tab,edit the view sql tab&add below select statement
select distinct
Agg-yr-qt-rn-st-ln-ca-sr.state
from
Agg-yr-qt-rn-st-ln-ca-sr
UNION
select distinct
'ALL'
from
Agg-yr-qt-rn-st-ln-ca-sr
and enable the option"do not generate sql before running"
and develop a prompt for this obj
select where clause of this obj add
state=@prompt()
or
'ALL'=@prompt
Is This Answer Correct ? | 7 Yes | 0 No |
Answer / prathmesh
@Prompt('PROMPT TEXT','A',<PATH FOR
LOV>,Multi,Free,Persistent,{'ALL'})
THIS WILL ADD AN EXTRA VALUE CALLED AS "ALL" IN YOUR LOV
Is This Answer Correct ? | 3 Yes | 2 No |
Answer / bhaskar
Hi Thotadwh,
Thanks for the kind information
It's not a prompt message, it should be get as a prompt
value along with the List of values while refreshing the report.
Scenario:
Mono - We can provide Single value
Multi - We can select all possible LOV's one by one
ALL - Here, it will take all possible LOV's & need
not provide one by one
Note: Hope it's not a parameter of the prompt,
How will we get the "ALL" word along with the LOV's.
Is there any workaround at DB level or Universe or Reporting
level to get the word "ALL" into the picture at report level.
------------------------
Any answer will be helpful.
Thanks in advance.
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / bhaskar
HI LATHA,
UR STATEMENT IS FINE.
BUT
WITHOUT PROMPT IN WHERE CLAUSE:
WHEN I RUN THE REPORT USING PROMPT VALUE 'ALL' IT'S SHOWS A MESSAGE CALLED 'NO DATA TO FETCH'
WITH PROMPT IN WHERE CLAUSE:
IT'S ASKING FOR TWO PROMPTS,I.E
ONE PROMPT WITH LOV EXCLUDING 'ALL'
AND
SECOND PROMPT WITH LOV'S INCLUDING 'ALL'
I HOPE THAT HERE I AM GETTING THE RESULT BASED ON FIRST PROMPT//
LET ME THE KNOW REASON THAT, WHERE I AM GOING WRONG
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / satya
As per my knowledge, "All" option is not in Prompt. But by
using "list of values" option ,We can select All values.
Is This Answer Correct ? | 0 Yes | 2 No |
Answer / thotadwh
I dont think you can do so as far as i know. We can do so by checking optional prompt in prompt parameters.
Is This Answer Correct ? | 0 Yes | 3 No |
How can we acheive Correlated sub-query in Designer?
2 Answers Infosys, TCCX, Wells Fargo,
when I am trying to schedule the report its running faster then I tried to run it manually?? why is it so that there is difference of time between scheduling and manual run for report
Explain about alerts in bos, under what situation we need to use alerts?
Explain is data mart?
it is possible to link two universes of separate functional domain ?
if there are 2 hierarchies 1 is a-b-c and another one is a- c which hierarchy b.o takes while we use drill mode
What is the test methodology for testing BO Universes?
What are the Users and User groups?
Is there any other repository domains rather than universe, security, document?
Hi,can anybody help me to do like this, i have one dp with agerange, first name ,Address. And another dp is agerange,age min , last name. in this two data providers agerange is common . I want to see in my report all the fields . How i can merge it ?
I have one vertical table and in that table there are 10 rows. I want to add one row between 4-5 row. How it possible in WebI.
how to solve #multivalue, #syntax, #error. iwant complete solution process in practical wise?