Home » Developer & Programmer » Reports & Discoverer » How can I print the EAN 13 barcode with Oracle Report
How can I print the EAN 13 barcode with Oracle Report [message #204434] Mon, 20 November 2006 13:14 Go to next message
Hine
Messages: 16
Registered: October 2006
Junior Member
Dear,

I have Oracle Developers 9i and I would like to print the ENA 13 barcode for my products.
It's possible to use Oracle report only and how?
I would like to use laser priner A4 format.

Regards!

Hine
Re: How can I print the EAN 13 barcode with Oracle Report [message #204443 is a reply to message #204434] Mon, 20 November 2006 15:56 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
First, make sure you have a font which is capable of displaying a bar code. If you don't have any, either purchase one or download a free version found somewhere on the internet (note: not all of those free versions support the complete character set - some of them offer only numbers, for example).

Then, in Reports Builder, write a report as you always have. In the Paper Layout, select field which should be displayed as a bar code and change its font from, for example, <Arial> to <My_fancy_bar_code_font>.

One more thing: some bar code readers will NOT read bar code unless this string starts and ends with an asterisk sign (*). So, if you'd like to display '123-456-7890' using a bar code, in Report Query select '*' || '123-456-7890' || '*'.
How can I print the EAN 13 barcode with Oracle PL/SQL [message #205494 is a reply to message #204434] Sat, 25 November 2006 04:26 Go to previous messageGo to next message
Hine
Messages: 16
Registered: October 2006
Junior Member
Dear!

I woul like to print the barcod EAN13 with PL/SQL procedure.
Like:
<httml>
<object classid="clsid:8E515447-86DF-11D3-A630-444553540001" id="Barcode">
<param name="Caption" value="12345678901"></object>
</html>

The problem is, becouse I can't set the barcode font!
I can't use the barcode font in PL/SQL ORacle

Regards!

Hine

Re: How can I print the EAN 13 barcode with Oracle PL/SQL [message #205495 is a reply to message #205494] Sat, 25 November 2006 04:52 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
This is a whole different story than your first post (remember, you mentioned Developer 9i). Now you'd like to do it using a PL/SQL procedure. But, the code you posted is not PL/SQL.

What do you, exactly, want?

Whatever you decide, I might, perhaps, be able to help you with Oracle Reports Builder. Anything else - sorry.
Re: How can I print the EAN 13 barcode with Oracle PL/SQL [message #205497 is a reply to message #205495] Sat, 25 November 2006 05:04 Go to previous message
Hine
Messages: 16
Registered: October 2006
Junior Member
Both,
I have the application, that can be use in to manner,
1) - as Oracle Developers v9i with appliaction server
2) - as PL/SQL with standard HTML

Regards!

Hine
Previous Topic: Trial Balance Report
Next Topic: cascading prompt style LOV in report parameter form
Goto Forum:
  


Current Time: Tue Nov 26 16:16:39 CST 2024