Organizing report data
Release 9.3 Last modified April 24, 2009	Print all topics in : "Creating reports"

About organizing report data

Note: This topic was updated for 9.3.1.

One advantage of displaying your data in a report is that a report allows you to organize your data. For example:

• You can sort records based on the values in one or more fields—for example, given a list of cities, you could sort them by total population.
  
• You can group records together and calculate summary statistics. For instance, you could group cities by what country they're in.
  
• You can further calculate summary statistics—for example, compute the sum, average, count, standard deviation, and minimum and maximum values.
  

How to organize report data

Sorting records

1. Click the Sorting tab on the Report Properties dialog box.
   
2. Click a field to sort in the Sort column.
   
3. Click Ascending, Descending, or None.
   
4. If you want to sort other fields, click them, then click the sorting method.
   
ArcMap sorts the fields based on the sort order.

Tip

You can sort records using up to three fields in ascending or descending order.

Grouping records

1. Click the Grouping tab on the Report Properties dialog box.
   
2. Double-click the field you want to use to group data.
   
3. Click Grouping Intervals and click the method for grouping data.
   
4. Click Ascending or Descending for the sort method.
   
5. Check Include Group Fields to repeat the group value in the report display.
   

Calculating summary statistics

1. Click the Summary tab on the Report Properties dialog box.
   
2. Click the Available Sections drop-down arrow and click the section where you want the statistics to appear.
   
3. Check the box that corresponds to the statistic you want to display for each numeric field.
   
4. Repeat steps 2 and 3 to display statistics in each available section.
   

Tips

You can compute the average, count, minimum, maximum, standard deviation, and sum for any numeric fields on your report. You can display summary statistics for a field at the end of the report, at the end of each page, and at the end of each group you've defined. To make the data in your reports easier to read, you can shade every other record with a color.

Please visit the Feedback page to comment or give suggestions on ArcGIS Desktop Help.
Copyright © Environmental Systems Research Institute, Inc.