problem of 1098 character per line for report
Date: Tue, 22 Dec 1998 02:35:36 GMT
Message-ID: <75n0ho$9l4$1_at_nnrp1.dejanews.com>
Report of 1098 character long.
Hi,
I'm having a problem with Oracle Report. I have developed a report which in the output there is a output line that must be 1098 character long. When I run the report in Oracle Report, there is no problem at all. However, there is an issue when I tried to integrate (define the concurrent request in Application Object Library and assign it with Module Group ie Inventory in System Administrator) it with my Oracle Application (Oracle Manufacturing).
Now, when I submit the report its completed with an error. Last time we manage
to
solve the problem (with 243 character per line). Here's what we did :
Steps you need to take to enable the print of reports with 243 characters per line.
Some steps need to be taken on unix, other steps need to be done as System Administrator.
unix:
login as applmgr, do a cd to the $FND_TOP/srw directory and
create a file called TIXW243.prt with the following contents:
printer "TI Extra Wide 243"
height 66
width 243
before report ""
after report ""
between pages control(L)
return "" linefeed control(J) code "bold on" "" code "bold off" ""
code "underline on" ""
code "underline off" ""
This file is used by Oracle Reports and other tools to identify the control characters used for bold on/off, etc. If you know the codes you may input them in the file (see the other .prt files in the same directory), if you don't know them simply specify "" as in the example above.
Then as System Administrator perform the following setups in Oracle:
Define Print Style (\ Navigate Install Printer Style). Query all the existing records and go beyond the last record, this will give a default value for field 'Sequence'. Then fill out the following fields: Name = 'XW243', User Name = 'Extra Wide (243 Characters)', Columns = 243, Rows = 66, Suppress Header PAge = 'Yes', Orientation = 'Landscape', SRW Driver = 'TIXW243'. Commit the record.
Define Printer Driver (\ Navigate Install Printer Driver Define).
Define a printer driver as follows: Name = 'TIXW243', User Name = 'TI Extra
Wide (243 Columns), Description = TI Extra Wide (243 Columns), Platform = ""
SRW Driver = TIXW243, Driver Method = 'Command', Spool File = 'No', Standard
Input = 'Yes', Program Name = "", Arguments = "lp -c -d$PROFILES$.PRINTER
-n$PROFILES$.CONC_COPIES -t"$PROFILES$.TITLE" $PROFILES$.FILENAME",
Initialization = "", Reset = "". Commit the record.
This driver assumes that you setup the printer manually (condensed printing,
page size, etc). You can use software commands for this, but then you have
to specify the Initialization and Reset strings.
Define Printer Types (\ Navigate Install Printer Types). If it is a new type of printer that does not exist in Oracle yet, you have to specify it over here: Type = [Brand/Model], Decription = [any desription]
Assign Printer Drivers (\ Navigate Install Printer Drivers Assign). Assign the new Print Style and Driver Name to the new/existing Printer Type: Type = [Brand/Model], Style = TIXW243, Driver Name = TIXW243. Commit the record. If you have defined a new Printer Type, you may also need to assign more Print Styles with associated driver in order to be able to printer other formats of reports to the same printer.
Register Printers (\ Navigate Install Printer Register). If you defined a new Printer Type you should update the Type information for the existing printer. Query up the printer and change the Type to the new type. Commit the record.
After these setups you should be able to print the report to the printer. It is some work but it has to be done. Keep in mind that the printer drivers are memory resident. Once you printed a report to the printer, the printer driver will reside in memory and any updates you make to the printer driver will have no effect until you shutdown and startup the database...
---
I follow exactly the steps and yet the report failed with and error. Does anybody out there have some ideas?
-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Tue Dec 22 1998 - 03:35:36 CET