Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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?

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


Please Help Members By Posting Answers For Below Questions

what are the tables used in health care domain project and columns used in report?

4459


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...

2097


can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?

1329


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?

2172


please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.

1950


Explain about a task that really tested your analytical abilities?

1188


how to prepare the documentation in business objects and where to get the requirement?

2152


Difference between b.o 5.1 and 6.1b?

1149


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 ?

1986


What is the difference between datawarehousing and businessintelligence?

1034


what are the day to day activities of BO administrator ?

2969


Explain what would you consider as your biggest achievement and why?

923


Which versions are used in the bo dashboard work?

980


Migration of Reports from business objects 5.1.5 to samee version in different hardware?

2269


What is thumbnail?

917