I am currently creating a crystal report in CR9. The report i am creating needs display addition if the equipment has an added date and no removed date. Deletion if the equipment has an archive status of ‘A’.
The problem i am having is with a “transfer”. A transfer is when the equipment is removed from one unit and placed on another.
I am using a history table that records where the equipment has been placed. In the SQL expression this is what i have so far:
(select count(access_equip_fw)
from user_Defined20_fw
group by access_equip_fw
having count(access_equip_fw)>1)
But i need something in the where clause to relate it to each detail line within the crystal report.
