Report - Oops

[MadAccess]

I think I accidentally modified a custom report in Terminal Emulator. Now when I run it there are no results. I have a call into Avaya but there CSI group is sloooow. Maybe somebody can look at this and spot an obvious error, or can I pull the original from a recent backup?

Here are the Test results:

"No errors found"

Select
select '@', '|', SPLIT , '|', sum(CALLS
OFFERED) , '|', sum(ANSTIME)/sum(ACDCALL
S) , '|', sum(ACDTIME+ACWTIME-ACWINTIME-
ACWOUTTIME)/sum(ACDCALLS) , '|', 100*(su
m(ACCEPTABLE)/sum(CALLSOFFERED)) , '|',
sum(I_STAFFTIME)/sum(INTRVL*60) , '|', s
um(ACDCALLS) , '|' from hsplit where ROW
_DATE = 39820 and STARTTIME = 10 and ACD
= 1 group by 3 order by SPLIT

 

[inerguard]

what error does it display when you run the report in test mode.


[Started on Version 3 software 15 years a go]

 

[MadAccess]

Thanks for the reply!
I dont get an error. And I found I have to enter a correct Interval, such as 15 or 30, at one of the input prompts. The report runs but the first column displays "@" for each row (I dont think it used to), and the numbers dont look correct. For example a skill that normally takes 20 calls may show just 1 or two depending on what i put in for the interval. However the automated system that runs this report on a regular basis is now blank other than the headers. Nothing changed on the automated system which makes me think I accidentally changed something.