SWITCH statement

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

K. Thomas - 29 Jun 2006 20:57 GMT

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.

Signature

K. Thomas

Reply to this Message

Matt - 30 Jun 2006 02:25 GMT

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")

> 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.

Reply to this Message

K. Thomas - 30 Jun 2006 20:58 GMT

It worked!! Thanks Matt!

Signature

K. Thomas

> You can put a switch statement like the following in the textbox/table cell
> where you need the "Approved"/"Pending" values displayed:
[quoted text clipped - 6 lines]
> > best? If so, what is the syntax for this and where do I put it in my report?
> > Any suggestions are welcomed.

Reply to this Message