Prompts

[anumala28]

Hi,

User has to select in the prompt ' All'. How do i get ' All' in prompts.
I am using Report picklist.

Ex: Report piclist file Data:
20
30
50
etc.,
but user wants to see data in the prompts like this
All
20
30
50
etc.,

How do i get this, Please help..


Thanks,
Sri.

 

[esselinj]

You have 2 options to solve this problem. Either via a file picklist prompt or via a combination of a (in your case) report promtp and file picklist prompt. I should prefer the first option.

To accomplish the 1st option you do the following: You create an ASCII textfile containing the values YES and NO in 2 lines. Save this txt-file and and create a file picklist prompt which points to the file you just created.

The final step is to refine your filter expression. It should look something like this:

?<filepicklistprompt>? = 'YES' or <other prompt>. Impromptu actually tests if the first part of the expression is valid. If this is true thanImpromptu won't test the rest of the filterdefinition because of the OR-statement in the filter.

Hope this helps.

Cheers

Jack

 

[anumala28]

I am using Report Picklist file, and hotfile, This report picklist file automatically refresh every week and generates .ims files this .ims file i am using as source in another picklist file.
But i need to implement ' All' for selecting all data in the report picklist. How should i implement this in the Report picklist file.

Please Give suggestions....

Thanks,
Sri

 

[stewm]

You can do a UNION statement in Oracle in a view. And then SELECT ' ALL' FROM TABLE. This will add an all to your selection.

Mark Stewart
Consultants Club Corp.
Windsor, Ontario
Canada