| report parameter [message #314656] |
Thu, 17 April 2008 07:10 |
Abeer30
Messages: 110
Registered: March 2007
|
Senior Member |
|
|
Hello,
I have created an independent value set "TESTING" that contains a list of values, which i have added, for the descriptive flexfield "Transaction history" in the "miscelleneous issue" form in the invetory module.
I have attached the value set "TESTING" to the column "Attribute 1" in the table "mtl_material_transactions".
I have also created a report that select "Attribute 1" Column from "mtl_material_transactions".
Now, I need to create a parmeter that allows the user to enter one of the values of the value set "TESTING" and if the parameter left blank it will result in all the records of the original query.
Kindly note that in all the historical rows "Attribute 1" column is NULL.
What do I have to add in the query, report builder, and applications?
Please help...
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
