I'm trying to get the record that has the latest date. Right now I'm getting two records. How do I get the more current record only, based on the date field?
My next hurdle is how to ge tthe SQL statement into the record selection. I tried this with the Select Expert, but I dont see a maximum in the drop down. DO I have to go into the Show SQL Query to modify it manually?
{Whatever} = Maximum({Whatever}), then that will be passed to the SQL. Even if it isn't, Crystal will sort it for you so that you only see the greatest value.
You don't write the SQL in the record selection. You write the clause, and Crystal generates the SQL at runtime.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.