Hi i have a report in that i am using filter
ex: amount payed='yes'
Now i want create a value prompt on the customer no now i want to see customer nos who Pay the amount in the value prompt drop down list
Hi,
Add a prompt page to your report, then from the toolbox bring in a value prompt and work through the prompt wizard to generate your customer parameter, filter, prompt and prompt query.
Once this is complete, go to the Query Explorer and select the query used for your prompt.
From the toolbox, add a detail filter to this query [amount paid] = 'Yes'
When you run your report, the query bringing back the customers for your value prompt now only shows those customers who have paid...
Hope that helps.
MF.
hi,
prompt is a dynamic filter which forces the end user is selecting or entering the values to restrict the data from the dwh