I have a table which includes fields 'Rate' (varchar) and 'UpdateDt' (datetime). In order to populate a field in a Crystal report, I need to get the Rate associated with the most recent UpdateDt. It's easy in SQL Server, but I am having problems getting the correct result returned in Crystal Reports. I have tried every variation of the MAXIMUM function I can think of, but nothing seems to work. If it helps visualizing the data structure, this code will work in SQL Server (but not in Crystal):
select Rate from dbo.FeeTable
where UpdateDt in(select max(UpdateDt) from dbo.FeeTable where [additional conditionals here])
Any help putting together this formula would be greatly appreciated. Thank you!