Value prompt

[jd]

Hi,

I have a value prompt in promptpage with all Regions. when I run the report it is prompting me to enter the value. but here in the value prompt box I did not see any region names. how can I get all the region names in value prompt? do I need to set any properties for value prompt??

Thanks,

[MFGF]

Your value prompt should be populated by a specific query.  If you look at the Query property of the prompt, you should see which one.  Look at the items the query retrieves from the database - is Region Name a query item?  If not, add it as a data item.  Then go to the properties of the prompt again and look at the "Display value" property - set this to be Region Name.

MF.