CMS Supervisor V12 Agent Group Interval Report

[Tranton]

Hi Folks, Long time reader, first time poster.

I'm trying to design a historical Agent group interval report, but i'm not sure if this is possible. I have created the basic group report and have intervals fields but the report does not like the STARTTIME query.

When trying to run the report i get the error - "data - Column not found in any table in the query". I have checked the query but it does contain the data function and my new GROUP By STARTTIME query.

Can anyone advise me if i'm chasing the impossible, or if it is possible, where i might be going wrong.

Cheers,
Tranton

 

[BIS]

You probably need to put the data function in single quotes

'data'

 

[Tranton]

Cheers Bis, i'll give it a try