How can you produce highly complex reports, and run them more efficiently in your business environment? With this course, you'll learn techniques to think critically about a business reporting need and translate it to a very productive FOCUS request. You will also be able to look at existing reports and eliminate needless processes.

• Decide which commands should be used in a specific situation
• Display detailed information based on a summary value
• Control the exact order of data to be displayed
• Work efficiently with reports on pre-sorted data
• Compare current to previous field values to control calculations and displays
• Calculate new values based on subtotal values
• Rank and group data automatically or manually
• Generate summary information when specific conditions are met
• Sort aggregated data without creating a hold file
• Use complex screening techniques
• Create row-oriented reports instead of traditional column-oriented reports
• Create missing data for a report
• Manipulate date formatted fields
• Report on data in independent paths
• Match and merge files for reports
• Efficiently join different types of databases
• Work with Relational Database Management Systems (RDBMS)
• Select data from one source, based on conditions from another source, without joining or matching the files

Developers working with FOCUS and WebFOCUS who want to increase their knowledge of the FOCUS reporting language.

• Course 102, Basic Reporting

• Course 210, Advanced Reporting
• Course 402, Reporting Concepts for Relational Databases