Home » Developer & Programmer » Reports & Discoverer » Barcode IN Report Builder (Reports 6i)
Barcode IN Report Builder [message #358575] Tue, 11 November 2008 21:42 Go to next message
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.

Re: Barcode IN Report Builder [message #358669 is a reply to message #358575] Wed, 12 November 2008 02:10 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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 3754 times)
Re: Barcode IN Report Builder [message #358857 is a reply to message #358669] Wed, 12 November 2008 13:03 Go to previous messageGo to next message
dlwixon
Messages: 92
Registered: September 2008
Member

Thanks! The astrisk before and after solved my problem.
Re: Barcode IN Report Builder [message #377553 is a reply to message #358669] Tue, 23 December 2008 08:10 Go to previous messageGo to next message
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
Re: Barcode IN Report Builder [message #377584 is a reply to message #377553] Tue, 23 December 2008 10:51 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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.)
Re: Barcode IN Report Builder [message #377958 is a reply to message #358575] Fri, 26 December 2008 22:44 Go to previous messageGo to next message
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

Re: Barcode IN Report Builder [message #377977 is a reply to message #377958] Sat, 27 December 2008 05:37 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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.
Re: Barcode IN Report Builder [message #385064 is a reply to message #358669] Fri, 06 February 2009 05:44 Go to previous messageGo to next message
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
Re: Barcode IN Report Builder [message #385227 is a reply to message #358575] Sun, 08 February 2009 01:16 Go to previous messageGo to next message
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
Re: Barcode IN Report Builder [message #396266 is a reply to message #358669] Sun, 05 April 2009 23:42 Go to previous messageGo to next message
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

Re: Barcode IN Report Builder [message #396309 is a reply to message #396266] Mon, 06 April 2009 01:55 Go to previous message
Littlefoot
Messages: 21806
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?
Previous Topic: Half Page Report
Next Topic: 'Layout Editor' Qtn...
Goto Forum:
  


Current Time: Fri Mar 29 04:47:39 CDT 2024