COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Prakash Bhai on 13 Sep 2010 03:10:06 AM

Title: Reg:Query Item
Post by: Prakash Bhai on 13 Sep 2010 03:10:06 AM
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


Title: Re: Reg:Query Item
Post by: blom0344 on 13 Sep 2010 03:58:20 AM
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..
Title: Re: Reg:Query Item
Post by: Gopinath on 13 Sep 2010 04:50:54 AM
Quote from: Abhi Ram on 13 Sep 2010 03:10:06 AM
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.