Using Recap

[JoaoPinto]

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&quot;

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

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

 

[kiddpete]

I think the following will work:

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

 

[JoaoPinto]

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 &quot;number of RECAP statements has exceeded 7&quot; if i have more than that number.

 

[gizzy17]

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