OraFAQ Forum: Reports & Discoverer » Barcode IN Report Builder

Home » Developer & Programmer » Reports & Discoverer » Barcode IN Report Builder (Reports 6i)

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

Barcode IN Report Builder [message #358575]

Tue, 11 November 2008 21:42

maddisravan
Messages: 3
Registered: November 2008

Junior Member

Hi,

This is sravan. My task is report having a barcode font. Could you please give me Details of

1)Drivers Support for Barcode font.

2)Print Style for barcode font.

Report message to a moderator

Re: Barcode IN Report Builder [message #358669 is a reply to message #358575]

Wed, 12 November 2008 02:10

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Search the board; such a question has been asked and answered before.

In a few words: install a barcode font and use it in Paper Layout Editor, while creating the report (just as you'd use Courier or Tahoma or ...). One of these fonts is IDAutomation.com Code39; it requires '*' sign as a prefix and a suffix of the string you are displaying as a barcode (otherwise barcode readers might not be able to read it).

Here's just an example created on Scott's EMP table; "empno" column is displayed as a number and as a barcode.

/forum/fa/5277/0/

This is a query used to create such an output:

select empno, 
       '*' || empno || '*' empno_barcode, 
       ename
from emp

Attachment: barcode.PNG
(Size: 2.32KB, Downloaded 4090 times)

Report message to a moderator

Re: Barcode IN Report Builder [message #358857 is a reply to message #358669]

Wed, 12 November 2008 13:03

dlwixon
Messages: 92
Registered: September 2008

Member

Thanks! The astrisk before and after solved my problem.

Report message to a moderator

Re: Barcode IN Report Builder [message #377553 is a reply to message #358669]

Tue, 23 December 2008 08:10

sanjay833
Messages: 9
Registered: March 2005
Location: India

Junior Member

Hi,

we are trying to create barcode in oracle report 6i by using IDautomation tool is any other way to create barcode in oracle report while we are also able to create to barcode in report by using Idautomation code128 but we are not ble to read through scanner .
Please help us to resolve this issue in oracle report
Find the attached RDF . what we made in oracle report 6i

Regards
Sanjay Chatterjee

Attachment: BARCODE128S.rdf
(Size: 52.00KB, Downloaded 1947 times)

Report message to a moderator

Re: Barcode IN Report Builder [message #377584 is a reply to message #377553]

Tue, 23 December 2008 10:51

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

So - did you add asterisks (*) before and after the code? (Can't view the RDF at the moment to check it myself.)

Report message to a moderator

Re: Barcode IN Report Builder [message #377958 is a reply to message #358575]

Fri, 26 December 2008 22:44

sanjay833
Messages: 9
Registered: March 2005
Location: India

Junior Member

Dear Sir,

We have tried with * as prefix and suffix and also tried with *# and #* as prefix and suffix but it didn't work. Barcode is getting generated but the Scanner is not reading the same. We are using Report Builder6i.

I have already sent you a rdf it was without any suffix or prefix. The same is sent to you again. Please see if you can help us.

Regards,

Sanjay Chatterjee
sanjay833@yahoo.com

Attachment: BARCODE12345.rdf
(Size: 52.00KB, Downloaded 1745 times)

Report message to a moderator

Re: Barcode IN Report Builder [message #377977 is a reply to message #377958]

Sat, 27 December 2008 05:37

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

It is weekend; I'm at home and I don't have barcode scanner here. I'll try to open the RDF you have attached on Monday, print a test page and see whether I can scan it or not.

Though, I believe I don't have IDAutomation code 128 font; is there a free version of the same? If so, please, attach it to your next message. Do NOT attach a commercial version.

Report message to a moderator

Re: Barcode IN Report Builder [message #385064 is a reply to message #358669]

Fri, 06 February 2009 05:44

sanjay833
Messages: 9
Registered: March 2005
Location: India

Junior Member

Using Report Builder 6i.
Wants to print Barcode Sticker using Barcode printer. We are working in Oracle Apps 11i so needs to register the report (Barcode Sticker) in Apps. Please help me for the same.

Regards,
Sanjay

Report message to a moderator

Re: Barcode IN Report Builder [message #385227 is a reply to message #358575]

Sun, 08 February 2009 01:16

sanjay833
Messages: 9
Registered: March 2005
Location: India

Junior Member

Dear Sir,

I have generated a Report with Barcode which is getting printed on Laser Printers but not getting printed with Barcode Printers. Barcode Printers are Tharmal Printer. We are using following printers here

1. Thermal Transfer Printer Z4M Plus Make : Zebra
2. Thermal Transfer Printer TLP 2844 Make : Zebra

Please advice

Sanjay Chatterjee

Report message to a moderator

Re: Barcode IN Report Builder [message #396266 is a reply to message #358669]

Sun, 05 April 2009 23:42

sanjay833
Messages: 9
Registered: March 2005
Location: India

Junior Member

Dear Sir,

Can you send me the Oracle Function to convert a string Barcode with Symbology Code 39.

Please note that I don't need the symbology with Mod 43.

Regards,
Sanjay Chatterjee

Report message to a moderator

Re: Barcode IN Report Builder [message #396309 is a reply to message #396266]

Mon, 06 April 2009 01:55

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I'm sorry, but I don't understand what you are saying. Terms as "symbology code 39" or "symbology with mod 43" are unknown to me. What "Oracle function" are you talking about? A built-in one? If it exists, I can't recall its name. If it is a user-defined one, what should it do?

Report message to a moderator

Previous Topic:	Half Page Report
Next Topic:	'Layout Editor' Qtn...

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 09 06:06:09 CST 2025