I used ON TABLE COLUMN-TOTAL AS 'TOTAL' to get total for my columns. When the output is over 900 lines, total on each column shows in number instead of formula.

Is there a limit on number of lines for COLUMN-TOTAL?

This message has been edited. Last edited by: FP Mod Chuck,

Hi William

Welcome to Focal Point!! It is a great place to be answers to your questions.

I am not aware of any limitation like that. I created a procedure that used XLSX FORMULA as output that had 4000 lines of output and the formula was displayed.

Post your entire code for us to see to help debug what may be happening.

Here is my code for the report.

TABLE FILE FEDGRNTD1

SUM D_PLANNED_FUND_AMOUNT/P16BC AS 'FEDERAL,BUDGET,LINE,AMOUNT' NOPRINT

COMPUTE TOT_BUDGT_AMT/P15BC=0.00; AS 'TOTAL,BUDGET,LINE,AMOUNT'

FED_BUDGT_AMT AS 'FEDERAL,BUDGET,LINE,AMOUNT'

COMPUTE LOCAL_BUDGT_AMT/P15BC=TOT_BUDGT_AMT - FED_BUDGT_AMT; AS 'LOCAL,BUDGET,LINE,AMOUNT,(E)'

COMPUTE PCT_FTA/P3.2%=FED_BUDGT_AMT/TOT_BUDGT_AMT; AS 'FTA,PCT'

COMPUTE PCT_LCL/P3.2%=LOCAL_BUDGT_AMT/TOT_BUDGT_AMT; AS 'LCL,PCT'

REQAMT_PRIOR3/P16BC AS '(1),NET EXPENDITURES,PREVIOUSLY,REPORTED'

COMPUTE CURRENT/P16BC = REQAMT_ALL2 - REQAMT_PRIOR3; AS 'TOTAL,EXPENDITURES,THIS PERIOD,(A)'

COMPUTE INC_CREDIT/P16BC = 0.00; AS 'INC,CREDIT,(B)'

COMPUTE CURRTOTAL/P16BC = CURRENT + INC_CREDIT; AS '(2),NET,EXPENDITURES,THIS PERIOD,(A - B)'

COMPUTE NET_OUTLAYS/P15BC=REQAMT_PRIOR3 + CURRTOTAL; AS '(1 + 2),NET EXPENDITURES,CUMULATIVE'

COMPUTE LOCAL_AMT/P16BC = REQAMT_ALL2 - FED_ALL; AS '(3),RECIPIENT,SHARE,OF EXPENDITURES'

FED_ALL/P16BC AS '(4),FED SHARE,OF EXPENDITURES'

COMPUTE FILLER2/P16BC = CMT_FUND2A - LOCAL_AMT; NOPRINT

COMPUTE FILLER3/P16BC = CMT_FUND1 - FED_ALL; NOPRINT

COMPUTE FILLER1/P16BC = FILLER2 + FILLER3; AS 'TOTAL,UNLIQUID.,OBLIG.,(C + D)'

COMPUTE FILLER2/P16BC = CMT_FUND2A - LOCAL_AMT; AS '(7 - 3),LESS,RECIPIENT,UNLIQUID.,OBLIG. - (C)'

COMPUTE FILLER3/P16BC = CMT_FUND1 - FED_ALL; AS '(5 - 4),FED,SHARE,UNLIQUID.,OBLIG. - (D)'

CMT_FUND1/P16BC AS '(5),FEDERAL,COMMITTED'

COMPUTE FILLER4/P16BC = FED_BUDGT_AMT + 0; AS '(6),CUMU.,FED,FUNDS,AUTH'

COMPUTE FILLER5/P16BC = FILLER4 - CMT_FUND1; AS '(6 - 5),UNOBLIG,BAL.,FED,FUNDS'

CMT_FUND2A/P16BC AS '(7),RECIPIENT,COMMITTED'

COMPUTE LOCAL_SHARE/P16BC=LOCAL_BUDGT_AMT - LOCAL_AMT - FILLER2; AS 'REMAINING,RECIPIENT,SHARE,TO BE,PROVIDED,( E- (3 + C))'

FED_ALL_RECD1/P16BC AS 'TOTAL,FED RECEIPTS,THIS PERIOD'

FED_ALL_RECD/P16BC AS 'TOTAL,FED RECEIPTS,CUMULATIVE'


COMPUTE ALL_TOTAL/P16BC=TOT_BUDGT_AMT + FED_BUDGT_AMT + LOCAL_BUDGT_AMT + REQAMT_PRIOR3 + CURRENT + INC_CREDIT + CURRTOTAL +
NET_OUTLAYS + LOCAL_AMT + FED_ALL + FILLER2 + FILLER1 + FILLER3 + FILLER4 + FILLER5 + CMT_FUND1 + CMT_FUND2A + LOCAL_SHARE + FED_ALL_RECD1 + FED_ALL_RECD; NOPRINT


BY FILLER NOPRINT
BY FBASEIDX AS 'GRANT' NOPRINT
BY FBASEIDXX AS 'FAIN'

BY AGCY4 AS 'AGY'
BY FUND_AGENCY
BY FS_DETAILX AS 'BUDGET,LINE'
-*
WHERE TOTAL ALL_TOTAL NE 0.00;

ON FBASEIDX SUBTOTAL AS '*TOTAL GRANT'
ON FBASEIDX SUBTOTAL SKIP-LINE

ON FBASEIDXX SUBTOTAL AS '*TOTAL'
ON FBASEIDXX SUBTOTAL SKIP-LINE

ON AGCY4 SUBTOTAL AS '*TOTAL'
ON AGCY4 SUBTOTAL SKIP-LINE



HEADING
"&DATEMDY"
"PAGE: FOOTING
""
ON TABLE SET PAGE-NUM OFF
ON TABLE COLUMN-TOTAL AS 'TOTAL'
ON TABLE PCHOLD FORMAT EXL2K FORMULA

ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='Letter',
LEFTMARGIN=0.250000,
RIGHTMARGIN=0.250000,
TOPMARGIN=0.250000,
BOTTOMMARGIN=0.250000,
SQUEEZE=ON,
ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
GRID=OFF,
FONT='TIMES NEW ROMAN',
SIZE=8,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
$
TYPE=HEADING,
LINE=1,
JUSTIFY=CENTER,
$
TYPE=HEADING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
SIZE=10,
$
TYPE=HEADING,
LINE=2,
JUSTIFY=CENTER,
$
TYPE=HEADING,
LINE=2,
OBJECT=TEXT,
ITEM=1,
SIZE=10,
$
TYPE=HEADING,
LINE=2,
OBJECT=FIELD,
ITEM=1,
SIZE=10,
$
TYPE=HEADING,
LINE=3,
JUSTIFY=CENTER,
$
TYPE=HEADING,
LINE=3,
OBJECT=TEXT,
ITEM=1,
SIZE=10,
$
TYPE=HEADING,
LINE=3,
OBJECT=TEXT,
ITEM=2,
SIZE=10,
$
TYPE=HEADING,
LINE=3,
OBJECT=FIELD,
ITEM=1,
SIZE=10,
$
TYPE=HEADING,
LINE=4,
JUSTIFY=CENTER,
$
TYPE=HEADING,
LINE=4,
OBJECT=TEXT,
ITEM=1,
SIZE=10,
$
TYPE=HEADING,
LINE=5,
OBJECT=TEXT,
ITEM=1,
SIZE=10,
$
ENDSTYLE
END

WebFOCUS 7.7
Windows, Excel

Hi William

Your code looks fine. I went back and ran my test on WF 7.7.05 and I see the formula in the cell when I click on that cell. You may want to open a case with techsupport to have them help you debug this.

Have you tried the same code but using XLSX instead of EXL2K ?

Thank you.

quote:

XLSX

It works on XLSX. Maybe EXL2K has limitation.

Thank you so much.

If you're on WebFOCUS 7.7.*, be aware of the limitations with format XLSX.

Please take a look at WebFOCUS XLSX/EXL07 Format Supported Features Release Roadmap