×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

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!
  • Students Click Here

*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

Using Recap

Using Recap

Using Recap

(OP)
Is it possible to use recap or compute on a subfoot at bottom of a table? I am writing a report that uses recap/subfoot on a sort field (works ok) but then I want to use it on a subfoot for the overall table. Is this possible?


TABLE FILE SQLHOLD
PRINT
COMPUTE COUNTER/I5=1; NOPRINT
EnterpriseName date_col service_level ASA avg_handle_time
ATA callsrd callsh per_hand callsa per_aban  
slcalls_tohalf NOPRINT
calls_answered NOPRINT
answer_wait_time NOPRINT
handle_time NOPRINT
delay_aband_calls_in_queue NOPRINT

BY PeripheralID NOPRINT
ON PeripheralID

RECAP SERP = slcalls_tohalf * 100/calls_answered; NOPRINT
RECAP ASAP = answer_wait_time/callsh; NOPRINT
RECAP AHTP = handle_time/callsh; NOPRINT
RECAP ATAP = delay_aband_calls_in_queue/callsa; NOPRINT
RECAP PRHP = callsh * 100 / (callsh + callsa); NOPRINT
RECAP PRAP = callsa * 100 / (callsh + callsa); NOPRINT

SUBFOOT
"CIC_Total:
<SERP<ASAP<AHTP<ATAP<ST.callsrd<ST.callsh<PRHP<ST.callsa<PRAP"

ON TABLE
RECAP SERPGT = slcalls_tohalf * 100/calls_answered; NOPRINT
SUBFOOT
"CIC_Total:<ST.SERPGT "

ON TABLE SET LINES 999999
ON TABLE SET PAGE-NUM OFF

RE: Using Recap

I think the following will work:

ON TABLE
RECAP SERPGT = slcalls_tohalf * 100/calls_answered;
ON TABLE SUBFOOT
"CIC_Total:<CT.SERPGT "

RE: Using Recap

(OP)
Thanks that has solved the issue.

Is there a limit to the amount of RECAP statements you can have in a focexec file? I get a error "number of RECAP statements has exceeded 7" if i have more than that number.

RE: Using Recap

You can only have six recap commands but you should be able to change your code to

RECAP SERP = slcalls_tohalf * 100/calls_answered; NOPRINT
 ASAP = answer_wait_time/callsh; NOPRINT
 AHTP = handle_time/callsh; NOPRINT
 ATAP = delay_aband_calls_in_queue/callsa; NOPRINT
 PRHP = callsh * 100 / (callsh + callsa); NOPRINT
 PRAP = callsa * 100 / (callsh + callsa); NOPRINT

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