Crosstab Properties

You can customize many aspects of your crosstab report display. Click the Properties button at the bottom left of the crosstab window. The Properties window displays the following tabs:

•   Crosstab Style

•    General

•   Advanced

•   Auto Format

•   Conditional Format

Crosstab Style Tab

The Crosstab Style tab for a crosstab report is shown below.

 

   Figure 175: Crosstab Style Tab

Use the Crosstab Style tab to select the type of crosstab reports and the output format.

Report Type Buttons

The crosstab type buttons on the Crosstab Style tab allow you to select the required style for your report. For examples and descriptions of each crosstab type, see Choosing the Crosstab Report Type on page 225.

Output Format

Output formats vary depending on the type of report selected. The Crosstab Style tab of the Properties window supports the following output formats:

•   CSV

•   HTML

•   PDF

•   HTML and CSV

•   HTML and Excel 97

•   HTML, CSV and Excel 97

•   Row Based XML  

For a description of these formats, see Output Format on page 251.

General Tab

The General Tab of the Crosstab Properties window is shown below.

 

   Figure 176: Crosstab Properties: General

You can enter a description for the crosstab in the Description: field.

The fields in the Show/Hide Attributes section are described in the following table.

Table 49: Show/Hide Attributes

Property

Description

Show Date

Shows the date that you run the reports at the top of the Crosstab page.

Show Report Border

Shows a raised border around the Crosstab page.

Show Page Number

Shows the page numbers in the final report when the crosstab report runs over multiple pages.

Show Description

Shows the description that you typed in the Description box centered under the crosstab.

Show Parameter

Shows the name of the parameter and its value in the upper left corner of the displayed crosstab. The displayed parameter has the form parameter = value. You can also show parameter values in the crosstab title, as described in Adding a Crosstab Title on page 228.

Show rows having only zero values

Shows the redundant rows. See Avoiding Illogical Groupings of Columns on page 228 for information on how to avoid using this option to suppress illogical groupings of columns.

Show measure/axis headings

Displays the headings for axes and measures.

The fields in the Miscellaneous Attributes section are described in the following table.

Table 50: Miscellaneous Attributes

Property

Description

Template

Chooses a background template for your crosstab report from a drop-down list of template files that your system administrator has provided. These typically include company name and logo or department name. Click the Refresh button to get the latest list of template files.

Max number of rows from DB

Sets the maximum number of rows returned from the database. When you set this value to one that is smaller than the number of rows in the database that satisfies the query, the database returns incomplete data. For example, if you set this number to 20, you get only the first 20 rows back from the database, even if there are more than 20 rows that satisfy the query. Use this option only in cases where you want to test that your query has the correct syntax and is returning the data that you want and in the format that you want. Note: The maximum number of rows you can display may have been set by your administrator. If your administrator enforces such a limit, you cannot override it.

CSV Delimiter

Specifies a character or string of characters to use as delimiters (separator characters) in a CSV report. You may enter up to seven characters. If you do not enter a value here, a comma is used.

Adjust Width

Determines how much of the screen width the crosstab takes up. If you check this checkbox, the table is resized to take up the whole width of the browser window. If you deselect this checkbox, the table is compressed so that it takes up as little horizontal space as possible. The effect of this setting may not be visible if there are many columns in the crosstab.

Use MS-Office 97 Format

Saves the crosstab snapshot in Microsoft Excel format.

Display null values as zeroes

Places zeros in empty fields.

The fields in the Display Style section are described in the following table.

Table 51: Display Style

Property

Description

All on one HTML page

Views all the rows for the crosstab on a single page. This is useful if you want to print the entire report at once. Because some web browsers have limits on how much data can be displayed in a single table, you can limit the size of the tables used on that page. To do this, set the Maximum number of detail rows in each table field. This setting does not include header, footer or summary information as part of the count. You should not set this option to above 1000 unless you are sure your web browser supports very large tables. Note: The maximum number of rows you can display may have been set by your administrator. If your administrator enforces such a limit, you cannot override it.

One page at a time

Divides the crosstab into pages. The Maximum number of detail rows per page field controls how many rows of data appear on each page. Setting the number higher increases the size of each page, but decreases the number of pages. Setting it lower does the opposite.

Advanced Tab

The advanced properties of crosstab reports are the same as the advanced properties of tabular reports. For information on using the Advanced tab properties, see Advanced Tab on page 258.

Auto Format Tab

The auto format properties of crosstab reports are the same as the auto format properties of tabular reports. For information on using the Auto Format tab properties, see Auto Format Tab on page 258.

Conditional Format Tab

The conditional format properties for crosstab reports are the same as those for tabular reports. For information on using the Conditional Format tab properties, see Conditional Format Tab on page 264.