Home » Developer & Programmer » Reports & Discoverer » Problem while printing the report in landscape format (Windows XP, Oracle Form 6i, Oracle Report 6i)
Problem while printing the report in landscape format [message #604605] Wed, 01 January 2014 23:40 Go to next message
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 #604675 is a reply to message #604605] Thu, 02 January 2014 10:51 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Why did you set DESTYPE to printer? Wouldn't file be a better choice?
Re: Problem while printing the report in landscape format [message #604684 is a reply to message #604675] Thu, 02 January 2014 12:41 Go to previous messageGo to next message
lock_heart
Messages: 36
Registered: November 2013
Member
Will it be okay if DESTYPE is set to preview...
Re: Problem while printing the report in landscape format [message #604702 is a reply to message #604684] Fri, 03 January 2014 02:02 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Try it, and then you tell me.
Re: Problem while printing the report in landscape format [message #604708 is a reply to message #604702] Fri, 03 January 2014 04:23 Go to previous messageGo to next message
lock_heart
Messages: 36
Registered: November 2013
Member
By changing DESTYPE to preview I can check my report in landscape format and print it also....but I don't know why its not working correctly like report background engine suddenly get stopped...

Is there a reason behind this...
Re: Problem while printing the report in landscape format [message #605086 is a reply to message #604708] Tue, 07 January 2014 05:07 Go to previous messageGo to next message
lock_heart
Messages: 36
Registered: November 2013
Member
What is the maximum width which i appoint to report in main section of layout model...?
Re: Problem while printing the report in landscape format [message #605087 is a reply to message #605086] Tue, 07 January 2014 05:11 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I don't know. See whether Reports Help says something about it (click into the "Width" field and press F1).
Re: Problem while printing the report in landscape format [message #605089 is a reply to message #605087] Tue, 07 January 2014 05:20 Go to previous messageGo to next message
lock_heart
Messages: 36
Registered: November 2013
Member
Well it says 512inches, if i am printing report on a4 size page then which width should i use, currently i am using 11 but size of data is too much so its not fitting in report. Can you suggest me width size
Re: Problem while printing the report in landscape format [message #605091 is a reply to message #605089] Tue, 07 January 2014 05:33 Go to previous message
Littlefoot
Messages: 21806
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.
Previous Topic: how to show data in one page in two column instead of two page
Next Topic: Heading should print only in Main Section
Goto Forum:
  


Current Time: Thu Mar 28 05:04:39 CDT 2024