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 many universes can be created in a project?
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
What is the dense rank?
can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?
Explain in detail about type 1?
explain in detail about type 3?
what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?
1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
What is the difference between absolute and relative div positioning?
what is the difference b/w the refresh and buffered data?
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....
Can we configure two instances of CMS pointing to two different CMS system databases?
8. How much supervision have you typically received in your previous job?
Explain is it the job of a business analyst or systems analyst to draw the class diagram?