Displaying Custom text based on grid value - Alpha Anywhere

[tcbarker4]

I have a database that contains a status code. I would like to display in my grid a user-friendly status rather than the status code. So if the code in the DB is 1, I'd like to display Open in the grid rather than 1. If the code is 2, I'd like to display Closed in the grid rather than 2. I currently have the status code defined in the grid as a Label. I'm not sure how to condition the Status that is displayed based on the status code coming from the database.

Thanks,

Tim Barker

[Ted Giles]

I think you need to ask that in the appropriate place.
If the grid in in a Desk top, try the desktop area, if it's in a web app, try the web side.

[Jay Talbott]

Why don't you create a "calculated" field in the grid query based on the value from the database. You can use a case statement and give the field an alias, then display that aliased field on the grid.

Hope that helps.
Jay

[WebDesignShop]

What Jay suggested is good. Another way is to modify your query on the database side of things so that it returns what you want without having to do anything in Alpha. Typically this is done by creating a "view".