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.
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
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??
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.
thanks a ton ..
it worked