Can anyone please tell me what the following means:

The column must be in the Group By List?

You may find the answer here http://www.telesavers.com/User%20Guides/CC/CMS%20Report%20Design%20Guide%2002-06.pdf

You have a query that is summarising data e.g. sum(i_stafftime) but you have not used a group by clause at the bottom to show what to sum by.

For example:
Select dagent.row_Date, dagent.split, sum(dagent.I_stafftime) as Logon
where dagent.split = 1 or dagent.split = 2
Group by dagent.row_date, dagent.split

Hi Doreen

CCT conduct Avaya CMS Supervisor Training courses at our offices here in Bristol. I'll ask our trainer and see if she is able to help.

Craig Neilson
CCT
www.cctonline.co.uk