• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 807
  • 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!
  • 2
1 Solution
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!
ShamanthAuthor Commented:
I am talking about Web-I not Crystal
ShamanthAuthor Commented:
I am closing the question. No use ...
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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