value prompt

[psandhya408]

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

[HalfBloodPrince]

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.

[psandhya408]

Thanks..it worked