Solved

Choose function in ssrs 2008

Posted on 2010-09-22
6
3,764 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
Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

 
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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Written by Valentino Vranken. A while ago I wrote an article called Chart Optimization Tips (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Chart-Optimization-Tips.html).  This article explained how …
After much searching across the internet I have found that you could not set the name of the file you were attaching to dynamic report subscriptons in Microsoft Reporting Services. I did manage to find one article showing you how your could make a s…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

760 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now