crosstab and time values

Hello! I'm new to Reporting Services and cross-tab reporting in
general. I
need to create a report that has days (dynamic cols) and a wait time
col (static) and across the top and categories down the left.
Visually I need to see:
Day 1 Day 2 Total
Wait Time Col2 | Wait Time Col2 | Wait Time Col2
______________________________________________________
Cat1 00:05:00 10 | 00:10:00 5 | 00:15:00
15
Cat2 00:07:00 13 | 00:13:00 8 | 00:20:00
21
______________________________________________________
Total 00:13:00 23 | 00:23:00 13
Is it possible to apply an aggregate function to a time value? If yes,
how?
Can someone point me in the right direction?
Thanks in advance.I forgot to say: i=B4m using reporting services 2000 SP2. I really nedd
help!|||I forgot to say - I=B4m using reporting services 2000 SP2. I really need
help!|||You need to use a matrix to achieve this, instead of a table.
Then have categories as row groups and days as column groups.
Add subtotals to both groups to have the totals.
Add a static column to the data field to have your Col2s.
Matrixes can be a bit confusing at first, but this is definately the control
you need to use.
Kaisa M. Lindahl Lervik
"kaustika" <rosa.cunha@.gmail.com> wrote in message
news:1158867347.399372.184490@.i42g2000cwa.googlegroups.com...
> Hello! I'm new to Reporting Services and cross-tab reporting in
> general. I
> need to create a report that has days (dynamic cols) and a wait time
> col (static) and across the top and categories down the left.
> Visually I need to see:
> Day 1 Day 2 Total
> Wait Time Col2 | Wait Time Col2 | Wait Time Col2
> ______________________________________________________
> Cat1 00:05:00 10 | 00:10:00 5 | 00:15:00
> 15
> Cat2 00:07:00 13 | 00:13:00 8 | 00:20:00
> 21
> ______________________________________________________
> Total 00:13:00 23 | 00:23:00 13
> Is it possible to apply an aggregate function to a time value? If yes,
> how?
> Can someone point me in the right direction?
> Thanks in advance.
>|||I think I didn=B4t explain myself very well.
My doubts are: IN A CROSSTAB static column: (i) is it possible to put
time values? (ii) The sql query must return what? A double, an integer
or a datetime? (iii) And how to apply an aggregate function (SUM, AVG,
MAX, MIN) to a time value?
Thanks in advance.