Date: Wed, 25 Aug 1999 09:35:24 -0500 From: "Anil Kumar (ns)" akumar@cap.org To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca Subject: RE: printer problem Message-ID: 0EB7D2C228BCD21181BA00805F8549EA2BB8D5@intmail.cap.org Go through these steps. It may be a little bit detailed explanation for you, but I hope this will help you in identifying your problem. 1. For the physical printer identify the printer queue name which will be used for printing the report. Ex. elv3si_1 2. Within the Oracle Application, use the System Administrator responsibility. 2.1 Access the Printer Register Form using the path, Install - Printer - Register. Verify that the printer is registered in Oracle; if not, register it. 2.1.1 Printer - printer queue name. Ex. elv3si_1 2.1.2 Type - descriptive printer type name. Ex. HPLJ3si 2.1.3 Description Ex. 2FL ELV RM 2.2 Access the Concurrent Programs Form using the path, Concurrent - Program - Define. Query on the Program (This is usually the same, or similar to, the report name). - Identify the Short Name for the specific report/document. Ex. INVTRHAN - Identify the Output Style. Ex. Landwide 2.3 Access the Print Styles Form using the path, Install - Printer - Style. 2.3.1 On the Print Style Form, define the print style for the report Output Style. This print style will be used when the report is viewed online. 2.3.1.1 Style Name Ex. LANDWIDE 2.3.1.2 User Style - Must be the same as the Output Style on the Concurrent Programs Form. Ex. Landwide 2.3.1.3 SRW (SQL*ReportWriter) driver for the Print Style This is the driver, which is used when the report/document is printed. Ex. W 2.3.1.4 Description 2.3.1.5 Layout 2.3.1.5.1 # Columns 2.3.1.5.2 # Rows 2.3.1.5.3 Suppress Header - Checked or not to determine whether a report header should be printed 2.3.1.5.4 Orientation 2.3.2 On the Print Style Form, define the print style to be used for each type of printer that will print a hard copy of the report. 2.3.2.1 Style Name Ex. HPW 2.3.2.2 User Style Ex. LANDWIDE - HPLJ4 2.3.2.3 SRW (SQL*ReportWriter) driver for the Print Style This is the driver, which is used when the report/document is printed. Ex. HPW 2.3.2.4 Description 2.3.2.5 Layout 2.3.2.5.1 # Columns 2.3.2.5.2 # Rows 2.3.2.5.3 Suppress Header - Checked or not to determine whether a report header should be printed 2.4 Access the Printer Driver Form using the path, Install - Printer - Driver. Define the printer driver for the hard copy report. Each Printer Type will need its own driver. Data includes: 2.4.1 Driver Name Ex. LANDWIDEHPLJ3SI-2 2.4.2 User Driver Ex. LANDWIDE-2 for printer HPLJ3si 2.4.3 Description 2.4.4 SRW Driver for the printer This is the driver, which is used for the printed report/document. It must be the same as the related Print Style SRW Driver. See 2.3.2. Ex. HPW 2.4.5 Driver Method 2.4.6 Arguments - The full UNIX command and its arguments 2.4.7 Initialization - Printer initialization string (See the next page for information on the initialization string.) 2.4.7.1 Number of columns from the right margin a#M, where # is the number of print characters for a line. Ex. a132M This example defines a line with 132 characters. 2.4.7.2 Spacing between lines a#C, where # is the number of 1/48 inch increments Ex. a5.45C This example defines a line spacing of (5.45 X 1/48) inch. 2.4.7.3 Line spacing Ex. 2G Single spacing 3G Double spacing 2.4.7.3 Number of lines on a page l#F, where # is the number of lines on a page. Ex. l66F 2.5 Access the Printer Type Form using the path, Install - Printer - Types. Relate the printer style and the printer driver. 2.5.1 Type Name Ex. HPLJ3si 2.5.2 Description 2.5.3 Printer Driver 2.5.3.1 Style - Style Name from Print Styles Form Ex. LANDWIDE 2.5.3.2 Driver - Driver Name from Printer Driver Form Ex. LANDWIDEHPLJ3SI-2 2.3.3. Update the concurrent program, if needed 2.3.3.1 Output Style should be the same as the User Style from the Print Style form. Ex. Landwide 2.3.3. 2 Optional - Printer (queue name) if the document must only be printed by a single specific printer. Ex. elv3si_1 2.3.4. To make updates effective, the DBA must stop and then restart the Concurrent Manager. 3. On UNIX create the Output Style driver files, which were identified on the Printer Driver form. These files should be in the srw subdirectory. Ex. W.prt - This driver is used when the report is viewed online. printer "dec LN03 Landwide" height 57 width 180 between pages control(L) return control(M) linefeed control(J) code "bold on" esc "[1m" code "bold off" esc "[0m" code "underline" esc "[4m code "underline off" esc "[0m" Ex. HPW.prt - This driver is used when the report is printed by elv3si_1. printer "HPLJ Landwide" height 65 width 180 between pages control(L) return control(M) linefeed control(J) code "bold on" esc "(s7B" code "bold off" esc "(s0B" code "underline" esc "&d0D" code "underline off" esc "&d@" 4. The printer control panel settings may need adjusting if a new printer is being used. 5. Common printer problems and solutions: 5.1 Problem: The report is double spaced but should be single spaced. Solution: In the Concurrent Program initialization string, change 3G to 2G. 5.2 Problem: One report page wraps onto two pieces of paper. Solution: - The number of rows may need to be increased in the Concurrent Program definition. - The height in the printer driver on UNIX must be greater than or equal to the number of rows in the Concurrent Program definition. The drivers reside in the srw subdirectory and have a prt extension. - The number of lines in the Printer Driver initialization string must be greater than or equal to the number of rows in the Concurrent Program definition. (See 2.4.7.3) - The rows in the Print Styles must be greater than or equal to the number of rows in the Concurrent Program definition. 5.3 Problem: One line is printed on the first page of the report and the rest of the pages are blank. Solution: The srw driver on UNIX needs to be changed. The drivers reside in the srw subdirectory and have a prt extension. Change from : return "" To: return control (M) 6. Change the printer initialization string for an existing printer driver to correct a report print-out. Warning: A driver can be used for multiple reports/documents. Before making changes a driver, identify all reports/documents that use the driver and test them before and after the changes are made. 6.1 On the Concurrent Programs form, query using Program. This is usually the same, or similar to, the report name. Make note of the Output Style. Ex. Query using Transaction historical summary. In the Output region of the form, the Style is Landwide. 6.2 On the Printer Types form, query by Type to get the driver Style and associated Driver Name. Ex. For Type HPLJ3si, since the Concurrent Program report is Landwide, the Style is LANDWIDE and the driver is LANDWIDEHPLJ3SI-2. 6.3 On the Printer Types form, identify all other printers and styles that use the driver. Do this by doing a "Find all" on the Printer Type form and make note of each printer Type and Style using the driver. Ex. For driver LANDWIDEHPL3SI-2, these are Printer Type Style 1) HPLJ3si LANDWIDE 2) XEROX6135 LANDWIDE 6.4 On the Printer Types form, remove all records for the given driver. 6.5 On the Printer Driver form, make any needed changes. 6.6 On the Printer Types form, add back all records removed in 8.4 6.7 To enable the changes, the DBA must stop and restart the Concurrent Manager.