SQLSearcher
asked on
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.
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
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER