Showing most recent record only... 1

[mmaz]

Hi,

I'm trying to display the id of the most recent db record. I'm using CR 8.0 & ODBC for Remedy.

I've included this condition in the select expert:

{table.myDate} = Maximum({table.myDate})

but I get the following error message:

"This function cannot be used because it must be evaluated later."

Help!!

 

[balves]

In order to use aggregate functions like Maximum you need to create groups. Until Crystal (actually SQL) examines all of the records in the group (such as customer id), it can't know what is the last order date, the largest order in dollars, etc. Brian J. Alves
Terrier Consulting, Inc.
Email: brian.alves@worldnet.att.net
VB / Crystal / SQLServer

 

[mmaz]

I have created groups and still got the same error message. Is there any easy way I can do this? I just want to display the latest record...

Thanks!

 

[balves]

One way to do it is:

Create a formula that does a Maximum(date field) and place it at the appropriate group level. Remove the SELECT condition.

Or: use the Group Selection expert Brian J. Alves
Terrier Consulting, Inc.
Email: brian.alves@worldnet.att.net
VB / Crystal / SQLServer