Well, that's no ordinary rabbit!
COMMA
Inserts a comma as 1000's separator in numeric fields.
COMMA=Y will print 1,000,000 instead of 1000000.
Remember to adjust the field length accordingly.
CON
Condition - code used to conditionally print a field
DASH
creates line of dashes
DAT
Data Type, see list below
DEC
Decimal Places
FNC
Function
FST -
first value
MAX -
maximum value
LST - last
value
MIN -
minimum value
CNT -
count entries
AVG - mean
value
TOT -
numerical total
MED -
median value
VAR -
variance
MOD - mode
(frequency of occurrence)
SD - standard deviation
FONT
Font - B (bold underlined)
b (bold)
I (italics
underlined)
i (italics)
N (normal
underlined)
n (normal)
Note - these are predefined fonts but you can create your own. Just
store the printer font command in /R.F subscripted by a unique
identifier. I have used it to have a conditional font using FONT=C and
in a macro or line check setting the value of /R.F["C"].
To print a field in bold if a query reponse is Y and normal the rest of
the time use the FONT=C attribute and this line check on the line where
it prints.
LC=IF{@cd.response["QUERY"]="Y" /R.F["b"];/R.F["n"]}^/R.F["C"],1
This also works for changing to a font other than courier but you will
likely throw off the spacing for any text to the right of the field.
You just need to store the printer command for the font you want to use
in your own /R.F variable.
GRP
Group Response Dictionary link
GRP=MY.GROUP will provide a lookup and only allow responses from a
group response dictionary called MY.GROUP. The report writer does this
by adding an ID.ARG attribute which points to the group response
dictionary. This creates the possibility of have different lookups for
different users. How? Build several group reponse dictionaries and then
add the GRP attribute referencing one of them so the ID.ARG gets
created. Edit the ID.ARG attribute so that is references a variable
rather than the group. Then add an IFE or BFI attribute that sets the
value of the variable to different groups based on whatever criteria
you want.
Example - provide one lookup for RN's and a different one for everyone
else
Create 2 groups - one MY.RN.GRP with the choices an RN should have and
another MY.NRN.GRP with the choices everyone else should have.
Add GRP=MY.RN.GRP attribute
Assuming user id's for RN's start with RN and NA's start with NA add
this IFE attribute -
IFE=IF{/.USR$2="RN" "MY.RN.GRP";"MY.NRN.GRP"}^GRP,1
Then replace the "MY.RN.GRP" with GRP in the ID.ARG attribute.
This example uses user id but you could also base it on a query response or the input from another selection field or the day of the week, whatever you want.
ID.AS
Links an xx.field to a standard field. This can allow a lookup
on an xx field in some cases.
For instance on an ADM report to provide a lookup on a custom field to
the doctor dictionary you could add this
ID.AS=attend.phys
JFY
Justification - L (left), R (right), C (center)
LAB
?????
LEN
Length
MPAFV
Multiple Page after first value
MPHUL
Multiple Page hold until last value
PG.RESET
Page reset
PRT
Print - PRT=N will make the field not print but any code in the VAL statement will still be evaluated.
RLOG
Report Logic
SIZE
font size - S,M,L,XL, or numeric
SUB
?????
TRUNC
Truncate - TRUNC=N will allow you to print more than characters in a 30 character field when used in conjunction with the SIZE=S attribute.
VAL
Value
WITH
With - only used in conjunction with FNC=TOT
BFIn
Performs field check after DFT2 and IFE but before user input
CH
Choice - CH=ONE,TWO,THREE will display a lookup of ONE, TWO and THREE and only allow for one of those to be entered.
DAT
Data Type - See list below
DFT2
Default - works the same as it does for CDS
FCLn
Field Check - works the same as it does for CDS
HLP
Help
ID
ID - Program used to provided a look-up and restrict user selection.
ID.ARG
ID Argument
IFE
Controls whether the cursor will stop at a selection prompt. Works the same as it does for CDS. Be sure not to use REQ=Y or REQI=Y if the IFE attribute is not going to allow the cursor to stop for user input.
JFY
Justification - L (left), R (right), C (center)
LEN
Length
MAP
Map, converts user input and keywords to another value such as ALL to D(127)
PRE
Performs logic on the input before field checks are done
REQ
Required - REQ=N or REQ=Y
REQI
Required Immediately - REQI=N or REQI=Y
ADDRESS
U.S. ADDRESS
AGE
AGE (nnY nnM nnD)
AGE.SORT
AGE PADDED (nnY nnM nnD)
BAR.CODE
BAR CODE (OUTPUT ONLY)
BDATE
BIRTHDATE
BDATE-
DATE (MM/DD/YY) OR '-'
CHOICE
MULTIPLE CHOICE
CODE.128
BAR CODE FORMAT 128
DATE
DATE (MM/DD/YY)
DATE-
DATE (MM/DD/YY) OR '-'
DATE10
DATE (MM/DD/YYYY)
DAY
DAY OF THE WEEK
DEC
NON-NEGATIVE DECIMAL
DEC1
NON-NEG DEC ('> 1 PLACE)
DEC1Z
NON-NEG DEC 0 STRIPPED 1P
DEC2
NON-NEG DEC ('> 2 PLACE)
DEC2Z
NON-NEG DEC 0 STRIPPED 2P
DEC3
NON-NEG DEC ('> 3 PLACE)
DEC3Z
NON-NEG DEC 0 STRIPPED 3P
DEC4
NON-NEG DEC ('> 4 PLACE)
DEC4Z
NON-NEG DEC 0 STRIPPED 4P
DEC5
NON-NEG DEC ('> 5 PLACE)
DEC5Z
NON-NEG DEC 0 STRIPPED 5P
DECZ
NON-NEG DEC 0 STRIPPED
EDATE
ELAPSED DATES
ESS DATE
ESS DATE
ETIME
ELAPSED TIME
FREE
FREE TEXT
FREE.NS
FREE TEXT - STRIP LEADING/TRAILING SPACES
GLPERIOD
GENERAL LEDGER PERIOD
HHMM
24 HOUR CLOCK TIME
HHMM5
TIME IN 5 MINUTE INTERVALS
HHMMU
24 HOUR CLOCK TIME or UNKNOWN
INT
NON-NEGATIVE INTEGER
INT-
NON-NEGATIVE INTEGER or -
INTZ
NON-NEGATIVE 0 STRIPPED INTEGER
MONEY
NON-NEGATIVE MONEY
MONTH
MONTH OF YEAR
NAME
PERSON'S NAME
PDEC
POSITIVE DECIMAL
PDEC2
POSITIVE DECIMAL ('> 2 PLACES)
PDEC2Z
POSITIVE DECIMAL 0 STRIPPED 2 PLACES
PDEC3
POSITIVE DECIMAL ('> 3 PLACES)
PDEC3Z
POSITIVE DECIMAL 0 STRIPPED 3 PLACES
PDEC4
POSITIVE DECIMAL ('> 4 PLACES)
PDEC4Z
POSITIVE DECIMAL 0 STRIPPED 4 PLACES
PDEC5
POSITIVE DECIMAL ('> 5 PLACES)
PDEC5Z
POSITIVE DECIMAL 0 STRIPPED 5 PLACES
PDECZ
POSITIVE DECIMAL 0 STRIPPED
PHONE
PHONE NUMBER
PINT
POSITIVE INTEGER
PINTZ
POSITIVE INTEGER 0 STRIPPED
PMONEY
POSITIVE MONEY
POSTNET
POSTNET BAR CODE
QRY.RESP
QUERY RESPONSE
RATE
DECIMAL RATE
SDEC
SIGNED DECIMAL
SDEC2
SIGNED DECIMAL (2 DEC'S)
SDEC3
SIGNED DECIMAL (3 DEC'S)
SDEC4
SIGNED DECIMAL (4 DEC'S)
SDEC5
SIGNED DECIMAL (5 DEC'S)
SINT
SIGNED INTEGER
SMONEY
SIGNED MONEY
STIME
TIME WITH SECONDS
TIME
24 HR CLOCK
YEAR
4 DIGIT YEAR
YN
YES/NO
YN-
YES/NO/- (UNKNOWN)
ZDEC
ZERO-FILLED DECIMAL
ZINT
ZERO-FILLED INTEGER
ZIP.POST
ZIP OR POSTAL CODE
ZMONEY
ZERO-FILLED MONEY
Don't see what you
need? Visit one of these other sites
or email me your request (tomt at thomast357.com).