Solved

SSRS Status field from text to number

Posted on 2016-10-26
2
36 Views
Last Modified: 2016-10-26
Hello Experts Exchange
I have a SSRS report that has a parameter called status, I want to give the user a status_name and convert it into a number as the status field is a number in the data.

Here is my script for the parameter.
Select '1' as status,'New' as status_name
union
Select '2' as status,'Selected' as status_name
union
Select '3' as status,'Count' as status_name
union
Select '4' as status,'Counted' as status_name
union
Select '5' as status,'Completed' as status_name
union
Select '6' as status,'Deleted' as status_name

Open in new window


I want to give the user the ability to select the status_name but I want to get the number in a parameter.

So for example the user picks New, and Deleted.  I want a parameter with (1,6) in it.

How do I do this?

Regards

SQLSearcher
0
Comment
Question by:SQLSearcher
2 Comments
 
LVL 28

Accepted Solution

by:
Pawan Kumar earned 500 total points
ID: 41860210
Yes you can do that ..

For parameter display name or label as status_name and value as status.

From the Value field drop-down, select status.
From the Label field drop-down, select status_name .

Your parameter should be of type multi valued typed.
0
 

Author Closing Comment

by:SQLSearcher
ID: 41860359
Thank you for your help.
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

810 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