Using PowerPoint Display Format

In this section:

Specifying PowerPoint (PPT) as the output format creates a PowerPoint document with a single slide that includes the report.

You can add multiple graphs and images to a PowerPoint presentation. The PowerPoint output format can contain a variety of graphs positioned anywhere on a slide to create a visual layout.

You can also place report output on a specific slide in a PowerPoint template.

Top of page
x
Using PowerPoint Templates

How to:

A WebFOCUS report can be placed inside of an existing PowerPoint presentation. This enables you to populate existing presentations with preset Slide Masters, styling, and other business content. PowerPoint templates are stored on the server with a .MHT extension and can be distributed automatically with ReportCaster.
x
Syntax: How to Create PowerPoint Report Output
ON TABLE {PCHOLD|HOLD|SAVE} [AS name] FORMAT PPT 
      [TEMPLATE 'template' SLIDENUMBER n]

where:

name
Is the name of the PowerPoint output file.
template
Is the name of the PowerPoint template file. The template file must have at least one blank slide and must be saved as a Web Archive (.MHT extension) on your WebFOCUS Reporting Server application directory.

Tip: Since the Reporting Server cannot differentiate between Excel and PowerPoint template files (.MHT), it is important to apply a naming convention to your template files. This will help you organize and distinguish the different Excel and PowerPoint template files when developing your reports. For example, Excel_template.MHT or PPT_template.MHT.

n
Is the number of the slide on which to place the report output. This number is optional if the template has only one slide.
Example: Using a PowerPoint Template

The following request against the GGSALES data source inserts a WebFOCUS report into a PowerPoint template named ppt1.mht which is stored in the application directory:

TABLE FILE GGSALES
HEADING
" "
" "
" "
" "
" "
SUM DOLLARS UNITS CATEGORY 
BY  REGION
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PPT TEMPLATE 'ppt1' SLIDENUMBER 1
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=REPORT, FONT=ARIAL, SIZE=10,$
TYPE=HEADING, image=gglogo.gif, POSITION=(0.000000 0.000000),$
ENDSTYLE
END

The output is:

WebFOCUS