Click here to skip navigation
OPM.gov Home  |  Subject Index  |  Important Links  |  Contact Us  |  Help

U.S. Office of Personnel Management - Ensuring the Federal Government has an effective civilian workforce

Advanced Search

Skip FedScope Help Banner, Top Navigation Links

FedScope - Help

Help Main Interfaces
Enhanced  | 
Generic
 

Enhanced Interface

Limit the Size of Crosstabs

<<  18 of 24  >>

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 FedScope for the rows and columns override the default row and column limits which are 50 and 20 respectively.

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


Button  Description

Next Page of Columns Icon

Moves to the next page of columns. 

Previous Page of Columns Icon

Moves to the previous page of columns.

First Page of Columns Icon

Moves to the first page of columns.

Last Page of Columns Icon

Moves to the last page of columns.

Next Page of Rows Icon

Moves to the next page of rows.

Previous Page of Rows Icon

Moves to the previous page of rows.

First Page of Rows Icon

Moves to the first page of rows.

Last Page of Rows Icon

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 FedScope toolbar, click the Display Options Display Options Icon icon.
  2. In the Number of Rows box, select the number of rows you want to show.
  3. In the Number of Columns box, select the number of columns you want to show.
  4. Click Apply, and then click OK.

The crosstab shows the limited number of rows and columns.

Tip
  • To fit your display on one page, in the Display Options dialog box, select the Fit Charts check box.
Note
  • The Number of Rows and Number of Columns settings apply only to crosstab displays.
Dimension Viewer Title/Navigation Bar
Dimension Line
Display Area
Display Options Window
FedScope Toolbar
 
<<  18 of 24  >>

Help Main | Enhanced Interface | Generic Interface
Close Window Questions/Comments to: FedScope@opm.gov