Reg:Query Item

[Prakash Bhai]

Hi All,

In my package, I have a country code which is like this [ns].[xx].[country_code]. Based on this I have created a value prompt. And When I run the report it is displaying Country_code. But for the user in the run time it has to be get displayed Country but not country_code.  I tried by creating a data item and pulled the item in to exp def box. and renamed the data item in use value and display value. Still I find country_code at run time.
How to do the change in R.S

Regards,

Ram

[blom0344]

Your prompt query should fetch both country_code and country. In the prompt properties set use value to country_code and display value to country. disable caching on the query. Should be alright then..

[Gopinath]

I tried by creating a data item and pulled the item in to exp def box.
and renamed the data item in use value and display value.

Instead of renaming the data item,
Just rename the prompt parameter to Country.