WebFOCUS Language

In this section:

The following are upgrade considerations and product changes for the WebFOCUS reporting language.


Top of page

x
Compound Documents Change in Behavior

As of Release 8.0, when a component in a Compound document contains a report that generates an error or attempts to create a HOLD file to be used in other components, but 0 records are produced, error messages will be displayed and processing of the document will be terminated.

(FOC32584) WARNING: FILE HOLD(n) IS EMPTY
(FOC3298) ERROR FOUND IN A COMPOUND REPORT
Compound Report is TERMINATING.....

Top of page

x
XLSX Worksheets

In previous releases, when there was not enough space under the BY columns to display the full SUBTOTAL TAG text, SUBTOTAL and RECOMPUTE lines within a report displayed across two rows. As of WebFOCUS Reporting Server Release 7.7.06M Gen 801, these SUBTOTAL rows will show on a single line and any TAG text larger than the BY columns will display only what can fit in this space. The full value can be seen in the formula bar.


Top of page

x
ASIS Function

As of Version 7 Release 7.05, the ASIS function no longer considers a dot (.) and a blank space as equal.


Top of page

x
APP COPYF Command

In WebFOCUS 8.0.x and higher, the DROP option of the APP COPYF command is not optional. Omitting it will generate an error.


Top of page

x
FORMAT EXL07

Using XLSPAGESETS will automatically set the page margins to the default values of .25 inches. This will cause a change for procedures from EXL2K to EXL07. The only page setup feature supported in EXL2K is orientation. Margins are set to the Excel default for a new workbook: 1 inch top and bottom and .75 inch left and right.


Top of page

x
FORMAT PPTX

The new PPTX output format is supported as of WebFOCUS Release 8.0 Version 08 and WebFOCUS Reporting Server Release 7.7.05M Gen 157.

The Release 8.0 Version 08 WebFOCUS Client Redirection configuration file (mime.wfs) contains the file type entries to support PPTX and PPTM presentations. You can configure earlier WebFOCUS Client 8.0.x releases to support PPTX and PPTM presentations created by the Reporting Server JSCOM functionality by manually adding the PPTX and PPTM file type entries to the WebFOCUS Client Redirection configuration file (mime.wfs).

The mime.wfs file is location in the \client\wfc\etc directory of the WebFOCUS Client installation. The default directory path is:

C:\ibi\WebFOCUS8\client\wfc\etc

Note: PPTX and PPTM presentations created with the WebFOCUS Client Servlet functionality is only supported in Release 8.0 Version 08 and higher.

To add the PPTX and PPTM file type entries to the WebFOCUS Client Redirection configuration file (mime.wfs):

  1. Backup the mime.wfs file located in the WebFOCUS Client \client\wfc\etc directory.
  2. Edit the mime.wfs file and add the .potm and .potx entries after the .png entry. Each <ADDTYPE> entry is on a single line.
    <ADDTYPE> .potm application/application/vnd.ms-powerpoint.template.macroEnabled.12
    binary no DEFAULT no .potm
    <ADDTYPE> .potx application/vnd.openxmlformats-officedocument.presentationml.template
    binary no DEFAULT no .potx
  3. Add the following entries for .pptm and .pptx after the .ppt entry. Each <ADDTYPE> entry is on a single line.
    <ADDTYPE> .pptm application/vnd.ms-powerpoint.presentation.macroEnabled.12
    binary no DEFAULT no .pptm
    <ADDTYPE> .pptx application/vnd.openxmlformats-officedocument.presentationml.presentation
    binary no PPTX no .pptx
  4. Save the mime.wfs file.
  5. If the WebFOCUS web application is running, the WebFOCUS Client cache needs to be cleared by using the WebFOCUS Administration Console Clear Cache option or restarting the application server the WebFOCUS Client is deployed on.
  6. Sign on to the WebFOCUS Administration Console and access the Redirection Settings from the Configuration option to verify that the .potm, .potx, .pptm, and .pptx file types list correctly. The following image of the WebFOCUS Administration Console Redirection Settings shows the added PowerPoint file types.

Note: These steps add the capability only to interactive reporting. ReportCaster distribution is not available.


Top of page

x
Accordion By Row Reports

The following are upgrade considerations and product changes for Accordion By Row reports.


Top of page

x
WebFOCUS Font Support

As of WebFOCUS Reporting Server Release 7.7 Version 05 Gen 705 and higher, you can selectively embed a subset of Unicode (Arial Unicode and MS Lucida Sans Unicode) or Non-Unicode (Tahoma, Times New Roman, Trebuchet MS, and Courier New) TrueType fonts into a PDF file. The generated PDF file will contain only the characters required to render the document.


Top of page

x
HTML HFREEZE Reporting Feature Implementation Change

An implementation change was required for the HTML HFREEZE reporting feature to fix alignment issues and provide non-Internet Explorer browser support. The HFREEZE measuring mechanism uses an extra data row to calculate the column width correctly. The report width measuring mechanism will use an extra data row. For the row of data to be measured properly, the extra data row has to be visible. This visible extra row increases the space on the report in each of the three HTML table (<TABLE>) sections created for the report HEADING, column titles and data, and FOOTING. The extra space has been minimized and must be displayed to measure the width of the columns correctly.

The implementation change also provides non-Internet Explorer browser support with the HFREEZE reporting feature. The HFREEZE reporting feature is certified with the following browsers when using the WebFOCUS 8 WebFOCUS Client with a Release 7.7 Version 04 Reporting Server.

For the most current information related to browser version or configuration, view the WebFOCUS Browser Support statement at the following URL:

https://techsupport.informationbuilders.com/tech/wbf/wbf_tmo_027.html


Top of page

x
Variables Hidden with the -DEFAULTH Command

As of WebFOCUS Reporting Server Release 7.7 Version 05, the Dialogue Manager query command -? no longer displays the values of hidden variables defined with the -DEFAULTH command.


WebFOCUS