I am currently trying to create a report, which connects to a Database using ODBC. This database is a monitoring application which spits out performance information every 5 minutes.

What I am aiming to achieve, through Crystal, is one record a day and for that record to be a average and a [second] maximum figure.

I am using Crystal Reports 2008 but can't seem to find a way of limiting the output to 1 record per day, for each system.

Any help appreciated.

thank you for your reply. Apologies, I am very new to Crystal Report, how do I group on the date field and set it to use 'per day'? I am currently using the Report Wizard, until I am of a level to stop, and there is a group option but it only allows you to select ascending or descending?

Hi again - that still seems to give me loads of entries for the same day. I was however just having a play and I tried creating a Cross-Tab report (using the wizard) with the following:

Columns: Computer Name & Disk ID
Rows: Date & Time (for each day.)
Summary Fields: Disk used % (Avg) & Disk used % (Max)

This gives me the output I want, with the dates down the left hand side, computer name/Disk ID on the top and the relevant figures in a table.

The problem this way has, though, is it doesn't stipulate which figure is which... So I'd be hoping for a label to say which is Avg and which is Max. More annoyingly there is a lot of 'Total' columns and rows which I just can't get rid of...

Any ideas??

Hello - I have tried all of these steps but I am still getting numerous entries per day (rather than just 1 per day); I have double checked everything and it is definitely all marked as per your instructions.

I didn't, no. I some how read your instructions about ten times and completely missed that! trying it now!