Cross-tab summary

[qlogic_dev]

Hello.
I'm using simple cross-tab report.

| Date1 | Date2 | Total
-------------------------------------------------
Employee1 | val | val | avg?
-------------------------------------------------
Employee2 | val | val | avg?
-------------------------------------------------
Total |avg?|avg?| avg?


Where val - is amount of second.

How can I convert val to time format (hh:mm:ss) and summarize this value in totals ?

[HighAley]

Hello.

You should set the Summary property of the Cross-Summary to Average to get average value.
Unfortunately it's impossible to use TimeSpan in Average summary.

Thank you.