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
- 12668 Views
- Accenture, Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the dense rank?
How many universes can be created in a 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?
Can you please send me the migration related issues .
what will be the contents for a functional requirements specifications
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
What is the difference between datawarehousing and businessintelligence?
What are the join problems comes appart from loop,chasm & fan Traps
Explain the difference between detect alias and detect context?
what is the difference b/w the refresh and buffered data?
What are the data types present in bo? What happens if we implement view in the designer and report?
Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?
U r project in which stage in implementation?
How would you format some text using css to be verdana and bold?
Explain what are the measure objects?
