Calculate time between values in crosstab 1

[ewithoud]

I need to create a crosstab that calculates the time between completion of tasks in a crosstab.

see example below:

task task 1 task2 task3 task4
date completed 26-May 15-Jun 25-Jun 20-Jul
time between tasks 20 10 25

How do I calculate the time between tasks in Crystal Report V11?

 

[Madawc]

I don't think you can do this as a crosstab, because your figures involve more than one detail record. It does depend on the raw data, which you have not described.

You can get the same effect defining the totals yourself. If you're not already familiar with Crystal's automated totals, see FAQ767-6524.

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP