HTML and Drill-Down Reports

When distributing an HTML or drill-down report, you must use the FOCHTMLURL (this must be used for Managed Reporting procedures) or BASEURL command in the scheduled procedure to set a fully qualified URL. A fully qualified URL is needed so that the user viewing the report has access to the URL on the Web server where the WebFOCUS Client is installed. This enables the user to run the HTML or drill-down report, view images, resolve hyperlinks, and apply external Cascading Style Sheets (CSS).

Note: External Cascading Style Sheets (CSS) files must be fully qualified and accessible to the user receiving the report.

To run a drill-down report, a user must be able to access the Web server and the WebFOCUS Reporting Server. If the WebFOCUS Reporting Server is running in secured mode, the user must have a valid Execution ID and password to run the report. If the user does not have a valid user ID and password, an authentication message appears.

Do not use localhost as the host name when performing drill-downs. When the report gets sent to the user's machine, localhost refers to the machine the user is on. To be able to run the drill-down request, the request must be sent to the host name of the Web server where the WebFOCUS Client is installed.

Top of page

Reference: Coding Requirements for Pop-up Field Descriptions

Distributing an HTML report containing pop-up field descriptions with ReportCaster requires the use of JavaScript components located on the WebFOCUS Client. To access these components from a report distributed by ReportCaster, the scheduled procedure must contain the SET FOCHTMLURL command, which must be set to an absolute URL instead of the default value of /ibi_html.

For example,

SET FOCHTMLURL = http://hostname[:port]/ibi_html

where:

hostname[:port]: Is the host name and optional port number (specified only if you are not using the default port number) where the WebFOCUS Web application is deployed.
ibi_html: Is the site-customized Web server alias pointing to the WebFOCUS76/ibi_html directory. ibi_html is the default value.