CMS Custom Report - AVG POS STAFFED

[ArturP]

Hi,

I was trying to do report on which will be presented AVG_POS_STAFF by days, but CMS return error. Do you know how should I define such field and row serch to get righ results.

Thanks

 

[Definity]

There is no special row search required to display AVG_POS_STAFF, I have it working in my CMS & the report works fine. The field is defined as a field name in "select" & table as hagent(see below)
What error do you get when you run the report?

-------------------
Select: AVG_POS_STAFF
Table for calculations: hsplit
-------------------

 

[ArturP]

I have used calculation like this:

"select hsplit.I_STAFFTIME/(hsplit.INTRVL*60) from hsplit where ROW_DATE = 38640 and SPLIT = 1 and ACD = 1 order by ROW_DATE"

and the CMS return

"Informix error: -309"

What do you think about?

 

[Definity]

The Row search as I have defined is below:-

ROW_DATE = $i_date and STARTTIME = $i_time and SPLIT = $i_domain and ACD = $acd

Means I am taking the date, start_time & split from the user on the CMS & using the same to run the query.

Also I hope you're using "custom reports" -> Screen painter under CMS to design this report & the query that you've provided is the query as you get in screen painter when you test the design of the report.

 

[Definity]

The query as shown on the screen painter is as below:-
--------------
select hsplit.I_STAFFTIME/(hsplit.INTRVL*60) from hsplit where ROW_DATE = 38641 and STARTTIME = 0and SPLIT = 41 and ACD = 1 order by STARTTIME
--------------

BTW, Did you try the queey on the dsplit rather than hsplit when you're supplying just the date & not time..

 

[ArturP]

The error only appear when I use "order by ROW_DATE", if I don't use this, the report works fine.
I was tried using dsplit instead hsplit but it doesn't change anythink in results.

 

[Definity]

You're right, Even I get the same error when I try it with order by ROW_DATE..
Let me do a research for why it happens & post update.

 

[langl3y]

Hello,

The error could be caused if the report runs over a single date. Which would mean the report can't sort the information into date as the dates are all the same.

Check the input field to ensure multiple days are checked.

Cheers
Langl3y