Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 806
  • Last Modified:

'All' Option in Web-I Prompt - LoV

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
Shamanth
Asked:
Shamanth
  • 2
1 Solution
 
Accpac_AttackCommented:
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
 
ShamanthAuthor Commented:
I am talking about Web-I not Crystal
0
 
ShamanthAuthor Commented:
I am closing the question. No use ...
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now