current date check

[howhowhow]

i'm trying to print out a report from a db that has the most recent DATE!

what it returns now is all the dates but i just want the lastest one, i.e. it show's stuff on 4/25 and 4/24, etc..
and all i want is the stuff on 4/25..

i was trying
to do something like:

if date({Activity_Log.Create Date}) = {@date}
then {Activity_Log.Create Date}

@date is just the most recent entry and
({SFTI:_Activity_Log.Create Date}) is what is being
pulled out of the db..

i get a error saying Formula can not be used because
it must be evaluated later, and i tried the executeafter
function as well.

is there a easlier way to just check for the most current
date and print whatever is on that date or is this the way to do it?

thanks

 

[synapsevampire]

Either use a Top N report, or you can limit rows to days date (or go against a parameter) by using something like the following the record selection formula:

{table.date} = currentdate

-k

 

[kenhamady]

This is called group selection. Add the following in your group selection formula:

{Activity_Log.Create Date} =
Maximum ( {Activity_Log.Create Date} )

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com