Page 1 of 1

Cross-tab summary

Posted: Wed Mar 12, 2014 3:12 pm
by 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 ?

Re: Cross-tab summary

Posted: Thu Mar 13, 2014 8:14 am
by 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.