woud someone, anyone point out whatever dumb mistake I have made that causes

ON GWA_AGENCY_TITLE RECAP
AT_A_AGENCY_TITLE/A200 = '     Total, ' | BUREAU_TITLE | ', ' | GWA_AGENCY_TITLE ;
AT_A_OPENING_BAL/A30 = IF OPENING_BAL EQ 0 THEN '----------' ELSE FTOA(OPENING_BAL, '(D17.2)', 'A30'); 
AT_A_APPROP/A30      = IF APPROP EQ 0 THEN '----------' ELSE FTOA(APPROP, '(D17.2)', 'A30');
AT_A_TRANSFER/A30    = IF TRANSFER EQ 0 THEN '----------' ELSE FTOA(TRANSFER, '(D17.2)', 'A30');
AT_A_OUTLAYS/A30     = IF OUTLAYS EQ 0 THEN '----------' ELSE FTOA(OUTLAYS, '(D17.2)', 'A30');
AT_A_BALANCE_WITHDRAWN/A30 = IF BALANCE_WITHDRAWN EQ 0 THEN '----------' ELSE FTOA(BALANCE_WITHDRAWN, '(D17.2)', 'A30');
AT_A_CLOSING_BAL/A30 = IF CLOSING_BAL EQ 0 THEN '----------' ELSE FTOA(CLOSING_BAL, '(D17.2)', 'A30');
ON GWA_AGENCY_TITLE SUBFOOT WITHIN MULTILINES
"<AT_A_AGENCY_TITLE <+0> <+0> <+0> <+0> <AT_A_OPENING_BAL<AT_A_APPROP<AT_A_TRANSFER<AT_A_OUTLAYS<AT_A_BALANCE_WITHDRAWN<AT_A_CLOSING_BAL"
" "

to generate this result:

** AT_A_AGENCY_TITLE Total, Procurement, Department Of Defense
** AT_A_OPENING_BAL 10,041,756,533.32
** AT_A_APPROP 7,502,489,000.00
** AT_A_TRANSFER 49,614,000.00
** AT_A_OUTLAYS 7,113,749,460.65
** AT_A_BALANCE_WITHDRAWN 31,415,214.28
** AT_A_CLOSING_BAL 10,448,694,858.39
Total, Procurement, Department Of Defense 10,041,756,533.32 7,502,489,000.00 49,614,000.00 7,113,749,460.65 31,415,214.28 10,448,694,858.39

And, no, I cannot replicate the result in car, in fact the fex I wrote using car works perfectly with the recap lines NOT appearing along with the subfoot.

I am using 7.6.11 on windows for all WebFOCUS environments.

This message has been edited. Last edited by: Kerry,

What happens if you remove the WITHIN MULTILINES?

The recap and subfoot do not appear in sections with only one row of data, as expected

Robert, please post what you're expecting to see, because I can't see any dumb mistakes.

And, sometimes it helps if the output is also placed within

[code]

[/code]

tags - easier to line up columns...

You folks are gonna LOVE this one :-)

This report has a total of 15 sort fields, 9 of which have been identified as requiring a conditional display of information for 9 of them in SUBHEADS, IE

ON fieldname1 SUBHEAD
“<fieldname2”
WHEN expression

Since the contents of multiple fields were required to determine whetherthe SUBHEAD should be displayed, a DEFINE field was created to evaluate these fields and produce a ‘Y’ or ‘N’ value for use in the WHEN statement.
Use of all 9 conditional statements is resulting in an error in the display of RECAP information in that

ON GWA_AGENCY_TITLE RECAP
AT_A_AGENCY_TITLE/A200 = '     Total, ' | BUREAU_TITLE | ', ' | GWA_AGENCY_TITLE ;
AT_A_OPENING_BAL/A30 = IF OPENING_BAL EQ 0 THEN '----------' ELSE FTOA(OPENING_BAL, '(D17.2)', 'A30'); 
AT_A_APPROP/A30      = IF APPROP EQ 0 THEN '----------' ELSE FTOA(APPROP, '(D17.2)', 'A30');
AT_A_TRANSFER/A30    = IF TRANSFER EQ 0 THEN '----------' ELSE FTOA(TRANSFER, '(D17.2)', 'A30');
AT_A_OUTLAYS/A30     = IF OUTLAYS EQ 0 THEN '----------' ELSE FTOA(OUTLAYS, '(D17.2)', 'A30');
AT_A_BALANCE_WITHDRAWN/A30 = IF BALANCE_WITHDRAWN EQ 0 THEN '----------' ELSE FTOA(BALANCE_WITHDRAWN, '(D17.2)', 'A30');
AT_A_CLOSING_BAL/A30 = IF CLOSING_BAL EQ 0 THEN '----------' ELSE FTOA(CLOSING_BAL, '(D17.2)', 'A30');
ON GWA_AGENCY_TITLE SUBFOOT WITHIN MULTILINES
"<AT_A_AGENCY_TITLE <+0> <+0> <+0> <+0> <AT_A_OPENING_BAL<AT_A_APPROP<AT_A_TRANSFER<AT_A_OUTLAYS<AT_A_BALANCE_WITHDRAWN<AT_A_CLOSING_BAL"
" "

to generate this result:

** AT_A_AGENCY_TITLE Total, Procurement, Department Of Defense
** AT_A_OPENING_BAL 10,041,756,533.32
** AT_A_APPROP 7,502,489,000.00
** AT_A_TRANSFER 49,614,000.00
** AT_A_OUTLAYS 7,113,749,460.65
** AT_A_BALANCE_WITHDRAWN 31,415,214.28
** AT_A_CLOSING_BAL 10,448,694,858.39
Total, Procurement, Department Of Defense 10,041,756,533.32 7,502,489,000.00 49,614,000.00 7,113,749,460.65 31,415,214.28 10,448,694,858.39

In other words, both the RECAP and the SUBFOOT lines are displaying on the report.
The fact that it is indeed the SUBHEAD’s causing the issue was determined when all WHEN statements were commented out. The report ran, and the RECAP values did not display. The WHEN statements were added back in one at a time, and when the eighth WHEN was applied, the error occurred. I experimented with various combinations of the 9 WHEN statements and any combination of 7 work correctly. Inclusion of the eighth WHEN statement triggers the error.

My client is opening a case on this. Hopefully when we get a resolution, this will be updated again.

and now for the final chapter in this saga. The client is in the process of upgrading to 7.7.2, The problem no longer occurs in this release.

This Issue can be closed