Report Examples

The following examples show how you can use tally function and statistical fields to display the same data in different ways. Example I shows the difference in results when you select tally fields versus calculated fields. Example II shows the difference in results when you select tally fields versus calculated fields and use group / sort to categorize results.

Example I Tally vs. Calculated Field

The following shows the difference between using reporting fields that tally data and calculated fields.

Reporting Field Design Tally Function	Calculated Field Design Statistical Function
Locations Report for Name, City, and State	Locations Report for Counting Locations in a State
Name City State L1 Denver CO L2 Boulder CO L3 Evergreen CO L4 Wichita KS L5 New York NY	State Count CO 3 KS 1 NY 1

Example II Tally vs. Calculated Field and Sort/Group

The following shows the difference between using tally fields and a calculated field that counts locations and groups results by city.

Reporting Field Design List Functions	Calculated Field Design SQL Query and Grouping Functions
Locations Report for Location and City	Locations Report for City with Count Grouped by City

How To Design a Simple Report Without Calculated Fields

Extensive instructions on using Reports are provided in the Reports section. Here is an overview of two report types.

To design a simple report to display locations and their city:

1. Select Reports from the main menu.

2. Select Designs and select Add.
   Add >> Design window displays.

3. Select the Source: Organization : Location.

4. Type Name: Location and select Type:. List.

5. Select Save.

6. Under Columns, add BusinessName (Location) and City.

7. Select Save and View.
   Results list each location and city. Refer to the following example.
   Example:
   

How To Design a Report to Count Locations in Each City

To design a report to count the number of locations in each city:

1. Use the same design from above. Under Columns, select Location (Business Name) and on the Properties window, make sure the Display check box is selected for Visible.

2. Clear the check box for City.

3. Add the summary field Count. Select the field and on the Properties window, specify Tally Functions as Group: Count and Report: Sum.

4. Select the Display check box for Visible.

5. Under Sort/Group, add City. Select the field and on the Properties window, select the Display check box for City so it is Visible (Group by).

6. Select Save and View.
   Results list each location, grouped by the city it resides in, with a count of the locations.
   Example: