OraFAQ Forum: Reports & Discoverer » Printing custom size (15 * 12 inch) paper in Dot matrix printer

Home » Developer & Programmer » Reports & Discoverer » Printing custom size (15 * 12 inch) paper in Dot matrix printer (Oracle 9i,Forms 6i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Printing custom size (15 * 12 inch) paper in Dot matrix printer [message #647805]

Mon, 08 February 2016 11:05

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?

Report message to a moderator

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

Littlefoot
Messages: 21760
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).

Report message to a moderator

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

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.

Report message to a moderator

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

Littlefoot
Messages: 21760
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 1496 times)

Report message to a moderator

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

sikandar4u
Messages: 12
Registered: February 2016
Location: KOLKATA

Junior Member

Please see the attachment.since there are 11 columns to be displayed in report I have given size as 13*8.5

Attachment: report_property.PNG
(Size: 10.95KB, Downloaded 1390 times)

Report message to a moderator

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

Littlefoot
Messages: 21760
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.

Report message to a moderator

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

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.

Report message to a moderator

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

Littlefoot
Messages: 21760
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/

Attachment: rep_margin_2.png
(Size: 5.48KB, Downloaded 1333 times)

Report message to a moderator

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

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.

Report message to a moderator

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

Littlefoot
Messages: 21760
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.

Report message to a moderator

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

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 ?

Report message to a moderator

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

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.

Report message to a moderator

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

Littlefoot
Messages: 21760
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).

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 29 21:20:29 CDT 2023