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
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.
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 formats vary depending on the type of report selected. The Crosstab Style tab of the Properties window supports the following output formats:
• CSV
• HTML
• 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.
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 |
|
Description | |
|
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. | |
|
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. | |
|
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 |
|
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. |
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.
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.
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.