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 / 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 are the tables used in health care domain project and columns used in report?
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
Explain about a task that really tested your analytical abilities?
how to prepare the documentation in business objects and where to get the requirement?
Difference between b.o 5.1 and 6.1b?
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 ?
What is the difference between datawarehousing and businessintelligence?
what are the day to day activities of BO administrator ?
Explain what would you consider as your biggest achievement and why?
Which versions are used in the bo dashboard work?
Migration of Reports from business objects 5.1.5 to samee version in different hardware?
What is thumbnail?