Choose function in ssrs 2008

Hi,

I have to hard code values 0,1,2,3,4,5,6 like pending, rejected etc. for a field.

I believe, i can use choose function for this.
following is the expression i've used. but, its not working for me.

Choose(field.value,"pending", "rejected","accepted").


Please correct me if i am wrong.

Thanks..


MounikaaAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
BostonMAConnect With a Mentor Commented:
I think you want the switch function. Ex:

 =Switch(
field.value = 1, "Pending",
field.value = 2, "Rejected",
field.value = 3, "Accepted"
)

0
 
MounikaaAuthor Commented:

ANYBODY IS THERE TO RESPOND??
0
 
BostonMACommented:
What error message are you getting? Do you have the = sign to start the formula?
0
[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

 
MounikaaAuthor Commented:
I have the  = sign.

I am not getting any error message.
but, I am getting the data in.
0
 
MounikaaAuthor Commented:
k
let me try that.
and get back to you..
0
 
MounikaaAuthor Commented:
Hi,

Thanks so much..

It worked for me..
0
All Courses

From novice to tech pro — start learning today.