Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Translating Field Values

Author  Topic 

nasu
Yak Posting Veteran

50 Posts

Posted - 2010-03-23 : 11:10:08
When creating a report for SQL Server, is there any way to translate field values, i.e. if a field can have values "Pending Approval" and "Passed Verification" is it possible to have them show up as "Pending Verification" and "Approved" instead in my charts?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-03-23 : 12:25:02
yup you can, but for that you require to write expressions in report using IIF()

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -