Hi All,

I am a newbie to Crystal Reports. I am generating a work center report and have some issues with it.

I have an Activity_type and Activity_rate fields grouped by Person responsible for each Plant. I need to get the Activity_type by date.

Logic to do this:
table1.ARBID=table2.OBJID and
table2.OBJID=table3.OBJID and
table1.DATE >= table3.Date

[Imp note: Table1.ARBID is not linked to Table2.OBJID(if i link them, all other data is not getting displayed)].

Also, Logic for Activity_Rate:
Select Table4.TKG001
from table4
where table4.objectno = @form_act_Objno

How can i work with this logic in Crystal reports.

Any kind of advice is appreciated.

Thanks In Advance!!