Black Box 4/BlackBox.cdr/demos/cdevdemo.arj/TRPT.HLP

Clarion Help | 1990-11-13 | 84.8 KB | 1,814 lines

 Suppose that we want to view only those
 people whose first name begins with the
 letter "T."
 You can use the Choose action to create
 a report filter.  A report filter
 selects only the records you specify by
 writing a condition.
 The Choose action lets you create error-free
 conditions, since you select valid choices
 from windows that pop up.
 The Function List contains built-in functions
 such as UPPER (makes characters uppercase), TODAY
 (displays today's date), and INSTR (searches for
 a string).
 Constant Text allows you to enter text.
 Constant Number allows you to enter a number.
 Constant Date and Constant Time allow you
 to enter a valid date or time.
 To create a condition, select the elements
 that will make up the equation or expression.
 Since we want to choose all the records where
 "the first name BEGINS WITH the letter T," we
 will start by selecting the field EMP:FIRST.
 OK, our first element is selected.
 Remember, we want all records where
 EMP:FIRST BEGINS WITH the letter "T,"
 so let's scroll down the list to find
 the operator BEGINS WITH.
 Here it is; press Enter to select it.
 Let's select our final element
the letter "T."
 We'll select Constant Text and type the letter T.
 We could continue this condition by selecting
 an operator, but we'll finish it here by
 selecting DONE.
 This is a simple condition.  More complex
 conditions can be created with the use of
 parentheses, functions, and more fields.
 Now let's run the report with its new report
 filter.
 Press Esc to call the worksheet menu.  Select
 Run.  Then select Screen to run the report
 as a query (displayed on your monitor).
 Notice that the only records
 displayed are those whose first
 name begins with "T."
 Say, for instance, you want to print the
 word **BONUS next to every employee who
 makes over $40,
 a year.
 To do this, you would make a Conditional
 field, one of the Calculated fields.  Select
 Field from the menu; then select Calculated.
 This screen shows us all the Calculated fields
 currently defined.  None have been defined yet,
 but we are going to make one now.  Select the
 Create action.
 Conditional fields allow you to print
 or display different values depending
 on whether a particular condition is
 true or false.
 In this case, we want to print either
 **BONUS or blank spaces depending on
 whether the employee's salary is
 greater than $40,
 First, we need to give our Conditional
 field a name, or Description.
 Now we have to assemble the condition,
 just as we did when we made a report
 filter with the Choose action.
 OK, we need to tell Report Writer
 what to do if the condition is True.
 We'll have it print "**BONUS."
 Since "**BONUS" is text, select
 Constant Text.
 If the condition is false, we won't print
 anything next to the employee's name.
 So, for the False Formula line, select
 Constant Text, press Enter and select DONE.
 Since there are seven chararacters in
 **BONUS, the picture will be S7.
 Now we have finished defining our Conditional field.
 Notice that it is now listed in the Calculated field
 window.
 The selector bar
 highlights the
 current report.
 It can be moved
 with the Up
 and
 Down
 keys to
 highlight the
 report you want to
 Run, Modify, or
 Erase.
 Now that you know how to control the tutorial, let's
 begin.
 To continue, please press
[M] for manual,
[A] for automatic, or
[Esc] to return to DOS.
 This concludes the Report Writer Tutorial.
 This screen is called a worksheet.  This is where
 you design your reports by placing fields, text,
 and lines where you want them to appear.
 When you first enter a worksheet, you are in
 automatic "populate report" mode.  This means that
 Report Writer will automatically place the fields
 you select from the popped-up Field window on
 the worksheet.
 The Body section contains the
 "meat" of the report.
 The Grand Totals section prints
 after all groups have printed.
 The Final Page section prints
 on the last page of the report.
 The Page Footer section prints
 at the bottom of each page.
 Let's set up this report so that the employee records are
 "grouped" by common states.  We'll make the EMP:STATE
 field a sort field.  A sort field is a field whose value
 determines how records will be ordered.
 So, to sort and process the records in your report in a
 a particular sequence, designate sort fields.  This is
 called "ordering" the fields in your database.  To set a
 sort order, select Order from the worksheet menu.
 First, we want to sort the data stored
 in the state field in ascending order,
 from A to Z.  Highlight both Ascending
 and EMP:STATE; then press Enter.
 The fields will be placed horizontally in the
 Body.  A "header" that describes the field
 will also be automatically placed in a
 corresponding position in the Page Header
 section.  Now we will select our fields
 Designating EMP:STATE as an ascending sort field will sort the
 records alphabetically by state.  To include additional
 information specific to each state, you need to make this sort
 field a group field as well.  Report Writer will create a
 Group Header and Group Footer for each group field you designate.
 To designate a sort field as a group field, select Edit and then
 select Group.
 Designating EMP:STATE as an ascending sort field will sort the
 records alphabetically by state.  To include additional
 information specific to each state, you need to make this sort
 field a group field as well.  Report Writer will create a
 Group Header and Group Footer for each group field you designate.
 To designate a sort field as a group field, select Edit and then
 select Group.
 Good, now EMP:STATE is designated as a group
 field.
 While we're here, let's sort within each state
 by the person's last name (EMP:LAST).  This is
 done in the same way that you established the
 order for EMP:STATE, except we do not need to
 make a group by last name.
 Highlight EMP:LAST and Ascending; press Enter.
 That's all we need to do for the Order.
 Press Esc to see our modified worksheet.
 Notice the new group sections.  The field name
 is placed on the left side of the grid line.
 If we had made more group fields, they also
 would have their own separate group sections
 along with the field name.
 When you designate more than one group field,
 the first group field you designate (at the
 top of the Order list) will have the "outermost"
 group sections on the worksheet, while the last
 one designated will have the "innermost" group
 sections.
 Let's display the EMP:STATE field in
 the Group Header section, so it will
 print before each group.
 First, with the cursor on the Group
 Header line, press Enter to open up
 the group section.
 Press Esc; then select Field from the menu.
 Select Data to put a data field on
 the worksheet.
 Select EMP:STATE from our field list
 A picture is a code that tells Report Writer
 how to format the data in the field.  We'll press
 Enter to accept the default picture.
 You can center text on a line
 by pressing Ctrl-6.
 Think of the caret ^ (located
 on the "6" key) as the symbol
 for centering.
 OK.  Now that we have our necessary fields
 on the worksheet, we'll exit the automatic
 "populate report" mode by pressing Esc and
 enter the "free-form" mode to finish up.
 Free-form mode allows you to manually change,
 add or remove anything on the worksheet.
 Underline the state using the Trace
 action.  Instead of selecting Trace
 from the menu, you can use Ctrl-T
 as a shortcut.
 The last thing we have to do is add two blank lines to the Group
 Footer so that the different groups (states) will be separated.
 To do this, move the cursor to the EMP:STATE Group Footer line
 and press Enter twice.
 Let's stop here and see how our
 report looks.
 Bring up the menu with Esc and
 then select Run.
 Here is a brief description of the worksheet menu actions:
- Run your report.  You can print it, display it as
a query, or send it to a disk file.
 Choose
- Set a condition that selects specific records.
This condition is called a report filter.
 Order
- Sort the data in your report by selecting sort
fields and group fields.
 Layout
- Set the report width and length, send formfeeds,
specify label printing, and re-set page numbers.
 Trace
- Draw lines, boxes, etc. on the worksheet.
 Field
- Place fields from the database on the worksheet;
also create new fields called Calculated fields.
 Edit
- Cut, copy, or move blocks within your report; also
insert printer control codes.
 Password - Assign a password for this report.
 Specs
- Print a specifications report.
 Quit
- Exit to the Report Page.
 Notice that when the cursor
 moves over a field, the field
 name appears here.
Anything
placed
Title
section will print only
first
page.
 The Page Header section prints
 at the top of each page.
 Now that we have seen this report, let's return
 to the worksheet (by pressing Esc) and modify the
 report.  Then, we'll run it again.
 Choose Records Where
Function List
Constant Text
Constant Number
Constant Date
Constant Time
EMP:RECORD#
EMP:FIRST
 EMP:LAST
Title Page 0:1
 'LIN OVR
 ,Press Esc for menu or F1 for Help
 Choose Records Where
 EMP:FIRST +
+ Plus
- Minus
/ Divide
* Multiply
% Modulus
& Concatenate
= Equals
<> Not Equals
 >  More Than
Title Page 0:1
 'LIN OVR
 ,Press Esc for menu or F1 for Help
 Choose Records Where
 EMP:FIRST BEGINS WITH
  Type Text:|
- Final Page
Title Page 0:1
 'LIN OVR
 ,Press Esc for menu or F1 for Help
 Choose Records Where
 EMP:FIRST BEGINS WITH 'T' +
+ Plus
- Minus
/ Divide
* Multiply
% Modulus
& Concatenate
Title Page 0:1
 'LIN OVR
 ,Press Esc for menu or F1 for Help
First
Phone
 %Frank
Askowitz
[phone]
Bircham
[phone]
Claire
Buscemi
(904)
-9104
George
Duffy
[phone]
Linda
Johnston
[phone] **BONUS
George
Linstein
(904)
-4848
Joe Bob
     Nantucket
[phone] **BONUS
Olsen
[phone]
Thomas
Parker
[phone] **BONUS
Peterson
[phone] **BONUS
Dianne
Trender
[phone] **BONUS
Betty
Underhill
[phone]
Waysworth
[phone]
Karen
Wetson
[phone]
 %lines 1:22  cols 1:80
 WUse Cursor Keys to Scroll
Press F1 for Help
 +Press Esc to Cancel
Debbie
Accord
[phone]
Katie
Austin
[phone]
Karen
Blasidio
[phone] **BONUS
Ferris
Bueller
[phone] **BONUS
Lindy
Carter
[phone] **BONUS
Edwards
[phone] **BONUS
Michele
     Fox
[phone] **BONUS
Nordega
     Francisco
[phone]
Cristy
Franco
[phone]
Ralph
Greenburg
[phone]
Harper
[phone] **BONUS
Bruce
Harris
[phone] **BONUS
Johnson
[phone]
Kasper
[phone] **BONUS
Audrey
Laghlin
[phone]
Wayne
Marshall
[phone] **BONUS
Lewis
McCarther
[phone] **BONUS
Linda
[phone]
Brian
Nolan
[phone] **BONUS
O'connor
[phone]
Larry
Silverman
[phone]
Simmons
[phone]
lines 23:44  cols 1:80
 VUse Cursor Keys to Scroll
Press F1 for Help
 +Press Esc to Quit
Smith
[phone]
Pamela
Snyder
[phone] **BONUS
Tyrone
[phone]
Henry
Waysburgher
[phone]
Keith
Zachary
[phone]
[phone] **BONUS
 %Martha
Anderson
[phone] **BONUS
Brooks
[phone] **BONUS
William
     Fruite
[phone]
Steve
Kinsley
[phone] **BONUS
Robert
Lancaster
[phone] **BONUS
First
Phone
 &Tracy
Polvarich
[phone]
Michael
     Rosenthal
(212)
-4949 **BONUS
Singeltary
[phone]
lines 45:66  cols 1:80
 VUse Cursor Keys to Scroll
Press F1 for Help
 +Press Esc to Quit
Phone
 Body
The CLARION Report Writer
Databases
Invoice Database
Lesson Database
  Press F1 for Help
  Choose Database from List
" Title Page
C Page
Header
% Body
 EMP:TITLE
(String 4)
EMP:FIRST
(String 15)
EMP:LAST
(String 15)
EMP:ADDRESS
(String 30)
EMP:ADDRESS2  (String 30)
EMP:CITY
(String 15)
EMP:STATE
(String 2)
EMP:ZIP
(Long)
EMP:PHONE
(Decimal 11.0) (
EMP:DEPT
(String 10)
EMP:SALARY
(Real) $
,<<#.##
Body 1:1
 -LIN OVR
 'Press Enter to Select Field or Esc to Quit
Populate Report Method - Press Esc to Enter Free-form Method
First
" Title Page
C Page
Header
 First
Phone
% Body
! Grand  Totals
A Page
Footer
B Final Page
sBody 1:48
 ,LIN OVR
 ,Press Esc for menu or F1 for Help
 The Report Writer User's Manual explains these
 actions in detail.
 Now let's start a new report.  Select Create.
 The first thing you must do when creating
 a report is select the database that the
 report will get its data from.
 We'll select the Lesson Database.
 We'll use the Run action
 to see one of these reports.
 We could have just as easily sent this
 report to the printer or to a disk file
 by selecting either Printer or File
 from the menu.
First
Phone
 %Thomas
Parker
[phone]
 %Tish
O'connor
[phone]
 %Tracy
Polvarich
[phone]
 Plines 1:22  cols 1:80
 WUse Cursor Keys to Scroll
Press F1 for Help
 *Press Ctrl-Q to Quit
" Title Page
C Page
Header
 First
Field
EMP:STATE
  Name
:Bonus Field
  Pic
 EMP:LAST
     (String 15)
 EMP:STATE
EMP:TITLE
(String 4)
EMP:PHONE
(Decimal 11.0) (
EMP:STATE
(String 2)
EMP:CITY
     (String 15)
EMP:ADDRESS
(String 30)
EMP:ZIP
(Long)
EMP:DEPT
     (String 10)
EMP:SALARY
(Real) $
,<<#.##
EMP:ADDRESS2
(String 30)
EMP:COMPANYNAME  (String 30)
Bonus Field ( Conditional )
Body 1:52
 ,LIN OVR
Press Esc for menu or F1 for Help
" Title Page
C Page
Header
 First
Field
EMP:STATE
  Name
:Bonus Field
  Picture:S7
EMP:STATE
 Group  Footer
! Grand  Totals
A Page
Footer
B Final Page
Body 1:52
 ,LIN OVR
Press Esc for menu or F1 for Help
 Notice that the database we have just created,
 People database, now appears in the list of
 databases.
 Now select Quit to return to the Report Page.
The CLARION Report Writer
Creating New Database
Enter Filename
  Filename:C:\CLARION\PEOPLE.DAT
 DATABASE\
EXAMPLE\
REPORT\
TUTORIAL\
EMPLOYEE.APP
PEOPLE.DAT
RTLINK.DAT
TEST.APP
The CLARION Report Writer
Creating New Database
PEO:RECORD#  Record in PEOPLE.DAT (Long)
PEO:NAME
(String 20)
PEO:EXT
(Decimal 3.0)
PEO:DEPT
(String 6)
PEO:BLDG
(String 10)
  Record in PEOPLE.DAT
  Press F1 for Help
  Modify This Picture or Heading
 2Modify
Create
Password
Specs
The CLARION Report Writer
Creating New Database
Save Database
  Save Changes
  Database Name  :
  Definition File:
  Record in PEOPLE.DAT
  Press F1 for Help
  Exit Data Base Screen
 ;Modify
Create
Password
Specs
The CLARION Report Writer
Creating New Database
Save Database
  Save Changes
  Database Name  :People database
  Definition File:DBS
1.DEF
  Record in PEOPLE.DAT
  Press F1 for Help
  Exit Data Base Screen
 ;Modify
Create
Password
Specs
The CLARION Report Writer
Databases
Invoice Database
Lesson Database
People database
  Press F1 for Help
  Create a New Database
 ;Modify
Create
Erase
The CLARION Report Writer
Creating New Database
Enter Filename
  Filename:
  Press F1 for Help
The CLARION Report Writer
Databases
Invoice Database
Lesson Database
  Press F1 for Help
  Modify or Copy This Database
 4Modify
Create
Erase
 After you select Run, you are given a menu to
 select where to send the report.  You may send a
 report to the screen (a query), a file, or a
 printer.  You can also set printing options or
 produce a test pattern of your report.
 We will select Screen.
Display Report on the Screen
 4Screen
Printer
Options
 We'll select Screen to display the
 report as a query.
 After you have finished viewing the report,
 you can return to the worksheet by pressing
 the Esc key.
 To start the Clarion Report Writer
 Go to the directory where Report Writer is
 installed.  The default is \CLARION.
 Then, type REPORTER and press Enter.
 Exiting the Calculated field menu
 returns you to the Field menu.
 Select Data to place our newly-
 created field on the worksheet.
 Bonus Field is already highlighted,
 so simply press Enter.
 Press Enter to accept this picture.
 Good.  We now have our Conditional field
 placed on the worksheet.
 Let's see our report
 Here is PAGE 1 of our report.
 Notice that **BONUS is next to
 some entries; this is the
 Conditional field.  We'll press
 PgDn to see the next page
 Press PgDn again to see more
 This line denotes
 a new page.
 Here's our Page Header
 for the next page.
 On the Enter Filename line, you can either type the
 path and file name of the data file you want to use, or
 press Enter on the blank line to access a list of data
 files that you may select.
 We will press Enter on the blank line to bring up a list
 of files.  Then, we will select the PEOPLE.DAT file from
 the list that appears.
 Highlight the PEOPLE.DAT file and press Enter.
 Databases may be made up of one or more data files.  These
 data files may be Clarion, dBase, ASCII, or DIF files.
 If you want to use more than one data file in a database,
 you must join the files together by equating a common
 field.
 In this tutorial, we will use only one data file, the
 PEOPLE.DAT file, to create the People database.
:EMP:RECORD#
EMP:RECORD#
Record in EMPLOYEE.DAT (Long)
EMP:TITLE
(String 4)
EMP:FIRST
(String 15)
EMP:LAST
(String 15)
EMP:ADDRESS
(String 30)
EMP:ADDRESS2  (String 30)
EMP:CITY
(String 15)
EMP:STATE
(String 2)
EMP:ZIP
(Long)
EMP:PHONE
(Decimal 11.0) (
EMP:DEPT
(String 10)
EMP:SALARY
(Real) $
,<<#.##
Field
  Name
:EMP:STATE
  Picture:S2
  Now that you have reviewed the Report Writer environment,
  we suggest that you read Chapter 2 of the User's Manual,
  and do the lessons outlined in Chapter 3.
  You'll soon see how easy and fun it is to create your
  own reports with the Clarion Report Writer!
" Title Page
C Page
Header
 First
Phone
 &EMP:STATE
 Group  Header
% Body
 "EMP:STATE
 Group  Footer
! Grand  Totals
A Page
Footer
B Final Page
EMP:STATE 2:1
 (LIN OVR
 ,Press Esc for menu or F1 for Help
" Title Page
C Page
Header
 First
Phone
 &EMP:STATE
 Group  Header
% Body
EMP:STATE
 Group  Footer
! Grand  Totals
A Page
Footer
B Final Page
Title Page 0:1
 'LIN OVR
Print or View This Report
 7Run
Choose
Order
Layout
Trace
Field
Password
Quit
 Display a Data Field
 <Data
System
Calculated
 This is the Page Header.
 This is the Body of the report.
 This is the Group Header for the EMP:STATE field.
 And these two blank lines are from the EMP:STATE Group Footer.
 Here is our final report.  Let's
 review each of its components
 Specify Group Break and set Group Options
 'Group
Erase
First
Phone
 $Frank
Askowitz
[phone]
 "Ely
Bircham
     [phone]
 "Claire
Buscemi
     (904)
-9104
 "George
Duffy
[phone]
 "Linda
Johnston
[phone]
 "George
Linstein
(904)
-4848
 "Joe Bob
     Nantucket
[phone]
 "Don
Olsen
[phone]
 "Thomas
Parker
[phone]
 "Joan
Peterson
[phone]
 "Dianne
Trender
     [phone]
 "Betty
Underhill
[phone]
 "Nell
Waysworth
[phone]
 "Karen
Wetson
[phone]
 $lines 1:22  cols 1:80
 WUse Cursor Keys to Scroll
Press F1 for Help
 +Press Esc to Cancel
 How to run this Tutorial
 You can change the viewing mode at any time by pressing
 for Manual
 for Automatic
 In either viewing mode
     the right arrow key
  turns to the next page, and
     the left arrow key
  turns to the previous page.
 How to run this Tutorial (continued)
 In manual viewing mode, the tutorial waits for you to press one of the
page turning keys.
 In automatic viewing mode, the tutorial gives you time to read a page,
then turns to the next page automatically.
You can speed up the tutorial by
pressing the gray + key
slow down the tutorial by
pressing the gray - key.
You can exit a tutorial by
pressing the Esc key.
 This is Report Writer's main screen, which is
 called the Report Page.
 Report Writer has been designed as a menu-driven
 program.  All of its powerful features can be
 accessed via the main actions listed horizontally
 in the menu on the bottom of the Report Page.
 Print or View This Report
 7Run
Choose
Order
Layout
Trace
Field
Password
Specs
Quit
 Move down to highlight the First Name field and
 press Enter.
 Move down to highlight the Phone Number
 field and press Enter.
" Title Page
C Page
Header
 First
Phone
 &EMP:STATE
 Group  Header
E Body
 "EMP:STATE
 Group  Footer
A Grand  Totals
A Page
Footer
B Final Page
#Body 1:48
 ,LIN OVR
 ,Press Esc for menu or F1 for Help
Welcome to the tutorial for
The Clarion Report Writer
 Before starting, there will be a few screens explaining
 how to change the pace of the information provided in
 this tutorial.  After that, you will see some of the
 things that Report Writer can do for you!
" Title Page
C Page
Header
 First
Phone
% Body
! Grand  Totals
Order
Sort Group
Field List
 3EMP:RECORD#
Record in
 3EMP:TITLE
(String 4)
 3EMP:FIRST
(String 15
 3EMP:LAST
(String 15
 3EMP:ADDRESS
(String 30
 3EMP:ADDRESS2  (String 30
 EMP:CITY
(String 15
Body 1:48
 ,LIN OVR
Select Field as Ascending Component
 -Ascending
Descending
Reset
 The last thing we'll do in this tutorial is select
 the printer that you are using and assign it to a
 DOS port (LPT1, LPT2 or LPT3).
 When you select your printer, you import a printer
 control file that contains the printer control
 codes associated with your particular printer.
 When this file has been imported, you can then
 place printer codes in your reports using the
 Edit action on the worksheet.
 To select your printer and assign it to a DOS
 port, select Printer from the Report Page menu.
The CLARION Report Writer
Printers
GENERIC PRINTER
  Press F1 for Help
  Import Printer Model from Another File
 *Import
Assign
Modify
Create
Erase
 Modify control sequences.
 oModify Control Sequences for This Printer Model
 !Import
Assign
Modify
Create
Erase
The CLARION Report Writer
Printers
GENERIC PRINTER
HEWLETT PACKARD LASERJET II
  Press F1 for Help
  Add a New Printer Model
 9Import
Assign
Modify
Create
Erase
The CLARION Report Writer
Printers
GENERIC PRINTER
HEWLETT PACKARD LASERJET II
  Press F1 for Help
  Erase This Printer Model
 8Import
Assign
Modify
Create
Erase
The CLARION Report Writer
Printers
GENERIC PRINTER
HEWLETT PACKARD LASERJET II
  Press F1 for Help
  Exit to the Report Menu
 9Import
Assign
Modify
Create
Erase
The CLARION Report Writer
Printers
GENERIC PRINTER
Import Printer Model from Another File
  Filename:
  Press F1 for Help
  Import Printer Model from Another File
 *Import
Assign
Modify
Create
Erase
*.CTL
DATABASE\
EXAMPLE\
REPORT\
TUTORIAL\
GENERIC
LASER.CTL
MATRIX.CTL
PRINTER.CTL
REPORTER.CTL
Import
other File
  Filename:C:\CLARION\LASER.CTL
  Press F1 for Help
  Import Printer Model from Another File
 *Import
Assign
Modify
Create
Erase
The CLARION Report Writer
     Printers Available to Import
CANON BJ-80
HEWELETT PACKARD THINKJET
HEWLETT PACKARD LASERJET II
HEWLETT PACKARD QUIETJET
IBM COLOR JETPRINTER 3852-2
IBM PAGEPRINTER 3812
IBM QUIETWRITER 5201
LASERJET CARTRIDGE A
LASERJET CARTRIDGE B
LASERJET CARTRIDGE C
 LASERJET CARTRIDGE D
  Press F1 for Help
  Import Highlighted Printer Model
 0Import
The CLARION Report Writer
     Printers Available to Import
CANON BJ-80
HEWELETT PACKARD THINKJET
HEWLETT PACKARD LASERJET II
HEWLETT PACKARD QUIETJET
IBM COLOR JETPRINTER 3852-2
IBM PAGEPRINTER 3812
IBM QUIETWRITER 5201
LASERJET CARTRIDGE A
LASERJET CARTRIDGE B
LASERJET CARTRIDGE C
 LASERJET CARTRIDGE D
  Press F1 for Help
  Import Highlighted Printer Model
 0Import
The CLARION Report Writer
     Printers Available to Import
CANON BJ-80
HEWELETT PACKARD THINKJET
HEWLETT PACKARD QUIETJET
IBM COLOR JETPRINTER 3852-2
IBM PAGEPRINTER 3812
IBM QUIETWRITER 5201
LASERJET CARTRIDGE A
LASERJET CARTRIDGE B
LASERJET CARTRIDGE C
LASERJET CARTRIDGE D
 LASERJET CARTRIDGE E
  Press F1 for Help
  Exit from This Menu
 =Import
The CLARION Report Writer
Printers
GENERIC PRINTER
HEWLETT PACKARD LASERJET II
  Press F1 for Help
  Import Printer Model from Another File
 *Import
Assign
Modify
Create
Erase
The CLARION Report Writer
Printers
GENERIC PRINTER
HEWLETT PACKARD LASERJET II
  Press F1 for Help
  Assign This Printer Model to a Computer Port (or Unassign from a Port)
Import
Assign
Modify
Create
Erase
The CLARION Report Writer
Printers
GENERIC PRINTER
HEWLETT PACKARD LASERJET II
  Press F1 for Help
  Choose Printer Port
 =LPT1
The CLARION Report Writer
Printers
GENERIC PRINTER
HEWLETT PACKARD LASERJET II
  Press F1 for Help
  Assign This Printer Model to a Computer Port (or Unassign from a Port)
Import
Assign
Modify
Create
Erase
 Notice that LPT1 now appears next to the printer
 name on the Printer list.
 Now select Quit to return to the Report Page.
 This is the Printer Page.  A list of printers appears in
 center of the page.  On the bottom of the screen, there is
 a menu containing six actions.  They are:
 Import -  Add your printer to the list of printers in the
center of this page.
 Assign -  Select the DOS device attached to your printer.
 Modify -  Edit printer control sequences.
 Create -  Add a printer model to the list (assuming that
you cannot locate it using Import).
 Erase  -  Delete a printer from the printer list.
 Quit
-  Exit to the Report Page.
 If this is the first time you are running Report Writer,
 only one printer will be on the list of printers in the
 center of this page: Generic Printer.
 Select Import to choose your printer.
 A window appears that allows you to type the name of
 your printer's control file.  You may also press Enter
 on the blank Filename line to get a list of available
 printer control files.
 We will press Enter on the blank Filename line.
 A list of printer control files in the current directory
 appears.  LASER.CTL contains the printer control files
 for various laser printers.  MATRIX.CTL contains the
 printer control files for various matrix printers.
 Let's assume that you have a laser printer.  Highlight
 LASER.CTL and press Enter.
 A list of laser printers appears.  You can scroll
 throught this list to find the name of the printer
 you are using.  Highlight your printer, then press
 Enter.
 Suppose you are using a Hewlett Packard Laserjet II.
 Highlight the printer name and press Enter.
 This action imports a file containing this printer's
 control sequences.  Report Writer stores this file
 in your PRINTER.CTL file.
 Now that we have selected our printer,
 let's assign a DOS port to it.
 Select Assign.
 A menu appears that allows you to choose:
 LPT1, LPT2, LPT3, or None.
 Highlight LPT1 and press Enter.
" Title Page
First
Calculated Fields
EMP:STATE
EMP:STATE
  Press F1 for Help
  Create a New Calculated Field
 3Modify
Create
Erase
" Title Page
First
Calculated Fields
Conditional Field
  Description  :Bonus Field
  If Condition :EMP:SALARY > 4
  True Formula :'**BONUS' +
  False Formula:
  Picture
+ Plus
- Minus
/ Divide
* Multiply
% Modulus
 & Concatenate
  Press F1 for Help
LIN OVR
     CAP
  Press Esc for menu or F1 for Help
" Title Page
First
Calculated Fields
Conditional Field
  Description  :Bonus Field
  If Condition :EMP:SALARY > 4
  True Formula :'**BONUS'
  False Formula:
  Picture
 - Minus
/ Divide
* Multiply
% Modulus
& Concatenate
  Press F1 for Help
LIN OVR
     CAP
  Press Esc for menu or F1 for Help
First
Function List
Constant Text
Constant Number
Constant Date
  Description  :Bo
Constant Time
  If Condition :LE
EMP:RECORD#
 EMP:FIRST
  True Formula :'*
  False Formula:(
  Picture
  Press F1 for Help
LIN OVR
     CAP
  Press Esc for menu or F1 for Help
" Title Page
First
Calculated Fields
Conditional Field
  Description  :Bonus Field
  If Condition :EMP:SALARY > 4
  True
  Type Text:|
  False
  Picture
  Press F1 for Help
LIN OVR
     CAP
  Press Esc for menu or F1 for Help
First
+ Plus
- Minus
/ Divide
* Multiply
% Modulus
  Description  :Bonus Fiel
& Concatenate
  If Condition :EMP:SALARY
  True Formula :'**BONUS'
  False Formula:'' +
  Picture
  Press F1 for Help
LIN OVR
     CAP
  Press Esc for menu or F1 for Help
" Title Page
First
Calculated Fields
Conditional Field
  Description  :Bonus Field
  If Condition :EMP:SALARY > 4
  True Formula :'**BONUS'
  False Formula:''
  Picture
  Press F1 for Help
LIN OVR
     CAP
  Press Esc for menu or F1 for Help
" Title Page
First
Calculated Fields
Conditional Field
  Description  :
  If Condition :
  True Formula :
  False Formula:
  Picture
  Press F1 for Help
 7Press Esc for menu or F1 for Help
" Title Page
First
Calculated Fields
Conditional Field
  Description  :Bonus Field
  If Condition :(
  True Formula :
  False Formula:
Function List
  Picture
Constant Text
Constant Number
Constant Date
Constant Time
EMP:RECORD#
 EMP:FIRST
  Press F1 for Help
 7Press Esc for menu or F1 for Help
" Title Page
First
Calculated Fields
Conditional Field
  Description  :Bonus Field
  If Condition :EMP:SALARY +
  True Formula :
  False Formula:
+ Plus
- Minus
  Picture
/ Divide
* Multiply
% Modulus
& Concatenate
= Equals
 <> Not Equals
  Press F1 for Help
 7Press Esc for menu or F1 for Help
" Title Page
First
Calculated Fields
Conditional Field
  Description  :Bonus Field
  If Condition :EMP:SALARY >
  True
  Type Number:
0.00
  False
  Picture
  Press F1 for Help
 7Press Esc for menu or F1 for Help
" Title Page
First
Calculated Fields
Conditional Field
  Description  :Bonus Field
  If Condition :EMP:SALARY > 4
  True Formula :
  False Formula:
+ Plus
- Minus
  Picture
/ Divide
* Multiply
% Modulus
& Concatenate
  Press F1 for Help
 7Press Esc for menu or F1 for Help
" Title Page
First
Calculated Fields
Conditional Field
  Description  :Bonus Field
  If Condition :EMP:SALARY > 4
  True Formula :
  False Formula:
 - Minus
/ Divide
  Picture
* Multiply
% Modulus
& Concatenate
  Press F1 for Help
 7Press Esc for menu or F1 for Help
" Title Page
First
Calculated Fields
Conditional Field
  Description  :Bonus Field
  If Condition :EMP:SALARY > 4
  True Formula :(
  False Formula:
  Picture
Function List
Constant Text
Constant Number
Constant Date
 Constant Time
  Press F1 for Help
 7Press Esc for menu or F1 for Help
" Title Page
First
Calculated Fields
Conditional Field
  Description  :Bonus Field
  If Condition :EMP:SALARY > 4
  True
  Type Text:|
  False
  Picture
  Press F1 for Help
 7Press Esc for menu or F1 for Help
The CLARION Report Writer
Sample 1: Acme Sales
Sample 2: Groups
Sample 3: Invoice
  Press F1 for Help
  Print or View This Report
 7Run
Modify
Create
Erase
Database
Printer
Options
G$KK@
 All available
 reports are
 listed in this
 area.
 The bottom line is a menu containing eight actions.
 Select Create to make a new report.
 To change or create databases, select Database.
 Erase will delete the highlighted report.
 Modify allows you to change the highlighted report.
 You can change some of Report Writer's defaults with Options.
 To assign or configure your printer, select the Printer action.
 The Quit action exits Report Writer.
 The Run action "runs" the highlighted report.
The CLARION Report Writer
Sample 1: Acme Sales
Sample 2: Groups
Sample 3: Invoice
Bonus Report
  Press F1 for Help
  Create a New Report
 =Run
Modify
Create
Erase
Database
Printer
Options
G$KK@
 This is the report
 that is currently
 highlighted.
 Choosing the Run action will execute
 (or run) the highlighted report.
17:14
Acme Sales Commission Report
3/12/1990
 sNAME
COMMISSION
PState: CA
 ZAskowitz, Frank
 'Bircham, Ely
 'Buscemi, Claire
 'Duffy, George
 'Johnston, Linda
 *Bonus*
Linstein, George
 'Nantucket, Joe Bob
 *Bonus*
Olsen, Don
$18,500
 'Parker, Thomas
 *Bonus*
Peterson, Joan
 *Bonus*
Trender, Dianne
 *Bonus*
Underhill, Betty
 'Waysworth, Nell
lines 1:22  cols 1:80
 WUse Cursor Keys to Scroll
Press F1 for Help
 ,Press Esc to Cancel
 When the first page of the
 report appears, you can use
 the cursor keys (Up, Down,
 PgUp, PgDn, Left, and Right)
 to scroll and examine the
 report, even if it has not
 finished formatting.
 Each section on a worksheet serves a specific
 function.  In addition to the sections
 currently shown, a worksheet may also contain
 Group sections: Group Headers and Group
 Footers.  You may place field(s) in these
 areas to group or total related data.
 Report Writer creates Group Header and Group
 Footer sections when you specify that a
 field is a group field.  Use the Order action
 on the worksheet to specify group fields.
 Report Writer provides many actions that you can use to
 design your reports.  These actions can be selected from
 the worksheet menu.  To access the menu, press Esc from
 the worksheet.
" Title Page
C Page
Header
 Last
First
Phone
 &EMP:STATE
 Group  Header
Save Report
EMP:STATE
  Save Changes
  Report Name
  Definition File:
?EMP:STATE 2:43
 'LIN OVR
 ,Press Esc for menu or F1 for Help
" Title Page
C Page
Header
 Last
First
Phone
 &EMP:STATE
 Group  Header
Save Report
EMP:STATE
  Save Changes
  Report Name
:Bonus Report
  Definition File:RPT
1.DEF
?EMP:STATE 2:43
 'LIN OVR
 ,Press Esc for menu or F1 for Help
Trace Type
  Single
  Double
Block
 Mixed
 Mixed
 The Trace action lets
! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6
 you "draw" lines of
 characters using the
  @ A B C D E F G H I J K L M N O P Q R S T U V
 cursor keys.
  ` a b c d e f g h i j k l m n o p q r s t u v
 You can choose any one
 character from this box
 or use one of the
 pre-defined options
 on the top line.
 A sample of the output
 is shown in the upper
 right hand corner.
 Now that we have the report the way
 we want it, let's return to the
 worksheet so that we can name and save
 this report.
 Press Esc to return to the worksheet.
 Press the End key to highlight
 Quit and press Enter.
 Name and save your report in this window.
 Select Yes to save any changes that you
 made in this design session.
 On the Report Name line, type Bonus Report
 and press Enter.
 Report Writer assigns a default report
 definition file name for you.  You may
 override this default if you prefer.
 When you press Enter to accept the default,
 you return to the Report Page.
 Notice that the new report name, Bonus Report, appears
 in the list of reports.
 Next, let's create a new database.
 From the Report Page, highlight
 Database and press Enter.
 The fields in the PEOPLE.DAT file appear in
 the Field window.  A menu appears that
 allows you to:
 Modify fields.
 Create new fields.
 Hide fields that appear in the Field list.
 Move a field Up or Down in the Field list.
 Join another File to this file.
 Assign a Password for this database.
 Print or display a specifications (Specs)
report.
 For this database, we simply want to bring in the
 PEOPLE.DAT file.  We won't make any changes to
 the fields in it.  So, select Quit and we will
 save and name the database.
 To save this database, select Yes on the Save
 Changes line.
 On the Database Name line, type People Database
 and press Enter.
 Report Writer assigns a database definition file
 name which you may override.
 Press Enter to accept the default file name.
" Title Page
C Page
Header
 Last
First
Phone
 &EMP:STATE
 Group  Header
% Body
EMP:STATE
 Group  Footer
A Grand  Totals
A Page
Footer
B Final Page
Body 1:48
 ,LIN OVR
Print or View This Report
 7Run
Choose
Order
Layout
Trace
Field
Password
Specs
Quit
A1
A2      b
A25     )
A26     3
A3      7
A4
A5
A6
A7
A8
A9      K
B1
B2      d
B3      d
B4
B5      g
B6      ,
B7      6
B8      S
B9
BAR     p
BEGIN
BLACK
BYEBYE  e
C1
C10
C11     O
C12
C13
C17     ~
C19
C2
C20
C21     i"
C22     r%
C23
C24     y'
C245
C246
C25     [+
C26
C27     8,
C28
C29     d-
C3      H.
C30
C31     w0
C32
C5      e2
C7      (7
C8
C9
CHANGE
CHOOSE  u:
CHOOSE2 '=
CHOOSE3
CHOOSE4
COND1
COND2
COND3
CR3
CR4
CREATE  ZO
CREATE1
CREATE2
CREATE3
CRPT_13
CRPT_14
CRPT_4
CRPT_5
C_REP
D1      $]
D2
DB1
DB2
DB_CR1
DB_CR2
DB_CR3  ^l
DB_CR4
DB_CR5
DB_CREATDw
DB_SCR
DEST    h}
DEST_A
DONE
DOS     5
E1      3
E2
E3
E4
E5
E6
E7
E8      _
ENT_FIL2
ENT_FIL3
ENT_FILEg
FIELDS  y
FIELDW  R
FINAL
FINAL1  R
FINALM  :
FLDMENU `
FORM3
FORM4   B
FORM5
FORM6
FORM7   5
GROUP
GRUN    1
INSTR1
INSTR2
INTRO_W2
MENULINE4
NOTITL
NOTITL2 B
N_SCREEN
OPEN
ORDER
PR      "
PR1     r
PRT
PRTT_1
PRTT_2
PRTT_3
PRTT_4  *
PRT_1
PRT_2
PRT_3   j
PRT_4
PRT_5   ^
PRT_6
PRT_7   h
PRT_8   ,
PRT_9
PT10    u
PT2     A
PT3
PT4
PT5     .
PT6
PT7
PT8
PT9
REP1    \
REP10   N
REP11
REP12
REP13   ^
REP14   |
REP15
REP2
REP3    z
REP4
REP5
REP6
REP7    *
REP8
REP9
REPORTER
REPORTS
RPTCREATg#
RPTDBASE
RPTERASE=$
RPTMODIF
RPTOPTIO
RPTPRINT
RPTQUIT
RPTRUN  ]&
RP_PG
RUN
SAMPLE
SAMPLE1 ~.
SECTIONS
SEEMENU .2
SV_RP   M3
SV_RP1
TRACK
W1
W2
W3
W3A     2@
W4      [A
W5
W6
W7      (E
W8      dF
W9      TG
WKST    +H