Report Studio

Format crosstabs to give them the appearance you want. You can specify formatting for rows, columns, and fact cells in a crosstab, or for the entire crosstab. When you specify formatting for all rows, columns, fact cells, or the crosstab, the formatting is automatically applied to any new items you add.

Order of Styles Applied

If you apply the same styles, such as font colors, to crosstab rows, columns and crosstab intersections, the styles are applied in the following order:

• Crosstab fact cells
• Fact cells in the outermost rows
• Fact cells in the innermost rows
• Fact cells in the outermost columns
• Fact cells in the innermost columns
• Crosstab intersections

The style applied to the last object in the list overrides styles applied to previous objects. In addition, class styles are applied before styles that you apply manually.

You can also quickly format crosstabs by applying table styles , and add white space to a crosstab by inserting crosstab space objects. For more information, see Inserting Other Objects.

To Format a Crosstab Report:

1. To format the entire crosstab, do the following:

1. Click anywhere in the crosstab.
2. Click the select ancestor button in the title bar of the Properties pane and click Crosstab.
3. In the Properties pane, click the property you want and then specify a value.
   For example, to specify a background color, click Background Color and choose the color you want to use.

2. To format all rows, columns, or fact cells, click a row, column, or fact cell in the crosstab and then do the following:

1. If you clicked a row, click the select ancestor button in the title bar of the Properties pane and click Crosstab Rows.
2. If you clicked a column, click the select ancestor button in the title bar of the Properties pane and click Crosstab Columns.
3. If you clicked a fact cell, click the select ancestor button in the title bar of the Properties pane and click Crosstab Fact Cells.
4. In the Properties pane, click the property you want and then specify a value.
   For example, to specify a background color, click Background Color and choose the color you want to use.

3. To format all crosstab cells for a specific row or column, do the following:

1. Click the row or column.
2. Click the select ancestor button in the title bar of the Properties pane and click Crosstab Member Fact Cells.
   
   Note: You can also right-click the row or column and click the menu option for selecting the member fact cells. The menu option indicates the crosstab cells you will be formatting. For example, if you have Product line as rows and you right-click it, the menu option will be Fact Cells for "Product line".
3. In the Properties pane, click the property you want and then specify a value.
   For example, to specify a background color, click Background Color and choose the color you want to use.

4. To format all row or column titles, do the following:

1. Click a row or column title.
2. Click the select ancestor button in the title bar of the Properties pane and click Crosstab Rows or Crosstab Columns.
3. In the Properties pane, click the property you want and then specify a value.
   For example, to specify a background color, click Background Color and choose the color you want to use.

5. To format an individual row, column, or intersection, do the following:

1. Click the row, column, or intersection.
   Note: To format the data in a row, column, or intersection, click the unlock button in the toolbar and then click the text item you want to format.
2. In the Properties pane, click the property you want and then specify a value.
   For example, to specify a background color, click Background Color and choose the color you want to use.

Note: In cases where fact cell formatting applied to rows conflicts with fact cell formatting applied to columns, you can use the Fact Cells Precedence property in the Properties pane to determine whether the row formatting or the column formatting has precedence. To specify this property, click anywhere in the crosstab. Then click the select ancestor button in the title bar of the Properties pane and click Crosstab.

For more information about formatting reports, see Formatting a Report.

Related Topics:

• Crosstab Nodes and Crosstab Node Members—Crosstab node and node member overview.
• Moving Crosstab Nodes—How to move crosstab nodes.
• Creating Single-Edge Crosstab Reports—How to create a single-edge crosstab report.
• Specifying the Default Measure—Specifying the default measure for a crosstab report.

Copyright © 2018 Daptiv Solutions, LLC. All Rights Reserved