Value prompt returning empty values

[barrysaab]

My Report is list report in which there are 200 categories items  and i want to restric user to less than 15 items only.This report is built through SQL query,so i have defined prompt in sql query itself using #prompt many function and have dragged value prompt on the prompt page and choose existing parameter.But when i run the report there are no values coming up in value prompt.where as when i slect packaged item,it is showing value.Is any way around,Please Help.Thanks

[blom0344]

This usually happens when one forgets to associate a use and display value with the prompt (in properties)

[barrysaab]

I did defined the use value and display value but still it shows no data.Thanks

[blom0344]

No output when you run the prompt query as tabular data?