I'm trying to create a designer report in CMS Supervisor 13.1
Is it possible to have an agent history report that combines dagent and haglog databases? I have 3 queries in the report. 2 are working, but I can't get the 3rd one to work so it shows the data on the report. The goal is to create a modified report of the Group Attendance Daily report. I want to add Login and Logout times to the report and am having no luck. Any help would be appreciated.

Hi Doreen,

Yeh it is possible to combine queries from these two tables into a report. Do you get any sort of error message when you try to run or does it just not display any data?

Cheers

John

I don't get any errors, just can't see the data on the report. I think my Select and Where may be wrong. I'm trying to figure this CMS stuff out by myself. I've re-done the report for what seems like the millionth. Here is what I have for Select and Where

SELECT: dagent.LOGID
sum(dagent.TI_STAFFTIME)
dagent.sum(TOTAL_I_ACDTIME)
sum(dagent.I_RINGTIME)
dagent.sum(EXT_IN_TIME)
dagent.sum(EXT_OUT_TIME)
sum(dagent.TI_AVAILTIME)
sum(dagent.TI_AUXTIME)
dagent.sum(TOTAL_ACDCALLS)
dagent.sum(EXT_CALL_IN)
dagent.sum(EXT_CALL_OUT)
sum(dagent.TI_AUXTIME2)
sum(haglog.LOGIN)
sum(haglog.LOGOUT)
WHERE
dagent.ROW_DATE = [Date:] AND dagent.ACD=$acd AND dagent.LOGID=haglog.LOGID GROUP BY dagent.LOGID

HI is there any update on the multiple tables. I have designed a vdn and Agent table, but the problem is i get all double numbers on the report. i Mean duplicates. I then have to remove the duplicate on excel and the number tallies..

if some one has designed one with multiple table pls can you upload it .