<<< Go back to Public Class Schedule Page

Extended Lab Session is a post Lab environment for 10 hours over 28 days that allows the student access to the course lab and all the work they did in the course. Must be purchased when the course is purchased for an additional $250 (WebFOCUS) & $350 (iWay/Omni-Gen) per student session prior to class.


Course Description


Extending WebFOCUS with the Core Language V8.2

Course 105  |  CEUs:  1.2  |  2 days
US $1300  Canada $1300

Class Schedule
November 1st, 2017OnlineEnroll
November 20th, 2017BostonEnroll
December 12th, 2017OnlineEnroll
January 16th, 2018OnlineEnroll
March 7th, 2018DetroitEnroll
March 13th, 2018OnlineEnroll

    Are you familiar with the WebFOCUS graphical user interface, but need to know more about the underlying code that gets generated from your actions? Do you need to understand FOCUS/WebFOCUS reports you have inherited? With this course, you will learn the basic syntax contained in a FOCUS or WebFOCUS report request.

    Learn to make changes to a report that needs minor adjustments, quickly and more easily. In many instances, it might be easier to manually change the code rather than navigating through a series of menu pull-downs and window buttons.

    You will learn how to:

    • Understand the syntax of the FOCUS language
    • Comprehend WebFOCUS processing of requests
    • Create detailed (PRINT) and summary reports (SUM)
    • Control the order of data (BY, ACROSS)
    • Style reports (STYLE file, HEADINGS, FOOTINGS)
    • Understand Date Formats to change the way they are displayed.
    • Create compound Data Selection using WHERE clause
    • Calculate detail and summed values using DEFINE and COMPUTE
    • Display group and grand totals (Subtotal, Row-Total, Column-Total)
    • Place data from multiple files into one report (JOIN)
    • Save data in Excel, Active Report, and PDF formats
    • Add flexibility to your report request with variables (Dialogue Manager)
    • Consider relational reporting efficiencies (SQL tracing)

    Who should take this class:

    FOCUS and WebFOCUS developers who wish to learn the FOCUS reporting language.

    

    Prerequisites:

    No Requirements