WebFOCUS
Online Help > ReportCaster Development and Administration > Tips and Techniques for Coding a ReportCaster Report > Distributing a TOC Report Using ReportCaster
Distributing a TOC Report Using ReportCaster
You can enhance navigation within a large HTML report
by adding a dynamic HTML-based Table of Contents (TOC). To take
advantage of this feature, the report must contain at least one
vertical sort (BY) field. If you include more than one sort field
in a report, the hierarchy is determined by the order in which the
sort fields are specified in the request. To add a TOC for a lower-level
sort field, you must also add a TOC for its parent.
The TOC displays, as hyperlinks, all values of the first (highest-level)
vertical sort field, as well as the values of any lower level BY
fields that you designate for inclusion. Unless otherwise specified
in the request, a new page begins when the highest-level sort field changes.
Note:
- The size of
a TOC-enabled report is limited to the memory available on the WebFOCUS
Client.
- Bursting a
TOC-enabled report using ReportCaster is not supported.
- The controlling
multiple reports feature, documented in Controlling Multiple Reports in the Developing
Reporting Applications with Graphical Tools manual, is not
supported by ReportCaster.
Syntax: How to Distribute a TOC Report Using ReportCaster
To
distribute a TOC report using ReportCaster, add the following code
in the procedure:
SET BASEURL=http://hostname
where:
-
hostname
-
Is the host name of the Web server on which the WebFOCUS
Client is installed.
For example:
SET BASEURL=http://server1/
SET PAGE-NUM=OFF
TABLE FILE CENTORD
HEADING
"Sales Report"
" "
SUM LINEPRICE AS 'Sales'
BY PLANT
BY PRODCAT
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=REPORT, GRID=OFF, FONT=ARIAL, SIZE=12, $
TYPE=HEADING, SIZE=16, $
ENDSTYLE
ON TABLE SET COMPOUND BYTOC
END
The
following image shows an HTML report containing a dynamic HTML-based
TOC in the upper left corner. After it is created, this report can
be distributed by ReportCaster.
Distributing an EXL2K TOC Report
If a report that
generates an EXL2K TOC in Managed Reporting is only generating the
first sheet when distributed by ReportCaster, this is because ReportCaster
is not processing the BYTOC request properly. As a workaround, add
SET ONLINE-FMT=EXL2K to ensure that the BYTOC request is processed.
For example:
SET BASEURL=http://webserver:port/
SET COMPOUND=BYTOC
SET ONLINE-FMT=EXL2K
TABLE FILE CAR
PRINT SALES AS 'Sales'
BY MODEL
BY CAR
HEADING
"Sales Report"
" "
ON TABLE SET PAGE-NUM OFF
ON TABLE SET BYDISPLAY ON
ON TABLE NOTOTAL
-*ON TABLE PCHOLD FORMAT EXL2K
END