Problem while printing the report in landscape format [message #604605] |
Wed, 01 January 2014 23:40 |
|
lock_heart
Messages: 36 Registered: November 2013
|
Member |
|
|
Hii..I created report with following properties :
1. Data Model
i. System Parameters
a. Orientation := LANDSCAPE
2. Layout Model
ii.. Main Section
a. Width = 12
b. Height = 8.5
c. Orientation = LANDSCAPE
d. Report Width = 132
e. Report Height = 66
Report is multi-pages i.e. data is going upto 5-6 pages. And its working fine. When I tried to run from report builder its working fine...But when I tried to call report from Oracle form 6i with following code..nothing happens..report is not showing in pdf format
DECLARE
pl_id ParamList;
BEGIN
pl_id := Get_Parameter_List('tmpdata');
IF NOT Id_Null(pl_id)
THEN
Destroy_Parameter_List( pl_id );
END IF;
pl_id := Create_Parameter_List('tmpdata');
Add_Parameter(pl_id, 'R_CODE', TEXT_PARAMETER, :LOCATION_DETAILS.loc_code);
Add_Parameter(pl_id, 'ORACLE_SHUTDOWN', TEXT_PARAMETER, 'YES');
Add_Parameter(pl_id, 'PARAMFORM', TEXT_PARAMETER, 'NO');
Add_Parameter(pl_id, 'DESTYPE', TEXT_PARAMETER, 'PRINTER');
Add_Parameter(pl_id, 'DESFORMAT', TEXT_PARAMETER, 'PDF');
Run_Product (REPORTS, :GLOBAL.rep_location_details, ASYNCHRONOUS, RUNTIME, FILESYSTEM, pl_id, 'NULL');
clear_button;
END;
Can anyone tell me what is wrong here...
|
|
|
|
|
|
|
|
|
|
Re: Problem while printing the report in landscape format [message #605091 is a reply to message #605089] |
Tue, 07 January 2014 05:33 |
|
Littlefoot
Messages: 21823 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
A4 size is - in landscape mode - 297 mm (width) x 210 mm (height). That's it, you can't modify A4's page size. If you have too much data to fit 297 mm, then you'll have to either use smaller font (don't go under size 8, it is too small to read) or break line and put some data into the second (or even third, ...) row.
|
|
|