Skip to Content
0
May 23, 2014 at 03:55 PM

How to implement a subquery in CR2011 using native formulae?

209 Views

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