SSRS Status field from text to number

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
SQLSearcherAsked:
Who is Participating?
 
Pawan KumarConnect With a Mentor Database ExpertCommented:
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
 
SQLSearcherAuthor Commented:
Thank you for your help.
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.

All Courses

From novice to tech pro — start learning today.