1 / 6

Summarize By:

Summarize By:. January 8, 2003 Train the Trainer Cary Bidot, South Puget Sound. Summarize By:. The SUMMARIZE BY prompt calls for the numbers of the sort fields you want to use as control breaks.

caldwell-humphrey
Download Presentation

Summarize By:

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Summarize By: January 8, 2003 Train the Trainer Cary Bidot, South Puget Sound

  2. Summarize By: • The SUMMARIZE BY prompt calls for the numbers of the sort fields you want to use as control breaks. • A break point occurs when a sort field value changes and is a place where you may want to perform functions (eg: subtotal, count, average, minimum, maximum) on certain fields. • The sort field numbers can be entered in any order, separated by commas, and you may include a '0' (zero) to indicate that a grand (total report) summary line is also required.

  3. Type of Summary Functions: The field number may be followed by a suffix indicating the type of summary function: • '*' for subtotal (default if no suffix) • 'C' for count • 'A' for average • 'L' for low (minimum) • 'H' for high (maximum) • 'E' for last value (ending). A field can have more than one summary function specified, for example: '3,4,4C,1L,5A,1H'.

  4. Break Point

  5. Summary Functions

  6. Finished Report Summary Functions Break Point

More Related