Solved

Choose function in ssrs 2008

Posted on 2010-09-22
6
3,877 Views
Last Modified: 2012-05-10
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
Comment
Question by:Mounikaa
  • 4
  • 2
6 Comments
 

Author Comment

by:Mounikaa
ID: 33736447

ANYBODY IS THERE TO RESPOND??
0
 
LVL 4

Expert Comment

by:BostonMA
ID: 33736843
What error message are you getting? Do you have the = sign to start the formula?
0
 

Author Comment

by:Mounikaa
ID: 33736865
I have the  = sign.

I am not getting any error message.
but, I am getting the data in.
0
Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

 
LVL 4

Accepted Solution

by:
BostonMA earned 500 total points
ID: 33736926
I think you want the switch function. Ex:

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

0
 

Author Comment

by:Mounikaa
ID: 33736939
k
let me try that.
and get back to you..
0
 

Author Comment

by:Mounikaa
ID: 33737006
Hi,

Thanks so much..

It worked for me..
0

Featured Post

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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

How to use Variables  and Custom code in SSRS report and Assembly reference to use compile shared code in SSRS. Its big question for all who are working with SSRS. It is easy to create assembly and refer in SSRS report, still there are some steps…
A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question