question

You can do it SQL using a CASE statement or create a simple lookup table like so: CREATE TABLE dbo.lkpReportVal(ReportValID INT, ReplaceVal CHAR(1)); GO INSERT INTO dbo.lkpReportVal(ReportValID, ReplaceVal) VALUES(1, 'A'),(0,'B') GO Also create a primary key on this table then in your dataset from SQL JOIN to this table and use the column ReplaceVal in your report. But this need testing to see how it performs. Am against burying business logic in visual studio and mantaining and making changes might be cumbersome. Although you can use an expression on the report designer. The fundamental issue to consider also is performance. Do you want a quick data extract and display if so then go with the first option I suggested above.

You can write an expression, under the column Bill write the expression, if your column name is Bill, The expression evaluates if the value is = 1, then it will display the sentence you want inside "" else the second sentence inside "" =IIf(Bill.value = "1", "your sentence when the vale is = 1", "if the value is<>1 Then your sentence")

If you want to be able to change the values in SQL then I would do the change in visual studio. (You should be able to make it display A and B, but the actual value still be 1 and 0.) If you want it just as a read only list, then I would do it in SQL.