Two Way Cross Tab Report

These instructions describe how to generate a Two way Cross tab report. Before you can create a cross tab report, you must first make a subset of cases to be used for the report. If you would like to see instructions on Creating a new Subset click here.

From the RMCDS Main Menu click on Reports > Frequency/Cross Tabs > Two Way Cross Tabs

This will bring up the Cross Tab Report window.

First, type in the name of the subset you want to use for this frequency report in the box labeled Subset Name. Click on Browse to select the subset from a list of available subsets on your computer.

Next you need to select the item numbers for your cross tab reports. In the area labeled Choose which item to instert there are two boxes; Row Item # and Column Item #. Both a Row # and a Column # need to be entered. There are several ways to select the item #, if you know the item number that you wish to use, type it into the line labeled Enter item #. If you want to search for the item number, have the cursor in the Item box you want to find and click on Search. This will bring up a Search for Data Items window.

In the box labeled Type in Item Word: enter all or part of the variable you want to use, and click Find. (For example, if you wanted to do a Frequency by Race, you would type in the word Race and click Find.) All of the available matches to your search will appear in the box below.

Double click on the NAACCR # of the variable that you want to use. The window will close and you will return to the Frequency Report window. The Item # that you selected on the search window will be in the Enter Item # box.

You can also use the tree structure at the bottom of the window to locate variables.

Expand the sections the tree sections by clicking on the + symbol next to the labels. When you find the variable that you want to use, click on it and the Item # will automatically be entered in the Item # box that your cursor was in. Notice also that the item numbers are listed next to the variable name for your reference.

After selecting a subset name and both the Row and Column Item numbers, you can give this report a title by entering text in the box labeled Heading. The Heading is optional.

If you want to pint on wide paper (14 inch) put a check in the box labeled Do you want to print on wide paper? To include cases that have been marked as deleted put a check in the box labeled Do you wish to include deleted cases?

Once you have all the information entered, click on Run. The report will be generated and you will be taken to the print options window.

This window gives you the options to Examine & Print, Delete File, and Graph the frequency report. Clicking on Examine & Print will open the report in the editor defined in your personal parameters. Clicking on the Graph button will open the report in Excel or Quattro Pro, depending on your personal parameter settings. To generate a graph in either of these programs, highlight the data section and choose the 'generate chart or graph' option. For detailed instructions on using Excel or Quattro Pro, please see the instructions for those programs.