×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

CMS Supervisor RONA Report HELP

CMS Supervisor RONA Report HELP

CMS Supervisor RONA Report HELP

(OP)
We have added RONA into our call center and i want to have the number of RONA calls listed per agent in historical split\skill, summary daily

I know that i need to go into the report in design mode and add noansredir but how do i add it.  I always get errors when I try. Thanks  

RE: CMS Supervisor RONA Report HELP

(OP)
yeah I am waitng for them to give me permissions to save exception

what I am looking for in my above question is how to do in in design veiw of the report i posted?

RE: CMS Supervisor RONA Report HELP

We have a custom report built that provides a report for multiple agents, multiple days, multiple intervals. It will only report if the agent had RONAs.

The data is from the hagent table.

The Inputs (all with multi-value selected) are:
Agent
Date
Time (point in time)

Query Items are:
ROW_DATE
STARTTIME
"-"
STARTTIME+INTRVL
LOGID
""
LOGID
NOANSREDIR

The Where statement is:
ACD=$acd and  LOGID = [Agents:] and  ROW_DATE = [Dates:] and  STARTTIME = [Times:] AND NOANSREDIR > 0
   

- Stinney

Favorite all too common vendor responses: "We've never seen this issue before." AND "No one's ever wanted to use it like that before."

RE: CMS Supervisor RONA Report HELP

(OP)
PLease be more specific I am still receiving when you add this inof which query are you using data or totals?  please help I just want to use the above report with the RONA info I dont want anything else

RE: CMS Supervisor RONA Report HELP

Edit your queries:

data: add NOANSREDIR and save

totals: add NOANSRDIR, Highligh NOANSRDIR in the Query Items: window, click on Edit, change it to sum(NOANSREDIR) and save

Click on the table to highligh it. Goto Format|Table

Click on the Data Tab

Add NOANSREDIR to the Data on Table window

Save and Run

 

- Stinney

Favorite all too common vendor responses: "We've never seen this issue before." AND "No one's ever wanted to use it like that before."

RE: CMS Supervisor RONA Report HELP

(OP)
Ok got it thanks a bunch

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close