Home » SQL & PL/SQL » SQL & PL/SQL » REPORT IN CHARACTER MODE (URGENT)
REPORT IN CHARACTER MODE (URGENT) [message #955] Fri, 15 March 2002 01:43 Go to next message
Manoj
Messages: 101
Registered: August 2000
Senior Member
hi experts,

I want to make a report in character mode what parameter i have to set it ple. explain in advance.
and is there any way to print a report in char. mode which is not in char. mode

thanx in advance
Re: REPORT IN CHARACTER MODE (URGENT) [message #956 is a reply to message #955] Fri, 15 March 2002 02:07 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
1. Start the Oracle Reports 2.5 Designer.
a. Connect to the database.
b. Create a new report by entering the SQL select statement in the Data Model screen.

2. In the Object Navigator:
a. Select the desired report.
b. right-click and select Properties to invoke the report properties.
c. Click on the Character Mode tab.
d. Make sure the 'Use Character units in Designer' option is checked.
This option specifies that the Layout Editor and its grid uses Character Cell units, as opposed to bitmap units.
e. Enter the desired Report Width X Height settings. This specifies the page dimensions for the report in character units. Standard settings include 80 X 66, 132 X 66, and 180 X 66. You must also specify these settings in the .prt file (printer definition file) that the DESFORMAT parameter refers to.
3. In the Object Navigator:
a. Click on the + sign next to Data Model.
b. Click on the + sign next to System Parameters.
c. Double-click on the MODE parameter.
d. Change the Initial Value setting from Default to Character. This ensures running the report in Character Mode.

4. Select Tools->Default Layout:
a. Select the desired layout.
b. Click on the Data Selection tab.
c. Examine the field names, field width, and field height.
Note that a field with width=9, height=1 occupies 9 X 1 = 9 character cells in the layout. Each character cell holds only one character, resulting in each character occupying same amount of space in the output. Hence, the output uses fixed fonts, as opposed to proportional fonts used in bitmapped reports. Note that each object gets mapped
exactly to a set of character-cells without any overlapping.
Previous Topic: Number Format???
Next Topic: Work Tables/Temp Tables
Goto Forum:
  


Current Time: Thu Apr 18 08:41:40 CDT 2024