value prompt

[utathyaghosh]

i have to use a value prompt for the month. but its in month-number. i want to use month-name instead but it's not present in the package. so how can i achieve it??
thanks in advance.

[Gopinath]

Create a date item with a case statement like

Case [Month]
when 1 then 'January'
when 2 then 'February'
.....
....
End

and use it as Display Value for the value prompt

[utathyaghosh]

i tried that but as it is not in the package from where the data is pulled out, the data item that i created using the 'case' is not available in the value to display drop down.......
any other option??

[HalfBloodPrince]

i think u have created column in some other query. Try this

right click on Ur value prompt -> go to query option . it will take u to the prompt query . here create the calculated column, then set use value , display value as per Ur requirement.

[utathyaghosh]

thanks a ton ..
it worked