DialogWeb Help:  CROSSTAB with REPORT

CROSSTAB, abbreviated xtab, is an option used with the REPORT command in File 588, FI/DMS Contract Awards. It automatically aggregates amounts from individual records and provides column totals. It is designed to facilitate market analysis by providing comparisons of numeric quantities, such as contract amounts for a defined group.

CROSSTAB can be used with sets containing up to 5,000 records. It lets you specify up to two data fields that display in rows. A CROSSTAB report can include up to eight columns of data.

ROWTOTAL is an option that can be used with CROSSTAB. It creates an extra column showing a sum for each row of data. You can enter a report title of up to 80 characters and you can specify that the output be RANKed in descending order.

To use CROSSTAB, create a set of records in File 588, then enter the REPORT command using the following format:
report s1/crosstab for nn row nn column nn.

For example, to create a report of Contract Amounts (CA) by service and fiscal year for marine and ship equipment (PC=20), enter select pc=20 and then enter report s1/crosstab for ca row sv column fy. To get a further breakdown by service and agency enter report s1/crosstab for ca row sv, ag column fy.

You can also display a series of menu prompts for CROSSTAB by entering the REPORT command, a set number, a slash, and the XTAB option; for example, enter report s1/xtab.