COGNOS 8 Bi value prompt

Question

Currently I have a value prompt added to my report (with UI selected as List-Box) and the date item used is name 'YEAR'. Now when I run the report the values in the value prompt are seen as below:

YEAR

2004

2005

2006

What I want to do is get rid of the year tag that is present in the output of the value prompt box, more clearly the output in the value prompt box should be as below:

2004

2005

2006

Can someone let me know how that can be achieved?

Answer 1

hi guys i kinda figured out how this can be done. its just two lines of script which does the job. Since i din get any answer i thought not many people know about this so i am posting it here.

Lets say i name my List Box 'promptYear'

Then the following piece of code put in an HTML item does the job.

<script> document.formWarpRequest._oLstChoicespromptYear.remove(0); document.formWarpRequest._oLstChoicespromptYear.remove(0); </script>