• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4464
  • Last Modified:

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..


0
Mounikaa
Asked:
Mounikaa
  • 4
  • 2
1 Solution
 
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
 
MounikaaAuthor Commented:
I have the  = sign.

I am not getting any error message.
but, I am getting the data in.
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
BostonMACommented:
I think you want the switch function. Ex:

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

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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now