Formatting Cross Tabs

Controlling the column and column sizes within a cross-tab is accomplished by changing the field widths and heights of the objects within the columns or rows. To change the field sizes within your cross-tab, locate the field you want to change and click to select it. This should put a single handle on each side of the field object; you can resize the field by dragging these blue handles. As you resize one field in a column or row, the entire column or row is resized.

Crystal Reports includes a number of preformatted styles that affect the formatting, font size, color, and so on. You can use these to give your cross-tab a standard look and feel. Even if you don't care for any of the styles available, they are often a good starting point for creating your own custom formatting. To apply a preformatted style to your cross-tab object, insert or edit an existing cross-tab and, in the Format Cross-Tab dialog, click the Style tab to open the dialog shown in Figure 3-26.

Figure 3-26

You can click to select a predefined style to apply to your cross-tab. As you click a style, the preview window on the right will display a sample of that style. When you are finished selecting your style, click OK to accept your changes and return to your report's design.

Cross-tab styles can be the starting point for creating your own cross-tab format. To modify a cross-tab style, click the Customize Style tab to open the dialog shown in Figure 3-27.

Figure 3-27

Keep in mind that the changes you make here are for a specific cross-tab and do not change the underlying style within Crystal Reports. The options for customizing a particular style are divided into two categories: group options and grid options.

Group options include the ability to suppress a subtotal or label and change the background color of a particular row or column by highlighting the field and using the drop-down list to select a color. Another group option is the ability to set an alias for formula fields by highlighting a field and entering a new name in the dialog shown in Figure 3-28.

Figure 3-28

Figure 3-28

In addition to applying and modifying styles to your cross-tab, you also have complete control over the grid options and grid lines that appear in and around your cross-tab, as shown in Figure 3-29.

When you are finished setting the grid lines for your cross-tab or OLAP grid, click OK to return to your report design. The changes you have made should be reflected in your cross-tab. Figure 3-30 shows an example of a cross-tab that has been formatted using the grid settings.

Figure 3-29



Was this article helpful?

0 0

Post a comment