Previous Topic  Next Topic

Crosstab Properties

You can use the Crosstab Properties dialog box to edit the properties of a crosstab. This topic describes the properties in the dialog box.

This topic contains the following sections:

• General Tab Properties
• Border Tab Properties
• Crosstab Tab Properties
• Others Tab Properties

OK

Select to apply any changes you made here and exit the dialog box.

Cancel

Select to close the dialog box without saving any changes.

Help

Select to view information about the dialog box.

General Tab Properties

Specify the general properties of the crosstab.

Name

Specify the display name of the crosstab.

Show NLS Value

Select to show the translated name for the display name of the object in the Name text box if you have enabled the NLS feature and translated it, and when you have not modified the display name of the object.

Position

Select the position mode of the object when it is directly contained in the report body, a tabular cell, or a text box.

• Absolute
  Select if you want to use the X and Y property values to decide the object's position.
• Static
  Select if you want to place the object at the default location in its container. Server will hide or disable the X, Y, and other position-related properties.

X

Specify the X coordinate of the crosstab, in inches.

Y

Specify the Y coordinate of the crosstab, in inches.

Width

Specify the width of the crosstab, in inches.

Height

Specify the height of the crosstab, in inches.

Background

Specify the background color of the crosstab.

To change the color, select the color indicator to access the Select Color dialog box, and then specify a new color. You can also type a hexadecimal RGB value to specify a color, for example, #9933ff. If you want to make the background transparent, type Transparent in the text box.

Back to top

Border Tab Properties

Specify the border properties of the crosstab.

Color

Specify the color of the border.

To change the color, select the color indicator to access the Select Color dialog box, and then specify a new color. You can also type a hexadecimal RGB value to specify a color, for example, #9933ff. If you want to make the border transparent, type Transparent in the text box.

Has Border

Select true if you want to show the border.

Back to top

Crosstab Tab Properties

Specify the layout properties of the crosstab.

Horizontal Gap

Specify the space between the content and the left/right edge of a crosstab cell.

Vertical Gap

Specify the space between the content and the top/bottom edge of a crosstab cell.

Block Gap

Specify the spacing between each part of the crosstab if the crosstab splits into more than one part.

Row Totals on Top

Select true to display the Total row in the first row of the crosstab.

Column Totals on Left

Select true to display the Total column in the first column in the crosstab.

Repeat Column Header

Select true to repeat column headings on every page.

Avoid Orphan Header

Sometimes the column header happens to be at the bottom of a page. Select true if you want to keep the column header together with the data in the next page.

Expand Data

Select true if you want to expand or collapse dimensions in the crosstab.

Suppress Row Header

Select true to hide the row headers.

Outside Aggregate Title

Select true to place the titles of aggregate fields outside.

Suppress Column Header

Select true to hide the column headers.

Table Style

Select true to add headers to the Total rows and columns.

Repeat Aggregate

Select true to repeat the crosstab for different aggregate fields. For more information, see Repeat Aggregate in the Logi Report Designer Guide.

Aggregate

Specify the layout of the aggregate fields.

• Vertical Layout
  Select this option to arrange the aggregate fields vertically.
  • Number of Rows
    Specify the number of rows to hold the aggregate fields in the crosstab. By default, it is -1 which means that Server places each aggregate field in a row so that the aggregate fields are in one column vertically. Server treats a number equal to or larger than the number of aggregate fields in the crosstab as -1. If you set the number of rows (3 for example) less than the number of aggregate fields (6 for example), there will be 3 rows to hold the 6 fields with each row containing 2 fields.
• Horizontal Layout
  Select this option to arrange the aggregate fields horizontally. When you have multiple aggregate fields in the crosstab, using horizontal layout can make the report more readable.
  • Number of Columns
    Specify the number of columns to hold the aggregate fields in the crosstab. By default, it is -1 which means that Server places each aggregate field in a column so that the aggregate fields are in one row horizontally. Server treats a number equal to or larger than the number of aggregate fields in the crosstab as -1. If you set the number of columns (3 for example) less than the number of aggregate fields (6 for example), there will be 3 columns to hold the 6 fields with each column containing 2 fields.

Back to top

Others Tab Properties

Configure some miscellaneous settings.

Auto Scale in Number

Select true if you want to automatically scale the values that are of the Number data type when the values fall into the two ranges:

• When 1000 <= value < 10^15, Logi Report uses the following quantity unit symbols of the International System of Units to scale the values: K (10^3), M (10^6), G (10^9), and T (10^12).
• When 0 < value < 0.001 or value >= 10^15, Logi Report uses scientific notation to scale the values.

Current Row Block Index

Specify the vertical index of the data block. 0 means the first block index, 1 the second, and so on.

Current Column Block Index

Specify the horizontal index of the data block. 0 means the first block index, 1 the second, and so on.

Items per Row Block

Specify the number of rows in each data block.

Items per Column Block

Specify the number of columns in each data block.

The preceding four properties work together to control the data of the crosstab to display in the continuous page mode: Current Row Block Index, Current Column Block Index, Items per Row Block, and Items per Column Block.

TOC Anchor

Select true if you want to add the object to the TOC tree in the TOC Browser.

Suppress When No Records

Select true if you want to hide the object in the report result when no record returns to its parent data component.

Export to XLS

Select true if you want to export the object when you save the report result as an XLS file (make sure to check Data Format in the Export dialog box).

Export to CSV

Select true if you want to export the object when you save the report result as a TXT file with Delimited Format.

Back to top

Previous Topic  Next Topic