Web Development



SQL Expressions (using where clause)

By kmyck ·
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.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -


by kmyck In reply to SQL Expressions (using wh ...

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.


Related Discussions

Related Forums