For example, you may want to see how long it takes a call to be closed broken down by call type and the group it was assigned to. In this case, the rows would be the call types, the columns would be the service groups, and the cell at the intersection of a specific row and column would be the total elapsed time that group takes to resolved calls of that call type.

To create a cross-tab report, you select at least three fields you want to appear in the report, and then select where each field goes. A row field is one that has each different value appear in a row in the report. A column field is one that has each different value appear in a column in the report. A data field is one that's summarized and placed in the cells at the intersection of rows and columns.

Here are some notes about how cross-tabs work:

• You can have more than one row field. For example, you may want calls by call type, and within call type, by tracker. Choose both the call type and tracker fields, and select call type as the first row field and tracker as the second. The report will show each tracker in each call type, with subtotals for each call type.

• You can specify how the data field is summarized. For numeric fields, the default is to sum the values. For all other types of fields, you can only have it count the number of values.

• If you use a date field as the column field, you can specify how the date is displayed. For example, you may want to show the month or year in the columns rather than the individual dates.

• You can have more than one data field. For example, if you want to show not only the total elapsed time but also the count of how many calls there were, select the elapsed hours field and some other field, and make them both data fields. The elapsed hours field would be summed and the other field would be counted.

• Since there may be a lot of rows and/or columns, depending on the fields you choose, Stonefield Query automatically horizontally paginates the report for you. This is similar to how spreadsheets like Microsoft Excel print multi-page reports. Stonefield Query prints a page for the first set of rows and columns, then the next page has the same set of rows but more columns, and so on until all of the columns have been printed. Then it prints the next set of rows and the first set of columns, and continues in this manner until all columns and all rows have been printed.

• There are totals for each row and each column, and a grand total at the end of the report.
  

To create a cross-tab report, follow the steps in the Creating a Report topic. The Cross-Tabulation Wizard shown below appears.

You can resize the Cross-Tabulation Wizard window by clicking the lower right corner of the window and dragging until the window is the desired size. Stonefield Query remembers the size and position of the Cross-Tabulation Wizard and restores it the next time you run it.