You can't drive the text of the label as far as I know, however you place multiple labels with the different text and then hide them based on a variable on the card using "Control Logic" from the Control menu.
- You pick "Hide"
- Then select a variable "ECR_Status"
- Select "not equal" a number.
Another idea is to create a "List" of your status' and select the data type "Text with Alias". Behind the scenes it's a number but displays what ever text you specify as the alias for that number in the data card. You have to use a dropdown box/list on the card and then pick the list.
You may be able to achieve your desired goal using an 'Input Formula' for the control, though I haven't used that feature myself. Check out the help file for more details.
Yeah, that would work as well.
Syntax we've used on a text field linked to Plant Code:
%Plant Name(HornLake = 1, Middleton = 2, Cincinnati = 3, Canada = 4, Walnut = 5)%
You have two variable fields, in our case it was "Plant Name" and "Plant Code". The user selected a dropdown with the plant name the input formula entered teh number int eh other text field.
We swtich to the alias list when it was introduced in 2011 so it was just one field.