• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 74
  • Last Modified:

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
Select '2' as status,'Selected' as status_name
Select '3' as status,'Count' as status_name
Select '4' as status,'Counted' as status_name
Select '5' as status,'Completed' as status_name
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?


1 Solution
Pawan KumarDatabase 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.
SQLSearcherAuthor Commented:
Thank you for your help.
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.

Join & Write a Comment

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.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now