Hi,

I want to display the Item count from 2 tables in Crystal

Example:

User Name No of Items Processed User Recorded Differ
aaaaaaaaa 99 97 2
bbbbbbbbb 85 89 -4
cccccccccccc 102 102 0

The count of No of items processed and User Recorded comes from 2 different table, the comman key is user id

Could you please let me know how to go about it

Just a suggestion:


select a.name,count(b.xxxx) as x,count(c.yyyy) as y,compute(x - y) as z from...


Don't know whether Crystal will take it, but qptool sure handles it (except for the compute part, that is!)

Regards,
Nico