Solved

'All' Option in Web-I Prompt - LoV

Posted on 2010-08-26
7
798 Views
Last Modified: 2013-12-12
How to create 'ALL' in Parameter List of values? I want to display it in the begining of LoV.
I have 500 +List of values for some parameter. User can add all the list of values at once by clicking CTR+A. I am not looking for this option.
I am looking  for 'ALL' value option in the lov and if the users selects that the report should run for all values.
I created the 'ALL' LoV by customizing the Object Lov SQL (Union from dual). I can see that 'ALL' value on the web-I report prompt. But that 'ALL' value is not referencing to any database values. So, I get a blank report. I think I am half way ... Please help!
0
Comment
Question by:Shamanth
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
7 Comments
 
LVL 4

Expert Comment

by:Accpac_Attack
ID: 33542693
You just add the "ALL" value to the list.  In your record selection formula, you do something like
If {parameter.value} = "ALL" Then True Else [Field.Value] = {parameter.value}

Good luck!
0
 

Author Comment

by:Shamanth
ID: 33567510
I am talking about Web-I not Crystal
0
 

Accepted Solution

by:
Shamanth earned 0 total points
ID: 33658429
I am closing the question. No use ...
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Developer portfolios can be a bit of an enigma—how do you present yourself to employers without burying them in lines of code?  A modern portfolio is more than just work samples, it’s also a statement of how you work.
Curious about the latest ransomware attack? Check out our timeline of events surrounding the spread of this new virus along with tips on how to mitigate the damage.
An overview on how to enroll an hourly employee into the employee database and how to give them access into the clock in terminal.
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

617 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question