Solved

SSRS Status field from text to number

Posted on 2016-10-26
2
47 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 29

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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

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 …
Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…

724 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