Re: Oracle Report 3.0 Character Mode Printing
Date: Thu, 19 Nov 1998 15:27:34 +0100
Message-ID: <7319hp$lok$1_at_usenet49.supernews.com>
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
To produce a text file, or .csv file to analyze in a spreadsheet, there = are several more steps to take, most documented in the "Oracle = Developer/2000 Handbook". =20
First you need to make your select statement look like this: SELECT =
'"'||TEXT_COLOUMN||'","'||TEXT_COLUMN2||'",'||NUM_COL||','||NUM_COL2||'' =
LABEL=20
FROM ....
In the fields and labels screen of the wizard, delete the label name and =
set the width to a big number(make sure you make it big enough or you =
will get carriage return symbols in the middle of your data) =20
In the property pallet for the report, set the 'design in character = units' to yes.
Set DESNAME to PATH\filename
Set DESTYPE to File
Set MODE to Character
Go into the layout editor and click the margin tool. resize the heavy = lined box to as large as it will get.
This part is not documented:
Go to the orant(or ora95 or whatever)\report30\printers and open a =
printer file with notepad(I used wide180) and delete all references to =
return and linefeed. Then set the width to whatever width you need. =
Save this file as anything you like, and set DESFORMAT to this =
path\filename. (you will need to deploy this file with the report)
Then go into the property pallet of the whole report and set the width =
to whatever it needs to be in both the report section and the character =
mode section.
=20
Shawn Baker wrote in message =
<3649CD19.ADE43480_at_cat.e-mail.NOSPAM.com>...
>I have found it quite tricky getting the grid to work well for =
character
>mode. After much experimentation, I now work with the following =
parameters:
> >Use Size 10 Courier New font. This gives you 12 characters per inch >horizontally. >Figure 6 lines per inch vertically. > >Set report properties as follows: > Width: 8.5 (portrait) 11 >(landscape) > Height: 11 (portrait) 8.5 >(landscape) > Design in Character Units: Yes > Report Width: 102 (portrait) 132 >(landscape) > Report Height: 66 (portrait) 51 >(landscape) > >With a Layout editor open, select Format / Layout Options / Rulers. =Make
>the following ruler settings: > Units: Character Cells > Horizontal Size: 6 > Vertical Size: 12.0031 > Grid Spacing: 1 > Number of Snap Points: 1 > >Set the DESFORMAT system parameter to the name of an appropriate =printer
>control file that will be found in your ora \ REPORT30 \ PRINTERS = folder.
> >If doing landscape, set the ORIENTATION system parameter to LANDSCAPE. > >If anyone else out there has any suggestions, I am also very interested =in
>hearing. >-- Shawn > > >sokol_at_opsb.ru wrote: > >> Hello guru. >> >> How I can print in character mode from Oracle Reports 3.0 and >> how I can print to standard *.TXT (ASCII) file >> >> Thanks. >> >> -----------=3D=3D Posted via Deja News, The Discussion Network = =3D=3D---------- >> http://www.dejanews.com/ Search, Read, Discuss, or Start Your =Own
>
------=_NextPart_000_003A_01BE13D1.21E45FA0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
<HTML>
<HEAD>
<META content=3Dtext/html;charset=3Diso-8859-1 =
http-equiv=3DContent-Type>
<META content=3D'"MSHTML 4.72.3110.7"' name=3DGENERATOR>
</HEAD>
<BODY>
<DIV>To produce a text file, or .csv file to analyze in a spreadsheet, =
there are=20
several more steps to take, most documented in the "Oracle =
Developer/2000=20
Handbook". </DIV>
<DIV> </DIV>
<DIV>First you need to make your select statement look like this: =
<FONT=20
face=3DFixedsys>SELECT=20
'"'||TEXT_COLOUMN||'","'||TEXT_COLUMN2||'",'||NUM_COL=
||','||NUM_COL2||'' =20
LABEL </FONT></DIV>
<DIV><FONT face=3DFixedsys>FROM ....</FONT></DIV>
<DIV> </DIV>
<DIV>In the fields and labels screen of the wizard, delete the label =
name and=20
set the width to a big number(make sure you make it big enough or you =
will get=20
carriage return symbols in the middle of your data) </DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>In the property pallet for the report, set the =
'design in=20
character units' to yes.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Set DESNAME to PATH\filename</FONT></DIV>
<DIV><FONT size=3D2>Set DESTYPE to File</FONT></DIV>
<DIV><FONT size=3D2>Set MODE to Character</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Go into the layout editor and click the margin =
tool. =20
resize the heavy lined box to as large as it will get.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>This part is not documented:</FONT></DIV>
<DIV><FONT size=3D2>Go to the orant(or ora95 or =
whatever)\report30\printers and=20
open a printer file with notepad(I used wide180) and delete all =
references to=20
return and linefeed. Then set the width to whatever width you =
need. =20
Save this file as anything you like, and set DESFORMAT to this =
path\filename.=20
(you will need to deploy this file with the report)</FONT></DIV>
<DIV><FONT size=3D2></FONT><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Then go into the property pallet of the whole report =
and set=20
the width to whatever it needs to be in both the report section and the=20
character mode section.</FONT></DIV>
<DIV><FONT size=3D2> </FONT></DIV>
<DIV>Shawn Baker<SMBAKER_at_CAT.E-MAIL.NOSPAM.COM> wrote in message <<A=20
href=3D"mailto:3649CD19.ADE43480_at_cat.e-mail.NOSPAM.com">3649CD19.ADE43480=
_at_cat.e-mail.NOSPAM.com</A>>...</DIV>>I=20
have found it quite tricky getting the grid to work well for=20
character<BR>>mode. After much experimentation, I now work with the =
following=20
parameters:<BR>><BR>>Use Size 10 Courier New font. This gives you =
12=20
characters per inch<BR>>horizontally.<BR>>Figure 6 lines per inch=20
vertically.<BR>><BR>>Set report properties as=20
follows:<BR>> =20
Width: &= nbsp; &n= bsp; &nb=sp; =20
8.5 (portrait) =
11<BR>>(landscape)<BR>> =20
Height: = &= nbsp; &n=bsp; =20
11 (portrait) =
8.5<BR>>(landscape)<BR>> =20 Design in Character Units: = Yes<BR>> =20
Report=20
Width: &= nbsp; &n= bsp; =20
102 (portrait) =20
132<BR>>(landscape)<BR>> Report=20 Height: = &= nbsp; =20
66 (portrait) =20 51<BR>>(landscape)<BR>><BR>>With a Layout editor open, select = Format /=20
Layout Options / Rulers. Make<BR>>the following ruler=20 settings:<BR>> =20
Units: &= nbsp; &n= bsp; &nb=sp; =20 Character Cells<BR>> Horizontal=20 Size: &n= bsp; &nb= sp; =20
6<BR>> Vertical=20
Size: &n= bsp; &nb= sp; =20 12.0031<BR>> Grid=20 Spacing:  = ; = =20 1<BR>> Number of Snap=20 Points: = =20
1<BR>><BR>>Set the DESFORMAT system parameter to the name of an=20 appropriate printer<BR>>control file that will be found in your ora \ =
REPORT30 \ PRINTERS folder.<BR>><BR>>If doing landscape, set the=20
ORIENTATION system parameter to LANDSCAPE.<BR>><BR>>If anyone else =
out=20
there has any suggestions, I am also very interested=20
in<BR>>hearing.<BR>>-- Shawn<BR>><BR>><BR>><A=20
href=3D"mailto:sokol_at_opsb.ru">sokol_at_opsb.ru</A> =
wrote:<BR>><BR>>> Hello=20
guru.<BR>>><BR>>> How I can print in character mode from =
Oracle=20
Reports 3.0 and<BR>>> how I can print to standard *.TXT =
(ASCII)=20
file<BR>>><BR>>> Thanks.<BR>>><BR>>> =
-----------=3D=3D=20
Posted via Deja News, The Discussion Network =
=3D=3D----------<BR>>> <A=20
href=3D"http://www.dejanews.com/">http://www.dejanews.com/</A>  =
; =20
Search, Read, Discuss, or Start Your Own<BR>></BODY></HTML>
------=_NextPart_000_003A_01BE13D1.21E45FA0-- Received on Thu Nov 19 1998 - 15:27:34 CET