Hello Tek-Tippers
Is it possible to create a formula that would manipulate data among rows. Please see example below:
row recordType Time id date
1 1 6PM 12345 24/06/2011
2 2 8PM 12345 24/06/2011
3 1 6PM 12346 24/06/2011
4 2 8PM 12346 24/06/2011
5 1 6PM 12347 24/06/2011
6 1 8PM 12347 24/06/2011
7 1 8PM 12348 24/06/2011
This is sample of table I am working on.
I need to find out 3 thigs:
1. difference between time where date and id matches
2. ids where record types do not have correspoing rectype (either 1 or 2) e.g. rows 5 & 6
3. ids where there is only 1 record type
I have managed to write this script in VBA Excel. However, I would love to do it on Crystal Reports.
Many Thanks
Is it possible to create a formula that would manipulate data among rows. Please see example below:
row recordType Time id date
1 1 6PM 12345 24/06/2011
2 2 8PM 12345 24/06/2011
3 1 6PM 12346 24/06/2011
4 2 8PM 12346 24/06/2011
5 1 6PM 12347 24/06/2011
6 1 8PM 12347 24/06/2011
7 1 8PM 12348 24/06/2011
This is sample of table I am working on.
I need to find out 3 thigs:
1. difference between time where date and id matches
2. ids where record types do not have correspoing rectype (either 1 or 2) e.g. rows 5 & 6
3. ids where there is only 1 record type
I have managed to write this script in VBA Excel. However, I would love to do it on Crystal Reports.
Many Thanks