Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CustomView Producer 2.2

Status
Not open for further replies.

GunShow

IS-IT--Management
Nov 20, 2003
2
US
The company I work for reports on half hour increments. All I've been able to display on a canvis in CustomView is in hour increments. Is there a way to display calls and abandonds in half hour increments?
 
The ApplicHalfHr table will get you that. Covers handled, abandoned, and durations along with a few other fields.

From there, you just need to filter to the half hour method you wish. If they need a report for the last complete half hour, use applichalfhr.half_hr_rel = 1.

 
I'm not familiar with tables in CustomView, are they simple to create?
 
By tables, I was just referring to the acutal data tables in the RealTime database. When working with Producer, if you create an object (Menu button is a box with 12.3 in it), you can right click and get the properties dialog. Under datasource (comes up first anyway), you'll see a drop down box labeled Field/Calc: Click the drop down and scroll to find applichalfhr.num_aband. After selecting that, go to the Data Filter section to set applichalfhr.half_hr_rel = 1.

Let me know how familiar you are with Producer and creating canvases, and I'll know how specific to be. I may even be able to whip up some sample canvases to give you an idea of how the stuff works. Producer's pretty easy to work with, but you have to poke and prod to figure out what really does what.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top