Expression Builder

[aaronmib]

In my database I have a field that tracks the status of my orders. 1 = "Pending"; 2 = "In Progress"; and 3 = "Finished"

When I create a report the value shows up as a 1, 2, or 3.

Is there a way to display "Pending", "In Progress", or "Finished" in the report?

 

[pbaldy]

Typically you would have a table with fields for the number and text. For your report, you would join that table to the data table, enabling you to return the text value for the report.