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,
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.