Web Development

Ask something
Question Locked

SQL Expressions (using where clause)

0 helpful
2 replies

by kmyck

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

2 replies

by kmyck

Oh yeah, i forgot to mention that i am using the sql expression to cound how many times the equipment id shows up in the history table. Because the id will only show up multiple times if it has been removed from a unit and attached to another unit.

thanks,

This discussion is closed to new replies.