Quick Report - Cross Tab

Quick Report - Cross Tab

Previous Top Next

FirePoint's Quick Report Editor - Cross Tab Reports

Here's an example of how the Quick Report Editor handles Cross Tab reports.

At the Command Window press the Apparatus button to bring-up the Apparatus list view. Press Search button and select the Show All option. Under the File menu select Print Report.... Press the Quick Report button to create an ad hoc report.

Press the Create button to begin creating your quick report.

A Cross Tab report compares values stored in three fields. Let's say, for example, we want information about the response of each company ([Apparatus]VehicleID) broken down into responses (counts) by Station and by number of responders ([Apparatus]NoofPeople).

Here's the procedure:

1.	Press the Cross Tab button in the lower left to begin work on a Cross Tab report.

2.	Drag the "VehicleID" field from the field list below into the first column / second row of the Cross Tab table above. Remember in a Cross Tab report the first column / first row is always blank.

3.	Drag the "StationNo" field from the field list below into the second column / second row of the Cross Tab table above.

4.	Drag the "NoofPeople" field from the field list below into the second column / second row of the Cross Tab table above.

This is how your set-up should look at this point.

5.	Notice the pointer is in the "Sort order" box in the lower left of the illustration above. Click once to change "No sort" column into "From top to bottom". This sorts the VehicleID values as they are displayed in rows down the left side of the report.

6.	Click once to change the "No sort" row into "From left to right" in the other label area at the top of the Sort order box. This sorts the StationNo field values from left to right across the top of the Cross Tab report.

7.	Click once in the second column / second row where the [Apparatus]NoofPeople field is located. Now click once on the Sum Tool (that looks like an "E") and then the Count Tool (that looks like an "N"). Put "sums" and "counts" in the other cells as illustrated above.

8.	In the first column bottom row place the label, "Total Vehicles".

9.	In the last column top row place the label, "Total Stations".

Here's how your report editor will look:

Under the File menu select Print Preview.... Press the Print preview checkbox on the printer dialog. Here's how your report will look.

Notice how totals are display by the number of responders (sum) over the number of responses (count). Grand totals are always displayed in the last column / last row.

Experiment with different fields. For example, you can drag the [Apparatus]Duration field over the [Apparatus]NoofPeople field to see duration of incident response broken-down by Vehicle ID and Station.

Here's another idea. Replace the [Apparatus]StationNo field by dragging the "AlarmDate" field on top of it. Right-click the [Apparatus]AlarmDate field and select the Edit... option. Surround the [Apparatus]AlarmDate field with a pair of parenthesis and add "Month of" in front. Here's new the formula:

Month of([Apparatus]AlarmDate)

Press OK to accept the formula. This new formula will now break down Vehicle responses by month (1 - 12) rather than by station. Now you can see trends over time.

Remember, just like for List reports, you have the ability to change fonts, bold and colorize your report as you wish.

You can even select a predetermined style by opening the Style menu and selecting Presentation...

Reports are not restricted to being printed to paper as boxes and numbers. Under the File menu select Destination and choose the Graph option. FirePoint will create a color graph illustrating the data in the subtotal report you created.

You also have the option of creating ASCII text files from the data in your database. These ASCII files can be used to export data in the field order you select when setting-up your Quick Report. Simply choose the File menu, Destination and Disk File.

Remember, report formats may be saved and reopened under the File menu.