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

Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com

2384


Differences between business objects and web intelligence reports?

1196


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

1942


Explain in detail about type 1?

1576


What is the difference between user and versatile user?

1055


Which command using Query Analyzer will give you the version of SQL server and operating system ?

5031


how get the grand total in master-detail report?

2219


can anybody tell me about complicated object you have created

3210


I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.

3453


what are the day to day activities of BO administrator ?

3013


Explain in detail about type 2(scd),

1084


What sort of existing documents should business analysts refer to when starting on a new project?

1001


Is there any other repository domains rather than universe, security, document?

1039


What is the difference between condition & filter?

1442


Explain is data mart?

998