Limit the Size of Crosstabs

To improve the performance and readability of large reports, you can limit the data that appears in crosstab displays. For example, you set a row limit of 20 and a column limit of 10. Values that you set in PowerPlay Web for the rows and columns override the default row and column limits set by your PowerPlay administrator.

When you limit the size of a crosstab, PowerPlay Web provides the following navigation buttons in the display:

Button	Description
	Moves to the next page of columns.
	Moves to the previous page of columns.
	Moves to the first page of columns.
	Moves to the last page of columns.
	Moves to the next page of rows.
	Moves to the previous page of rows.
	Moves to the first page of rows.
	Moves to the last page of rows.

When you limit the number of rows or columns in a report with nested categories, you must choose the number of categories you want to show at the lowest level. Subtotal categories are always included on each page (unless Hide Subtotals is enabled), even if the limit must be exceeded to do so.

Steps

1. On the PowerPlay Web toolbar, click the Display Options button .
2. Click Options.
3. In the Number of Rows box, select the number of rows you want to show.
4. In the Number of Columns box, select the number of columns you want to show.
5. Click Apply, and then click OK.

The crosstab shows the limited number of rows and columns.

Note

• The Number of Rows and Number of Columns settings apply only to crosstab displays.