Barcodes in reports

[sikandar]

The following link is a very nice place to get info of the barcodes usage in oracle reports, if still any further query then pl post it under this thread.

http://www.idautomation.com/fonts/tools/oracle/

[admin]

<b><font color="blue">Interleaved 2 of 5 in Oracle reports</font id="blue"></b>
To use Interleaved 2 of 5 in Oracle reports is not as simple as 3 of 9 and you need a procedure to do so. Few years back I had developed a procedure and now you can use 2 of 5 very easily after using it.

Step 1
Get Interleaved barcode font for windows and install on your machine.

Step 2
Create the following function in your schema,

CREATE OR REPLACE FUNCTION barcode25 (p_data VARCHAR)
RETURN VARCHAR
IS
barcode_data VARCHAR2 (6);
DATA VARCHAR2 (8) DEFAULT LPAD (p_data, 8, 0);
BEGIN
--Script required for Barcode Interleaved 2 of 5 in Oracle
-- www.erpstuff.com
--Sikandar Hayat
--18/03/2002
--------------------------------------------------------------------
--Take the pairs of data and get the ASCHII value
FOR i IN 1 .. LENGTH (DATA)
LOOP
IF MOD (i, 2) = 1
THEN
IF SUBSTR (DATA, i, 2) < 90
THEN
barcode_data := barcode_data || CHR (SUBSTR (DATA, i, 2) + 33);
ELSE
barcode_data := barcode_data || CHR (SUBSTR (DATA, i, 2) + 71);
END IF;
END IF;
END LOOP;

RETURN ('{' || barcode_data || '}');
END;
/

Step 3
Create a report while using the following query as sample,

SELECT barcode25 ('12345678')
FROM DUAL;

Step 4
Change the font of your field in reports to Barcode 2 of 5.

Step 5
Execute the report and print the barcode after adjusting the size you want it to be.

Step 6
Scan it and it should display the same data you used in your query.

Note: The above procedure will be used for length upto 8.

Let me know if still any issue.

[Waseem]

Code 3 of 9 Barcode are easily available for Download. You Can Develop & Design your Own Barcode[3-9] In Oracle Reports as well as In Oracle Forms using a Simple Code.

<b>Steps :</b>

1) Download Fonts From http://www.squaregear.net/fonts/free3of9.zip

2) Copy Fonts Files to Fonts Directory [ C:\Winnt\Fonts | C:\Windows\Fonts ]

3) Create Employee Table.
<pre id='pre'><font size=2>
EMP_CODE EMP_NAME EMP_SALARY
-------- -------- ----------
1800001 ALI 10000
1800002 ASIF 9000
1800003 KASHIF 8000
1800004 OWAIS 8200
</font></pre id='pre'>
4) Create a Simple Report for Checking Using Wizard.
<pre id='pre'><font size=2>
SELECT '*'||Emp_Code||'*' AS "BARCODE", Emp_Code, Emp_Name, Emp_Salary
FROM Employee
ORDER BY Emp_Code;
</font></pre id='pre'>
5) In Layout Editor, Select the Barcode Font from the Font-List for the Field "F_BARCODE" As "Free 3 of 9 Extended/Regular (True Type)".

6) Print & Check it on a Barcode Reader Machine. It Will Give you the Results.

Note : I have Just Tried it on Code 3 of 9 Barcode Type using GIGA-TMS INC's - TR515E.
http://www.gigatms.com.tw/products-detail.asp?pid=5


Best Regards
Muhammad Waseem Haroon
ocp_waseem@hotmail.com
mwaseem_haroon@yahoo.com
waseemharoon@gmail.com

[ahmadbilal]

How Can We Implement Code128In oracle Reports
I have sucessfuly implemented code 30 EAN128 but having problem with Code128 Due To Check Sum Calcultaion Issue.
If you Have Any Sample On Code 128 Kindly Send Me On My email Address
abmian1981@gmail.com

[admin]

What about sharing your experience of code 128?

[IDAutomation.com]

IDAutomation.com has just released their Native Barcode Generator for Oracle Reports. This is is an easy-to-use object that may be embedded into an Oracle Report to create bar-code images. Once installed, no other components, plug-ins or fonts need to be installed to create barcodes; it is the complete bar code generator that stays in the report, even when it is distributed or accessed from a server. Supported symbologies include Code 3 of 9, GS1-128, Interleaved 2 of 5, Code 128, POSTNET and PLANET. The fully functional evaluation version of the control is available for download at the IDAutomation.com website: http://www.idautomation.com/oracle/native/

[iftikhar]

Dear All,
If any one help me regarding barcod font website please.

[mohsinbaig]

email me on mohsinbaig@hotmail.co.uk i will send u bar codes fonts .. then enjoy ..