Home » Developer & Programmer » Reports & Discoverer » Printing custom size (15 * 12 inch) paper in Dot matrix printer (Oracle 9i,Forms 6i)
Printing custom size (15 * 12 inch) paper in Dot matrix printer [message #647805] Mon, 08 February 2016 11:05 Go to next message
sikandar4u
Messages: 12
Registered: February 2016
Location: KOLKATA
Junior Member

I have requirement of printing oracle reports in large stationary paper through dot matrix printer.Paper size is 15 *12 inch.

I am using forms 6i as front-end tool to generate reports. I am using Run_report_object and previewing report and give it to priter(TVS HD 955).

But somehow full size report is not coming . I am new to Dot Matrix Printing. Any help will be highly appreciated.

Is converting report to pdf and then printing it a good option?




Re: Printing custom size (15 * 12 inch) paper in Dot matrix printer [message #647806 is a reply to message #647805] Mon, 08 February 2016 14:07 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Generally speaking (from my point of view): dot matrix printer = character mode report. If you convert it to a PDF, expect it to print as slow as a dead cow. (It won't cost much if you try it).
Re: Printing custom size (15 * 12 inch) paper in Dot matrix printer [message #647808 is a reply to message #647806] Mon, 08 February 2016 23:26 Go to previous messageGo to next message
sikandar4u
Messages: 12
Registered: February 2016
Location: KOLKATA
Junior Member
Thanks. could u please guide me how the printing can be possible in large size paper.
Re: Printing custom size (15 * 12 inch) paper in Dot matrix printer [message #647810 is a reply to message #647808] Tue, 09 February 2016 00:06 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Did you set proper paper size? Here:

/forum/fa/13018/0/

  • Attachment: rep_wh.png
    (Size: 6.59KB, Downloaded 2791 times)
Re: Printing custom size (15 * 12 inch) paper in Dot matrix printer [message #647811 is a reply to message #647810] Tue, 09 February 2016 00:52 Go to previous messageGo to next message
sikandar4u
Messages: 12
Registered: February 2016
Location: KOLKATA
Junior Member
/forum/fa/13019/0/Please see the attachment.since there are 11 columns to be displayed in report I have given size as 13*8.5
Re: Printing custom size (15 * 12 inch) paper in Dot matrix printer [message #647812 is a reply to message #647811] Tue, 09 February 2016 00:56 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Paper size is 15 x 12. You set the report's paper size to 13 x 8.5. These values don't match, so I'd try to fix that first.
Re: Printing custom size (15 * 12 inch) paper in Dot matrix printer [message #647824 is a reply to message #647812] Tue, 09 February 2016 10:56 Go to previous messageGo to next message
sikandar4u
Messages: 12
Registered: February 2016
Location: KOLKATA
Junior Member
Hi,

I had tried changing paper size to 15*12 inch but that didn't work. In preview mode it is displaying full report while printing some portion get cropped .

I had given the paper size as A3,sanfold 15*12. But they didn't work.

Can u please guide me further in this regard.
Re: Printing custom size (15 * 12 inch) paper in Dot matrix printer [message #647846 is a reply to message #647824] Wed, 10 February 2016 00:06 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Did you stretch report's margins as far as possible? Here:

/forum/fa/13020/0/

Re: Printing custom size (15 * 12 inch) paper in Dot matrix printer [message #647937 is a reply to message #647846] Fri, 12 February 2016 01:33 Go to previous messageGo to next message
sikandar4u
Messages: 12
Registered: February 2016
Location: KOLKATA
Junior Member
Thanks. As per your suggestion I have stretched the margin as far as possible . The solution worked fine for a report. later when I made some some changes to that report like fontsize change .Then suddenly It didn't work . Since then I am trying but with no success.Need your help in this regard and please suggest is there any trick involved in this.
Re: Printing custom size (15 * 12 inch) paper in Dot matrix printer [message #647939 is a reply to message #647937] Fri, 12 February 2016 01:40 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Larger font needs more space. If fields and/or frames are set to be variable (regarding the "Elasticity" property), then they might affect the output. See whether setting the elasticity to "fixed" helps.
Re: Printing custom size (15 * 12 inch) paper in Dot matrix printer [message #648038 is a reply to message #647939] Mon, 15 February 2016 06:07 Go to previous messageGo to next message
sikandar4u
Messages: 12
Registered: February 2016
Location: KOLKATA
Junior Member
Thank u very much . it worked . I want to print the report in character mode. while running the report it shows following error :

Font specified by report cannot be found for character set specified by NLS_LANG . Can u please help how to sort out this issue ?
Re: Printing custom size (15 * 12 inch) paper in Dot matrix printer [message #648039 is a reply to message #648038] Mon, 15 February 2016 06:09 Go to previous messageGo to next message
sikandar4u
Messages: 12
Registered: February 2016
Location: KOLKATA
Junior Member
Further , I want to print the report in pre-printed rolling paper. so what to do for that.
Re: Printing custom size (15 * 12 inch) paper in Dot matrix printer [message #648115 is a reply to message #648039] Tue, 16 February 2016 13:51 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As of the font problem:
Oracle

REP-1352: The fonts specified for this report cannot be found for the character set specified by NLS_LANG.

Cause: The NLS_LANG environment variable specifies a character set for which no font is available.

Action: You may choose a font that exists in the character set specified by NLS_LANG. Alternatively, you may use the Font Alias file to force an available font to be used instead of the one specified in the report.


As of the pre-printed paper: I don't think that you have to do anything special. As you've already set the report to character mode and fixed paper size, all you have to do is to adjust the printer (i.e. micro-nudge the paper up or down so that everything prints into its cells).
Previous Topic: rdf designed using oracle 9i gives error REP-34551 while running in oracle 10g
Next Topic: Letter report printing in oracle reports
Goto Forum:
  


Current Time: Thu Mar 28 04:38:18 CDT 2024