Afternoon all,

I currently have the below fields in my Crystal Report (crosstab). What I am trying to do is set the criteria so that only the very last date/time combination is shown from last month.

Date&Time (Row)
ComputerName (Column)
DiskID (Column)
Avg of DiskSizeMB (Summarized)
Avf of DiskUsedPct (Summarized)

What I thought would work is the below formula but unfortunately this doesn't work due to an error ("This function cannot be used because it must be evaluated later.").  Is there another way to achieve this??

{Table1.DATE_TIME} in LastFullMonth and
{Table1.DATE_TIME} = Maximum({Table1.DATE_TIME})

Hi Lockwelle,

Unfortunately the data I am using is collected every 15 minutes so I have to get the last Date and also the last Time of the Date/Time field so must be summarised.

I may have found the solution with the following link: I am just testing to make sure it all works...

http://www.maximumimpactsolutions.co.uk/blog/comments.asp?bd=129