DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: How to skip character mode for any reqd. item in reports

  1. #1
    Join Date
    Jan 2002
    Posts
    40

    Unhappy How to skip character mode for any reqd. item in reports

    Hi Everybody,
    I'am printing a report in character mode through an Epson LQ-2180 printer. In this report i need to keep the print of the DOC NO. field a little bigger than the other fields.
    Is it possible to skip the character mode for this particular Field i.e. the Document No. and if yes, how can I do it....

    Thanks,
    SFDBA

  2. #2
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Have you tried including the Epson escape/control sequences in your SELECT statement?
    - SELECT '!%&BIG'||to_char(DocNo)||'!%&SMALL' etc etc
    (I've no idea what the codes are - RTEpsonM. If you need a character you can't type - I seem to remember the escape character being special - use chr(n).)

  3. #3
    Join Date
    Jan 2002
    Posts
    40
    I checked on the Epson user manual. There are some codes for Font selection, font enhancement, character handling, Bit map, i'am doing trial and error on the code, i guess i'am close to the soln.

    Thanz DaPi

  4. #4
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    I'd first try something simple to test the principle . . . I've found an old manual (written by the venerable Bede in about 647AD). According to that
    - Select chr(27)||'E'||to_char(DocNo)||chr(27)||'F' etc etc
    has a good chance of giving you that field in bold.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width