HELP: Printing dbase III report on Laser Printer 
Author Message
 HELP: Printing dbase III report on Laser Printer

ALOHA!!
Thanks in advance for any help you can provide.

I need to be able to change the printed font size of a Dbase III Plus
report because the amount of info that needs to be printed is too long for
the current 10 cpi setting on the printer.  18 cpi would be fine.  
Currently, in order to print the report I need to physically go to the
printer (HP Laser Jet IV plus), change the font size, go back to the
computer, print the report and then go back to the printer to get my
report and change the settings back..all the time hoping that no one else
changed it back or tried to print a document during all of this.  This
printer is hooked to a Novel 4.? network and receives many print jobs from
throughout the company.  Also, the printer is located in the other end of
the building.  
        My computer is running Windows 3.11 but the Dbase is a dos
program.  I would like to know if it is possible to get the font size
changed from dbase, or have windows print the report landscape(I doubt
that) or if there is some way I can write a little program or something
that will send codes to the printer, telling it to change the font size to
print my document, and then restore the initial settings.
        Any help would be greatly appreciated..I suggested upgrading to a
windows based data base but this is not an option.

Thank you all
aloha
ron



Sun, 24 Jan 1999 03:00:00 GMT
 HELP: Printing dbase III report on Laser Printer

Quote:

> I need to be able to change the printed font size of a Dbase III Plus
> report because the amount of info that needs to be printed is too long for
> the current 10 cpi setting on the printer.  18 cpi would be fine.

The folling works in Foxpro, you might need to use ?? or ? instead of ??? on dBase III
Plus though.  The chr(xx)+chr(xx)... will be the escape characters your print takes to
change whatever setting you want.

   set print on
   ??? chr(27)+chr(64)+chr(13)
   set print off
   report form xxxx to print



Tue, 26 Jan 1999 03:00:00 GMT
 HELP: Printing dbase III report on Laser Printer



Quote:
>ALOHA!!
>Thanks in advance for any help you can provide.

>I need to be able to change the printed font size of a Dbase III Plus
>report because the amount of info that needs to be printed is too long for
>the current 10 cpi setting on the printer.  18 cpi would be fine.  
>Currently, in order to print the report I need to physically go to the
>printer (HP Laser Jet IV plus), change the font size, go back to the
>computer, print the report and then go back to the printer to get my
>report and change the settings back..all the time hoping that no one else
>changed it back or tried to print a document during all of this.  This
>printer is hooked to a Novel 4.? network and receives many print jobs from
>throughout the company.  Also, the printer is located in the other end of
>the building.  
>    My computer is running Windows 3.11 but the Dbase is a dos
>program.  I would like to know if it is possible to get the font size
>changed from dbase, or have windows print the report landscape(I doubt
>that) or if there is some way I can write a little program or something
>that will send codes to the printer, telling it to change the font size to
>print my document, and then restore the initial settings.
>    Any help would be greatly appreciated..I suggested upgrading to a
>windows based data base but this is not an option.

>Thank you all
>aloha
>ron


If you can't use the FoxPro suggestion, you can do what we do.

Create a file with the laser printer code for condensed print.
I can do this with the DOS editor I use.  You can't use the MS-DOS editor
because the <ALT> key takes you to the Menu bar at the top.
I press the <ALT> key and at the same time press "2" and then "7"
on the numeric keypad.  This creates the <Esc> code, CHR(27), which
looks like a left arrow in the file.
Then type:  "&k2S" (without the quotes).  Save the file as L17
(for laser CPI 17) or whatever name you want.

Create a second file with the laser printer code for 10 CPI.
Start a new file with the DOS editor.  Create the <Esc> code as
before.  Then type: "(s10H" (without the quotes).
Save the file as L10 or whatever.

I can't remember if you can print a dBASE III report to a file.
If so, after creating the file, exit dBASE and type:
  copy L17 + <report filename> + L10 temp.out
  print temp.out

This will copy the laser printer control codes to the top and bottom
of the file, temp.out.

If dBASE III does not create a report file, you can
a. in dBASE:
     copy L17 to prn (don't remember the exact wording here)
     print the report
     copy L10 to prn

b. copy L17 prn (in DOS)  OR
   print L17 (in DOS)
   Get into dBASE and print the report.
   Exit dBASE and in DOS
     print L10  or
     copy L10 prn

Joan



Sat, 30 Jan 1999 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Printing same report to matrix and/or laser printer

2. Report printing on laser printer

3. Printing reports from a Foxbase+ program on a laser printer

4. Printing PROBLEM on a Laser Printer

5. Printing on matrix and laser printer

6. Printing to Laser Printer from ISQL

7. Printing images on laser printers

8. How to print your company logo to a HP Laser Printer

9. Printing forms on laser printers

10. Printing forms on laser printers

11. Printing Label to Laser Printers


 
Powered by phpBB® Forum Software