I have a query in my list report which is a join of two other queries.
How to create a value prompt for the joined query.?
When i am trying create a new value, it asks to select the column from the package .
But I have the column in my join.
How to create a value prompt for the joined query
Try this
Drag Value prompt, give parameter name ,directly click on finish. do not select any query item.
Then click on prompt go to properties and set query to join query in query property. Also set use value and display value to column from ur join query.
Then add filter to list report with parameter.
Thanks..it worked