Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Needing help pull a certain record... 1

Status
Not open for further replies.

NewB2007

Technical User
Feb 25, 2008
42
US
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
 
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
 
I'm just try to get the record with the most current date.
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top