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?
Answer Posted / 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 |
Post New Answer View All Answers
How can you first report in Business Objects by using broadcast agent?
Explain difference between zabo and webi?
Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....
What three things do you consider to be the most important factors for a manager?
Explain about a task that really tested your analytical abilities?
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
How to restrict password to a user while sending a document in .pdf format
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
Explain what sort of existing documents should business analysts refer to when starting on a new project?
What are all difference between business objects 6.5 and xi r2?
In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha
Explain what is the difference between business requirement document and use case document.
What are the steps to be taken to schedule the report?
What is thumbnail?
What is the difference in creating filters in designer and business objects?