REPORT Subcommand (OUTPUT EXPORT Command)
The REPORT subcommand exports Viewer documents as interactive reports that are compatible with most browsers. Many of the interactive features of pivot tables available in the Viewer are also available in web reports.
DOCUMENTFILE keyword
The required DOCUMENTFILE keyword specifies the name of the exported file. The keyword is followed by an equals sign and a quoted file specification.
TITLE keyword
The optional TITLE keyword specifies the title that is displayed in the header of the report. The keyword FILENAME uses the file name as the title. To use a custom title, specify the title as a quoted string.
FORMAT keyword
There are two alternatives for the optional FORMAT keyword:
- HTML
- Creates an SPSS web report. This format requires a browser that is compatible with HTML 5. This option is the default setting.
- MHT
- Creates a Cognos Active Report This format requires a browser that supports MHT format files or the Cognos Active Report application..
RESTYLE keyword
There are two alternatives for the RESTYLE keyword:
- YES
- Apply the standard web report style to all tables and charts. This overrides any fonts, colors or other styles in the output as displayed in the Viewer. This option is the default setting. You cannot modify the standard web report style.
- NO
- Do not apply the standard web report style. Tables and charts in the web report will look the same as they do in the Viewer.
URL
The URL keyword specifies a descriptive label and URL for an application server running the IBM® SPSS® Statistics Web Report Application Server. The application server provides the ability to pivot tables, edit charts, and save modified web reports. If a web report contains a URL specification, the web report connects to that application server to provide the additional editing features. The application server can be downloaded from http://www.ibm.com/developerworks/spssdevcentral.
The descriptive label and URL are specified as quoted strings, enclosed in parentheses. The general form is:
URL = ("label", "URL location")
You can specify multiple URLs, each preceded by a label.
- The quoted label and quoted URL are separated by commas.
- Each pair of labels and URLS is separated by a semi-colon.
- To omit the label, specify an empty (null) quoted string.
URL = ("label", "URL location"; "", "URL location")
If you specify multiple URLs, the web report will attempt to connect to each server in the order in which they are specified.
EXCLUDE keyword
You can use the optional EXCLUDE keyword to exclude selected object types from the report. You can specify one or more object types to exclude.
- TEXTS
- Text objects other than logs.
- LOGS
- Text objects that contain a listing of the command syntax that was run and warnings and error messages that are encountered by commands that do not produce any Viewer output (for example commands that define variable properties and data transformation commands).
- NOTES
- Output from statistical and charting procedures includes a Notes table, which contains information about the dataset that was used, missing values, the command syntax that was used to run the procedure, and the computer resources that were used to run the procedure.
- WARNINGS
- Warnings and error messages from statistical and charting procedures.
Example
OUTPUT EXPORT
/REPORT
DOCUMENTFILE='/monthlyreports/thismonth.htm'
TITLE='Report for this month'
FORMAT=HTML
EXCLUDE=NOTES LOGS.