We are developing a report in 7.7.03 which will be formatting to exl2k. In the Computes we were using the LAST function which was not working correctly. Since excel2k w/LAST is not supported, does anyone have a different technique? This is multi-Veb request if that makes a difference. Bottom line, trying to get away from the Circular reference displayed from Excel.
We decided to use launch forms that will allow the users to make changes rather than to programtically try to make the changes for them. Thank you for all your suggestions.This message has been edited. Last edited by: Rhonda,
WebFOCUS & ReportCaster 8.1.05, 7.7.03 - AIX/LINUX, FOCUS 7.6.13 MVS, Output PDF, XLS-XLSX, DOCX and HTML
November 17, 2011, 06:31 PM
njsden
I managed to create a multi-verb request which makes use of LAST to calculate a running total and displays results in EXL2K.
TABLE FILE CAR
SUM
COMPUTE TOT_SALES/I10 = SALES; AS 'Total,Sales'
BY LOWEST CAR.ORIGIN.COUNTRY AS 'Country'
PRINT
CAR.CARREC.MODEL AS 'Model'
CAR.BODY.SALES AS 'Sales'
COMPUTE SALES_PCT/D8.1% = ( SALES / TOT_SALES ) * 100; AS 'Sales %'
COMPUTE RUN_TOT/I10 = IF COUNTRY NE LAST COUNTRY THEN SALES ELSE RUN_TOT + SALES; AS 'Running,Total'
BY LOWEST CAR.ORIGIN.COUNTRY AS 'Country'
BY LOWEST CAR.COMP.CAR AS 'Car'
ON CAR.ORIGIN.COUNTRY SUBFOOT
" "
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = endeflt,
$
ENDSTYLE
END
Perhaps there's something else in your report that maybe causing the issue you describe.
Could you work an example using the CAR table illustrating what your problem is?
With a few minor changes, the report can actually be displayed in EXL2K FORMULA:
TABLE FILE CAR
SUM
COMPUTE TOT_SALES/I10 = SALES; NOPRINT
BY LOWEST CAR.ORIGIN.COUNTRY AS 'Country'
PRINT
CAR.CARREC.MODEL AS 'Model'
CAR.BODY.SALES AS 'Sales'
COMPUTE SALES_PCT/D8.1% = IF TOT_SALES EQ 0 THEN 0 ELSE ( SALES / TOT_SALES ) * 100; AS 'Sales %'
COMPUTE RUN_TOT/I10 = IF COUNTRY NE LAST COUNTRY THEN SALES ELSE RUN_TOT + SALES; AS 'Running,Total'
BY LOWEST CAR.ORIGIN.COUNTRY NOPRINT
BY TOT_SALES AS 'Total,Sales'
BY LOWEST CAR.COMP.CAR AS 'Car'
ON CAR.ORIGIN.COUNTRY SUBFOOT
" "
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K FORMULA
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = endeflt,
$
ENDSTYLE
END