Hi all,

   I am brand new to CR (been at it for just days) and using CR XI. Normally I read the FAQ or past forum entries before asking a question, but since I'm not too familiar with the terminology yet, I am not even quite sure how to phrase this question. So if it has already been covered to death - sorry!

Situation: I am extracting a field out of a TrackIt Database called TASKS.PRIORITY. The values for it are "1-Major Incident", "2-High Incident", "3-Medium Incident", etc (they made the values that so it would come out sorted in TracKit pulldown menues - sort of like "AAA Plumbing" in the Yellow Pages").

When I group by PRIORITY and then make a pie chart (or whatever) based on that group, it automatically creates a legend for me and labels the pie chart with the PRIORITY values and totals (I asked for that), which is great. But it looks like this:  "20 3-High Incident", "17 4-Low Incident", etc. Kind of confusing to the reader, who probably doesn't want to see the actual label names. I want it to look like this: "20 High Incident", "17 Low Incident".

Question: Is there a way for me to edit/manipulate those labels? Something like "If PRIORITY.value = '2 - High Incident' then value is 'High Incident'?"

Hope that makes some kind of sense. Thanks!

Could also try