COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Archana_M on 15 Aug 2013 07:23:20 AM

Title: Need help to solve query in the value prompt
Post by: Archana_M on 15 Aug 2013 07:23:20 AM
Hi All,
I have a requirement wherein the prompt button should display the Employee names ,& accordingly it should display data for that employee.
However,when I try to use Employee Name in the value prompt button ,it shows that the data not available,but When i try to use employee id in the value prompt button ,it display data correctly.
How do I solve this????
Eg:Emp_id=1 Archana_M
Title: Re: Need help to solve query in the value prompt
Post by: MFGF on 16 Aug 2013 05:24:19 AM
Hi,

A Value Prompt has two entried you can define - a "Use" value and a "Display" value. Leave the "Use" value as Emp_id, and set the "Display" value to the name.

Cheers!

MF.
Title: Re: Need help to solve query in the value prompt
Post by: Archana_M on 21 Aug 2013 06:51:41 AM
thank you!!!!!!!!!!!!