MochaLatte
Technical User
Hello, I am an active Tek-tip site user requesting help. This time around, I am trying to meet a deadline( I have researched for hours). I am willing to send you a e-card in the amount $40 from Amazon.com, if I star your post. I will be very very grateful!!!!!
On Crystal reports:
GROUP 4 Header: Group By Hotel Room Number
Room Number 30: Column A ( 04/01/2014 hh:mm) Column B (04/03/2014 hh:mm)
Room Number 30: Column A (04/02/2014 hh:mm)
GROUP 4 Footer: Average hours (difference (Minimum(Column A - Column B) = difference in hours using the mimimum datetime in column A
GROUP 3 Header : Floor Number
Room Number 30
Room Number 40
Room Number 50
GROUP 2 Header : Hotel Location
GROUP 1 Header: Hotel by Region s
Carry the average to each group footer However, only group #4 has two datetimes (choose the minimum on column A) .
Thanks!!!!!!!
On Crystal reports:
GROUP 4 Header: Group By Hotel Room Number
Room Number 30: Column A ( 04/01/2014 hh:mm) Column B (04/03/2014 hh:mm)
Room Number 30: Column A (04/02/2014 hh:mm)
Column B (04/03/2014 hh:mm)GROUP 4 Footer: Average hours (difference (Minimum(Column A - Column B) = difference in hours using the mimimum datetime in column A
GROUP 3 Header : Floor Number
Room Number 30
Room Number 40
Room Number 50
GROUP 2 Header : Hotel Location
GROUP 1 Header: Hotel by Region s
Carry the average to each group footer However, only group #4 has two datetimes (choose the minimum on column A) .
Thanks!!!!!!!