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.

Cross tab in crystal 8.5

Hi

I would like to know how to add column headings for the cols created in the Cross tab report in crystal 8.5. Most of the cross tab reports are come with horizontal headings as the fields in the database. If I add a few cols in the cross tab and want to have my own custom headings, how do I do that?. Your help is really appreciated.

thanks

ArunHi

It is difficult to change column heading, because the value of particular field is becoming the heading.
One solution is you can replace column field with a formula. Formula return appropriate value for each data in the field.

e.g

If {PLACE} = "Bombay" Then
"Mumbai"
Else If {PLACE} = "Maddras" Then
"Chenni"
Else
{PLACE}