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.

You Will Learn How To:

	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

Who Should Take This Course:
Users and developers working with FOCUS and WebFOCUS (Windows and Browser versions) who want to increase their knowledge of the FOCUS reporting language.

Prerequisite:

Course 102