?
Solved

SSRS Status field from text to number

Posted on 2016-10-26
2
Medium Priority
?
53 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 2000 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

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.

Question has a verified solution.

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

Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

764 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