Idle Codes line up

[JOOJOO00]

Hi all,

Issue:

I have to make a report with Idle codes for call center agents. The management wants to see what and when the agents are using these Aspect codes. For example: code 15= 15 min. break.
The user names and codes (in Excel format) has to be static. "Usernames in horizontal and the different codes definition, its like a summary, verticaly"
Example:
Group - user - ext - code 15 - duration - code 99 .. etc
2 - Jim - 123 - 2 - 00:31:16 - 1 .. etc
2 - John - 124 - 2 - 00:29:45 - 0 .. etc

There is an standard report for it with the formula:

WhilePrintingRecords;
StringVar abbr;
if {@Abbreviation}=" " then abbr:=": "
else
abbr:=": ("+{@Abbreviation}+&quot ";
NumToText({Reason Code Events.Reason Code Sub Event Type})+abbr+{@Reason Code Description};

This standard report can not be implemented in to a excel chart.
So thats what they (management) want, to make a new report so it implemented in to a chart.

Is there anyone who is willing to help so that the "code X" is beeing displayed as a static value in the new report. I do not know how to get this.

Many thanx in advance

- Ronin71 - R>F>> SNAP!