Reporting Language Primer
Launch PDF file
Creating Basic Output Requests
Creating Basic Reports
Types of Output Requests
Before You Begin
Identifying Data for Use in Reports
Presenting Data Values: Verbs
Manipulating Display Fields With Prefix Operators
Manipulating Display Field Values in a Sort Group
Naming Columns: Field Names and AS
Creating a Stored Request
Sorting Records
Sorting the Rows of a Report Down the Page
Sorting on Several Fields
Sorting Information Across the Page
Creating a Matrix Using BY With ACROSS
Changing the Order of the Sorting
Ranking Sort Field Values
Limiting Sort Field Values
Hiding a Field
Clustering Numeric Data Into Groups
Selecting Records
Describing Screening Conditions
Screening Numeric Data
Screening Alphanumeric Data
Screening Alphanumeric Content
Limiting Records Retrieved: RECORDLIMIT
Using Temporary Fields
Creating a Temporary Field Using the COMPUTE Command
Combining Two Alphanumeric Fields Into a New Field
Using Temporary Fields With DEFINE
Extracting Part of the Text From an Alphanumeric Field
Decoding the Characters in an Alphanumeric Field
Creating Subtotals and Grand Totals
Creating Column and Row Totals
Adding Section Totals and Grand Totals to Reports
Suppressing Grand Totals: NOTOTAL
Displaying Subtotals Conditionally: WHEN
Calculating Values Based on Subtotals: RECAP
Formatting Reports
Headings and Footings: Types You Can Use
Including a Page Heading in a Report: HEADING
Including a Page Footing in a Report: FOOTING
Including a Section Heading in a Report: SUBHEAD
Including a Section Footing in a Report: SUBFOOT
Adding Blank Lines Between Sorted Records: SKIP-LINE
Separating Sorted Records With an Underline: UNDER-LINE
Creating a New Page: PAGE-BREAK
Introducing Formatting and Style Sheets
What Kinds of Formatting Can I Do?
What is a StyleSheet?
General StyleSheet Syntax
Conditionally Formatting a StyleSheet
Merging Data Sources
Including Data From More Than One File: JOIN
Merging Data: MATCH
Concatenating Data: MORE
Advanced Features
Using Multiple Verb Commands in Requests
Extracting Data Into a File
Presenting Data in a Matrix: Financial Modeling Language
Customizing Your Environment Using SET Commands
Data Sources and Master Files
Reporting Language Syntax Summary
Glossary