Focus Help Topics
New Business Intelligence Features in WebFOCUS
Java
I
Java
II
Oracle
I
Oracle
II
WebFocus Architecture
Year 2000 Issues for Focus Users
Using "Smart Dates" - New in Version 7.0.8
Dynamic Allocation of a Data Set
Specifying Selection Criteria
Sorting
Using Variables in Focus Programs
Using the supplied DEFINEd fields
Checking the length of an alphanumeric field
Using an EDIT mask
Inserting the date and time into a report heading
Concatenation
Parsing names: part 1
Parsing names: part 2
Including user-entered data in a series of Focexec's (CRTFORM)
Working with Calculations in Focus
Calculating the span between two dates
SUBTOTAL vs SUB-TOTAL
The difference between
DEFINE
and
COMPUTE
Getting the subtotal number on the same line as the SUBTOTAL label
Field prefixes
Displaying a
COUNT
of records in a grouped listing
Using
COUNT
when there are multiple records per person
Formatting Reports
Report Titles
Page headings
Page footings
Subfoot and Subhead
Centering
Embedding fields in headings and footings
Positioning text - skipping lines and skipping spaces
Using
IN
to position report columns
Using embedded fields in a subfoot to summarize data
Using
UNDER-LINE
and
SKIP-LINE
to separate report groups
Using the
ON sortfieldname
clause
Positioning fields with
IN
and
OVER
Decoding field values
Continuing Focus commands to more than one line
Miscellaneous Topics
PREVIEW
- Running a Focus program against a limited number of records
Using
JOIN
to extract english translations of JOB_CLASS data (example of JOIN)
Using a defined field to
JOIN
files
Using ISIS System Tables
Using
MATCH
to extract english translations of JOB_CLASS data (example of MATCH)
MATCH
logic
The tricky
SET ALL
parameter
Suppressing page-breaks
Changing/Suppressing column titles
Matrix style summary reports
Reserved words and other words to avoid when programming
Using Order fields with repeating segments
The order in which Focus processes commands
Sample Focus programs available to all users
Focus programs provided by Integral, Inc. as part of HRS
Difference between
IF
and
WHERE
Concatenating multiple files into a single file
SHELPROF
, the Autoexec.bat file of Focus
How to download a file using Attachmate/ASIVT
How to download a file using Super Send & Receive (SSR)
Some of the enhancements in Focus 7.0
Using TED to Create/Edit Focus Programs
TED Cheat Sheet
(a PDF document)
TEDPROF - the TED profile
Inserting lines
Deleting lines
Recovering deleted lines
Changing the "current" line
Duplicating lines
Moving/copying lines
Splitting the TED screen
Splitting/joining lines
Locate text
Locate and replace text
Command prompt commands: SAVE, FILE, RUN