FOCUS 151 & 160
FOCUS 151 - Reporting for New Users
Duration
Two Days
Topics Include
- Introduction to FOCUS Six Reporting
- Creating application folders
- Structuring reports
- Creating summary and detailed reports
- Limiting report contents
- Changing column titles
- Specifying page headings and footings
- Displaying reports
- Styling reports using fonts and colors
- Using special features/customized field placements
- Creating meaningful graphs
- Storing and executing procedures
- Highlighting report results conditionally with custom colors, fonts, and type sizes
FOCUS 160 - Advanced Reporting Techniques
Duration
Two Days
Topics include
- User -written subroutines that make complex reporting easy
- Extracting words from data fields
- Creating random numbers and using them as selection criteria
- Advanced reporting techniques
- Producing multiple reports from one pass of the database
- Setting up and using counters to find the median value of a field
- Printing a record more than once in a report
- Exception reporting
- Creating EIS-like reports with drill-downs
- Ranking and grouping data
- Managing reporting from multiple files
- Merging data files
- Creating flags for complex screening
- Testing methodologies
Can be used to enhance or supplement SAM II, DW610 Data Warehouse - Using FOCUS.
