INFORMIX
SOFTWARE,
LENEXA,
Technical
Support
Bulletin
Number
Title:
Columnar
Sorting
Manager
Labels
Date:
November
printing
multiple
columns
labels
using
Manager
Report
command,
labels
printed
current
logical
order
going
horizon
tally
first
vertically.
example,
order
company
name,
report
would
looking
something
this:
Repair
Service
Appleby
Smith
Assc.
Astro
Burgers,
Beardsley
Consulting
Blair
Brothers
Corp.
Bradford
Hospital
Often,
however,
prefer
order
report
vertical
column
printed.
above
example,
desired
order
this:
Repair
Service
Beardsly
Consult
Appleby
Smith
Assc.
Blair
Brothers
Corp.
Astro
Burgers,
Bradford
Hospital
Unfortunately,
there
currently
means
which
automatically
these
labels
listed
order
lumnar
fashion.
However,
sible
which
obtain
ordering
presented
here.
Getting
report
print
vertical
order
nothing
definition
definition
using
changed.
trick
ordered.
ordering
makes
REPORT
command's
horizontal
ordering
nique
order
achieve
verti
ordering.
query
assign
value
numeric
field
base.
value
based
current
logical
record
number
positi
where
record
appear
page.
meric
field
field
place
appropri
order
label
printing.
following
query
assigning
these
values
field
called
[Position]
represent
field.
assumes
report
defini
columns
labels
taining
labels.
query
follows:
replace
[Position]
int(record/22)
mod(record,22)
mod(record,22)
mod(record,22)
mod(record,22)
value
represents
number
labels
value
represents
number
first
column.
query
modified
differ
number
labels
changing
occur
rences
these
values.
three
columns
labels,
query
would
this:
replace
[Position]
int(record/33)
mod(record,33)
mod(rec
ord,33)
mod(record,33)
mod(record,33)
mod(record,33)
mod(record,33)
Again,
value
query
represents
labels
page.
query
scribe
first
changes
query
varying
numbers
labels
should
apparent.
Finally,
query
columns
labels
should
written
replace
[Position]
int(record/44)
mod(record,44)
mod(record,44)
mod(record,44)
mod(record,44)
mod(record,44)
mod(record,44)
mod(record,44)
mod(record,44)
Again,
beyond
representing
number
page,
becomes
somewhat
difficult
deter
meaning
other
parts
formula.
represents
number
columns
other
numbers
based
number
labels
which
appear
page.
order
process
successful,
impor
follow
these
steps
generating
port:
1. If
there
inactive
records
file,
necessary
query
index
records.
leted
records
print
report
throw
vertical
dering.
2. Sort
desired
field.
3. Use
QUERY
Predefined
command
generate
given
query
definition.
Since
index
quired,
Neither
option.
4. Sort
[Position]
field
ascend
order.
Order
index.
5. Generate
report
using
REPORT
Print
mand.
option
consistent
query
definition.
final
important
note:
since
REPORT
still
print
label
right,
dering
confused
enough
labels
page.
avoid
problem,
enough
blank
records
page.