Hi All, If you look at the following SQL query, we want to have EquipRate based on Current Date for a EquipCode. How can I achieve the same result in Crystal reports designer using native formulas and functions. Thanks for your help. It will help us in not creating a view at the database side.
Select a.EquipRate
From a
Where a.EffectiveDate =
(select Maximum (a.EffectiveDate,b.EquipCode)
from a, b
where a.id=b.id)
Thanks