Displaying Values(like 23) instead of user names(like 'dnr') in text box promtu

[nagaraju2399]

HI Gurus,

user wants to select the employee id's instead of  employs name in text box prompt.

user sent the all employee id's list to me  and we don't' have employee id's data item in data base. We have only employees name data item.

how we can displaying employee id's instead of  employs name in text box prompt.

Any help on this would be appreciated.

[MFGF]

HI Gurus,

user wants to select the employee id's instead of  employs name in text box prompt.

user sent the all employee id's list to me  and we don't' have employee id's data item in data base. We have only employees name data item.

how we can displaying employee id's instead of  employs name in text box prompt.

Any help on this would be appreciated.

Hi,

A Text Box Prompt doesn't display anything - it prompts a user to type in a value. Can you explain in more detail what your requirement is? A user selecting a value sounds more like a Value Prompt? Is this what you mean?

If you don't have Employee IDs in the data your report has access to, you're going to find it rather difficult to display these in a prompt. You could perhaps add them in manually as Static Values in the prompt (the Use Value would be the Employee Name and the Display Value would be the Employee ID) - but this would be rather tedious to set up initially, and it would not change as employees in the database change.

Your best bet is to get whoever looks after your Cognos package (and/or the underlying database) to add the Employee ID in to the data so you can use it easily.

Cheers!

MF.

[nagaraju2399]

sorry,

user wants to type  the employee id's instead of  employs name in text box prompt and user don't want to use the value prompt
He want only text box prompt.

Thanks for your replay.

[nagaraju2399]

Hi gurus,

Could any one please help me to get solutions.

thanks for your advance help and support .

DNR

[MFGF]

Hi gurus,

Could any one please help me to get solutions.

thanks for your advance help and support .

DNR

I already did. I suggested you get whoever looks after your Cognos package (and/or the underlying database) to add the Employee ID in to the data so you can use it easily. Unless the correlation between employee name and ID is defined somewhere, what you want to do isn't going to be possible. If you try to define it in an expression in a report (using a case or if-then-else construct), it will be almost impossible to keep up to date as employees change in the data. If you have to write multiple reports the problem will increase exponentially.

Do as I suggest and get the Employee ID added to the reporting data. It's the obvious and most simple solution.

Cheers!

MF.