WebFOCUS Language

ExpandByRow Accordion Reports

The following is a known issue with Accordion reports:

Displaying the pop-up description in ExpandByRow Accordion reports, with custom page margins defined, causes the table to appear to jump around the page with mouse movement. This has been resolved in WebFOCUS Release 8.0 Version 04/Reporting Server Release 7.7 Version 05 Gen 127.

Table of Contents Reports

The following are known issues with Table of Contents (TOC) reports:

The HTML TOC drop-down list feature does not populate correctly when rendered in Internet Explorer 10 Standards Mode. This has been resolved as of WebFOCUS Release 8.0 Version 04/Reporting Server Release 7.7 Version 05 Gen 126.
When the Table of Contents (TOC) control is used to navigate to a value, the control remains in view. If scrolling on the page causes the TOC to be out of view, you may double-click on the page to reposition the control on the current visible page, or you may scroll back to its current position. If the Remove Table of Contents option is selected, a message is generated reminding the user to double-click on the page to reopen the control within view.

EXL2K FORMULA

The following are known issues with EXL2K FORMULA:

The INT function is only supported if the result is returned to a field defined with an Integer data type.
The phrase ON byfield RECOMPUTE does not recalculate the formula at the sort break, but rather, repeats the formula from the previous row.
Prefix operators used to manipulate the display values can be used with Excel FORMULA output, but are placed in the worksheet as values rather than formulas. When display prefix operators are used within a request, both the initial value and the prefixed value are placed into the internal matrix in the order in which they are defined and are available to the procedure. Excel FORMULA will use the last reference of a field in a request used in a formula from the internal matrix, unlike all other formats.
In the following example, the field UNITS will be represented twice in the internal matrix: for UNITS and PCT.UNITS. When the COMPUTE that follows references the UNITS field, it is passed the last instance of UNITS, which in this case, is PCT.UNITS, rather than the first instance, which would be UNITS.
```
TABLE FILE GGSALES
SUM UNITS
     BUDUNITS
     PCT.UNITS
     COMPUTE PERC_BUD/D12.6 = UNITS/BUDUNITS; AS 'Percent of Budget'
BY REGION 
BY ST 
ON TABLE PCHOLD FORMAT EXL2K FORMULA
END
```
SET SUBTOTALS = ABOVE may produce incorrect formulas when used with EXL2K FORMULA.

FORMAT EXL07 and EXL2K

The following issues apply to FORMAT EXL07:

FORMAT EXL07 and FORMAT XLSX are synonyms and can be used interchangeably. The the FILE SAVED message will always display XLSX FILE SAVED regardless of the format specified to identify that the actual file format generated is the XLSX file structure supported by Excel 2007, Excel 2010, and Excel 2013.
Dynamic field-based reformatting created as DEFINE or COMPUTE fields can be used in EXL2K generated workbooks, but are not currently supported for XLSX/EXL07 workbooks.

HTML HFREEZE Reporting Feature

The following browser specific issue occurs when using the HTML HFREEZE reporting feature:

When using a non-Internet Explorer browser, the top and bottom border styling of the column title is missing 1 pixel between the field column titles.
HFREEZE does not support SET SUBTOTALS=ABOVE.

Compound Layout Reports

The following issue applies to compound layout reports using document composer syntax: