How do I show internal values of choice fields on a report?

[epuchals]

I suspect I'll have one of those forehead-slapping moments when someone responds to this because it seems like it ought to be obvious. I have a choice field set up where the internal values of the choices are integer values from zero to 3 but the list labels are text strings that mean something to people selecting them. Something like this:

    0 = Not provided

    1 = Low

    2 = Medium

    3 = High

Most of the time when I show the field on a report, I want to use the label. But in a couple instances I want to show the integer value instead. When I export the records as XML I see the internal values so I know they're in there somewhere.

As I said, I expect there must be a simple solution to this but I'm not seeing anything obvious. We're running Eureka going to Fuji in a couple weeks.

Thanks in advance,

  Eric...

[Pradeep Sharma]

Hi Eric,

OOB it will show the label when you run the reports. However you might have to create a extra field and the push the values as per the label value of the selected field.

Please let me know if you have any questions.

[epuchals]

Pradeep:

Thanks for the reply. I'm a little surprised that there's no easy solution for this--it seems like a pretty basic capability. I guess I can do it with a business rule as you suggest but it seems redundant to have to store the same information in two different formats.

Thanks for the help,

  Eric...