"Matt" wrote:

> You can put a switch statement like the following in the textbox/table cell
> where you need the "Approved"/"Pending" values displayed:
>
> =Switch(Fields!StatusField.Value "A", "Approved", Fields!StatusField.Value =
> "P", "Pending")
>
> "K. Thomas" wrote:
>
> > What's the best way to display "approved" when a status field is "A",
> > "pending" when a status field is "P", etc? Would the SWITCH statement be
> > best? If so, what is the syntax for this and where do I put it in my report?
> > Any suggestions are welcomed.
> > --