on 05-03-2012 2:30 PM
Hello,
is it possible to base the filter of a Prompt on for Exp. Product_ID but to show in the prompt both Product_ID and Product_name. Both values should be LOV-Values. Reason is that we have duplicate Product names wihich filter many IDs if we base the filter on the Name ...
Message 'Please select a Product'
display like '12012 - Productname X'
multi Vallue
Thanks ..
Hi,
Create a Cascading prompt on Product name like below.
1. Create two objects called Product Id and Product name and in Onject properties check Export with Universe for LOV's option.
2. Write a prompt on Product name like below in universe
Select Product name form ********* where Product Id = @Prompt("product Id")
3. Define Prompt for Product name in Universe/Report level as required.
Cheers,
Suresh A.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.