Problem with 'Maximum' function

[randomname]

Hi

I am fairly new to Crystal so please bear with me !

I have a report where I have an item library (PCMS_ITEM_DATA.ITEM_ID). Each item in this library has several versions:{PCMS_ITEM_DATA.FILE_VERSION}. I want to show each item once, and that is the highest version of that item

I am trying to use

Maximum ({PCMS_ITEM_DATA.FILE_VERSION},{PCMS_ITEM_DATA.ITEM_ID} )

This errors by saying there must be a group that matches this field.

I am stuck !

What more info can I give ???

 

[mbarron]

You need to group on the {PCMS_ITEM_DATA.ITEM_ID} field in order to use your formula.



Mike

 

[randomname]

Mike, you are a star !!!

thanks v much