Shareware Overload

home *** CD-ROM | disk | FTP | other *** search

/ Shareware Overload / ShartewareOverload.cdr / busi / tsb70_79.zip / TECHB071.DOC (.txt) < prev next >

Wrap

Smart Software Document | 1988-02-10 | 5KB | 346 lines

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.