Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Query in Designer

Posted on 2011-10-10
Medium Priority
Last Modified: 2012-05-12
I am trying to change a number to reference the name that it represents  in ssrs query designer, i usually use crystal and am not as familiar with the ssrs queries.

1 = "Sponsored"
2 = "discretionary"
3 = " misc"

the field is educationrequest.educationtype  (see attached screenshot) ssrs query ss
Question by:srodgers45
LVL 29

Expert Comment

ID: 36944692

Are you saying that for instance, instead of showing ApprovedBy, you would like to show Approved By.

I just used Approved By as an example but is that what you mean?

Author Comment

ID: 36944729
the "approved by" field shows a number, i would like the number to represent a name instead

1 = "Joe Smtih"   and so on.......
LVL 29

Accepted Solution

sammySeltzer earned 668 total points
ID: 36944837
It seems to me, and I could be wrong that you are getting those numbers from a dropdown listbox.

If so, then show the query you are using because you need to grab name instead of number.

LVL 10

Assisted Solution

itcouple earned 668 total points
ID: 36947074

If you already have a table with ID, Value then you should just create join but I suspect you don't have one but I would still recommend creating one as it is easier to maintain it.

If you want to hard code values then you can do that directly in the SQL using IF/Case. Below is linkSQL Select Statement at the end there is example with IF/Case

If you want to do that in SSRS you can add calculated field in dataset and use IIF or Switch.

Hope that helps
LVL 25

Assisted Solution

TempDBA earned 664 total points
ID: 36947284
I would prefer it doing maintaining a reference table for what those number represents at the back end so that whenever that value changes, it is easy to update without too many hurdle. You can also then join the reference table with the data table you are using and get the result in the form of names itself then fetching it as numbers from backend. At the front end you only need to show what it comes from database..

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

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

Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…

580 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