Needing help pull a certain record... 1

[NewB2007]

I need some assistance on how to pull a record from a database through crystal XI. I need to pull the record that has the most current date. So basically I need the record with the MAXIMUM(date) but I'm pretty sure that MAXIMUM() is not the correct function to use here. Any guidance would be much appreciated.

Thanks

 

[linHorizon]

Please elaborate a little more of what you are trying to do.

Are you trying to get a range of data or just one row of date with the latest date?

Lin

 

[NewB2007]

I'm just try to get the record with the most current date.

 

[lbass]

I'm guessing you don't want your report to consist of one row of data, and that you really want the most recent date per some group. Go to report->selection formula->GROUP and enter:

{table.date} = maximum({table.date},{table.groupfield})

Replace the fields with your actual field names.

-LB