Next
When you select HTML in the Export Tables dialog box, a number of additional options become available.
Include. Choose whether to create tables only, charts only, or both tables and charts, and whether to display the chart or the table first. For details of the way in which you can display data in charts, see Displaying Results in Charts.
Note: The HTML export requires Microsoft Office Web Components (OWC) version 10 or later to create charts. However, this is not necessary if you want to export only tables.
Default chart type. If you have chosen to export charts, select a chart type from the drop-down list.
Note: The chart type you select is used only if you have not specified a chart type for a table using the Table Properties dialog box.
Presentation. Select the style sheet you want to use to format the HTML output. You can choose from any of the built-in style sheets. If you have created any custom style sheets and added them to the styles folder, they also appear in the list. See the topic Customizing the Format of Your Results for more information.
HTML layout. This controls the layout style. Choose from:
• Single document. All of the tables and/or charts are exported to one HTML document, which has a table of contents at the top. By default the tables, charts, or table and chart pairs are separated by a printing page break.
• Table of Contents. The table of contents and each table and/or chart are exported to a separate HTML Document. You can navigate the pages using the table of contents.
• Frame Table of Contents. Each table, chart, or table and chart pair are exported to a separate document with the table of contents visible in a separate frame on the left side.
Launch browser after export. Select if you want IBM® SPSS® Data Collection Survey Reporter to automatically display the exported tables in your default browser.
Save to file. Check this box and enter a name and location for the output file, or choose the Browse button to browse to the folder where you want to save it. If you do not specify a save location, and the Launch after export option is also not selected, you are prompted to either launch the associated application or select a save location.
Choose the Advanced button to view or edit the Advanced HTML Export Properties dialog box.
Display Properties:
Variable. Choose whether to use variable names or the more friendly descriptions for the variable texts in the tables.
Category. Choose whether to use category names or the more friendly descriptions for the row and column headings in the tables.
Title. Check this box to include the project description as the title in the HTML output.
Logo. Select this option if you want a logo to be inserted in the top left corner of the HTML file. The IBM Corp. logo is provided for use as a default logo, but this can easily be replaced with any other suitable logo. You do this by including your own logo as a PNG file called logo.png in the output folder. The HTML export will not overwrite a file of this name.
Headers and footers. Select this option if you want to export the headers and footers that have been defined for the table.
Variable and category images. Select this option if you want to export images associated with table rows and columns. These may be images that were specified when the data was created using IBM® SPSS® Data Collection Interviewer Server, or they may be images that were added to your tables using IBM® SPSS® Data Collection Base Professional Tables Option.
Horizontal variable text in side headings. Select this option to display text in the side headings horizontally, or deselect to display text vertically.
Chart Properties:
Chart series. Choose whether you want the table rows or columns to form the chart series. If you select the Chart category elements or Chart special elements box, ensure that the orientation of the categories or special items (in rows or columns) corresponds to the setting entered here. For example, to create a chart for a mean that appears on the top of a table, choose as columns.
Chart category elements. You can optionally create charts for individual categories, for individual variables, or for all variables on the table. Select:
• Per element to create a separate chart for each category in the variable(s).
• Per variable to create a chart for each variable(s).
• Per table creates a single chart for all variables on the table.
Chart special elements. You can optionally create charts for statistical items (such as the mean, minimum value, standard deviation, etc.). Select:
• Per element to create a separate chart for each statistical item in each variable.
• Per variable to create a chart for all statistical items in each variable.
• Per table creates a single chart for all statistical items in all variables on the table.
Base chart on. If you want to base charts on a cell item other than the default, select the cell item from the drop-down list. The cell item must be included in the table.
Display series base. Select this option to display the base for the chart series in the legend for the chart.
Display base for last series category. Check this box to display the base for the last data point in the chart legend. This option is applicable only when charting special items. If the count cell item is present, this is used. If not, the unweighted count cell item is used.
Chart percentages using scale of 0 to 100%. Check this box if you want percentages to be charted on a scale of 0 to 100%. If this option is not selected, the scale is based on the biggest value in the chart.
HTML Properties:
Use formatted labels. Select this option if you want to use HTML formatting in variable and category descriptions in a similar way to using HTML formatting in the headers and footers. The same set of HTML tags are supported and as in headers and footers, the HTML must be well-formed. See the topic HTML Formatting for Headers and Footers for more information. Typically you set up the formatting in the Edit Variable dialog box before exporting. If you export to any of the other formats (or to HTML without using this option), any HTML tags in the variable or category descriptions will appear as plain text. Note that using this option may make the export run a little more slowly. See the topic Using HTML Formatting in Category Descriptions for more information.
Embed style sheet. Select this option if you want to embed the style sheet within the HTML file. This is useful when you want to distribute the HTML output, for example, by email.
Insert printing page breaks. Select this option if you want to add a printing page break between tables when using the Single Document layout style. Note that this option does not insert a printing page break between tables and charts.
Click to see a
picture of the Export Tables dialog box with HTML selected
Click to close the picture
