Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 7 Answers
- 12586 Views
- Accenture, Wipro, I also Faced
- E-Mail Answers
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
What are the join problems comes appart from loop,chasm & fan Traps
Explain the difference between union and group?
I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!
Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?
Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
Explain how many universes can be created in a project?
what are the tables used in health care domain project and columns used in report?
What is the difference between user and versatile user?
what is xcelsius architecture?
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
What is difference between webi and infoview?
How would you format some text using css to be verdana and bold?
Explain what sort of existing documents should business analysts refer to when starting on a new project?
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
