|
This is a tutorial for implementing barcodes in Oracle Reports with the ID-Automation PL/SQL Barcode Library and barcode fonts. The barcode library is a PLL file that formats data from fields in the report to the barcode fonts to create a correct barcode. The library contains functions for Code 128, Code 39, Interleaved 2 of 5, UPC and EAN barcodes.
LICENSE NOTICE:
You may incorporate this component in your application only if you own a valid
license from ID-Automation, Inc. for the associated font. Redistribution of our
fonts and components requires a Developer License.
To Install ID-Automation barcode fonts on Windows for Oracle Reports, run the INSTALL.EXE file included in the font package or follow the font installation procedures. Installing Barcode fonts on Unix for Oracle Reports is described here . This example also uses the Code 128 A function that allows uppercase letters and converts lowercase letters to functions such as a return or tab. If you intend to use upper and lower case characters with code 128, please use the Code 128 B function instead.
This PLL library is compatible with any version of Oracle Reports that supports attached libraries. It was developed and tested against Reports 6i. If you use it in the database itself, then the version of the database would be any version that supports PL/SQL. PL/SQL source code is also provided for advanced Oracle programmers in the ID-Automation.pkg file.
- Open Oracle Reports Builder.
- Open the report rdf file that will contain the barcodes.
- Select the attached libraries option.
- Press the create button (Green Plus symbol) on the left toolbar.
- In the dialog box, select the File System radio button, click on the Browse button.
- Download the Oracle Barcode Library Package which contains the ID-Automation.pll file. After decompressing the file, save the ID-Automation.pll file to an appropriate directory.
- Select the ID-Automation.pll file from the operating system.
- Press the Attach Button.
- A dialog box will appear asking if you wish to remove the path. If you select �Yes�, you will need to re-attach the PL/SQL library to the report every time the report is opened. If you select "No", it will always look for the path in the same location. It is preferable to leave the library in the same directory as the report.
- You are now ready to use the functions in the library from any where in your report.
- Once the library is attached, the Object Navigator should look similar to the following under Attached Libraries:
Our barcode library contains the functions for linear barcodes described in the table below .
Method Name | Method Description |
Code128(Data, Number) | If you are not sure which Code
128 set is for your application, then use this one. This is a "Code
128 Auto" function that will automatically encode any data from ASCII
0 to ASCII 127. It will automatically switch to character set C for
numbers also. To encode alpha-numeric UCC/EAN-128, ASCII 202 or character � is entered as the FNC1 before each AI. For example, the UCC number of (8100)712345(21)12WH5678 should be entered as: �8100712345�2112WH5678. (Data, 0) formats barcode output string for the Code 128 barcode fonts. (Data, 1) returns the human readable data. (Data, 2) returns only the check digit. |
Code128A(Data ) | Use the characters from set B to print characters not on the keyboard; the scanner will scan characters from set A. |
Code128B(Data ) | Returns codes formatted to the Code 128 character set B. Formats output to the Code 128 barcode fonts. |
Code128C(Data ) | This code128 function "interleaves" numbers into pairs for high density. |
I2of5(Data ) | This function "interleaves" numbers into pairs for high density without check digits and formats the return string to the Interleaved 2 of 5 font. |
I2of5Mod10(Data, Number) | (Data, 0) performs the mod10
checksum calculation for increased accuracy and formats the return string
to the Interleaved 2 of 5 font. MOD 10 checksums are required by USPS
for special services and for SSC-14 when using Interleaved 2 of 5 for
that purpose. (Data, 1) returns the human readable data with the MOD10 check digit included. (Data, 2) returns the MOD10 check digit. |
Code39(Data ) | Formats the output to print using Code 39 fonts. |
Code39Mod43(Data, Number) | (Data, 0) performs the mod43
checksum calculation for increased accuracy and then formats the output
to print using Code 39 fonts. The mod43 checksum is usually required
for LOGMARS applications. (Data, 1) returns the human readable data with the check digit included. (Data, 2) returns only the check digit. |
EAN13(Data ) | Enter EAN-13 with or without a check digit, add-ons are supported. If a check digit is passed in it is ignored, recalculated, and added to the encoded output. Formats output to the UPC/EAN barcode font. |
EAN8(Data ) | Enter exactly 7 characters (EAN-8 without the check digit). Formats output to the UPC/EAN barcode font. |
Postnet(Data, Number) | Enter a single string of Zip,
Zip + 4 or Zip + 4 + Delivery Point. The input for Data must
be a number and can include dashes and spaces. (Data, 0) formats output to the POSTNET barcode fonts. (Data, 1) returns the human readable data with the check digit included. (Data, 2) returns only the check digit. |
UPCa(Data ) | Enter UPC-A with or without a check digit, add-ons are supported. Formats output to the UPC/EAN barcode font. |
Special ! Free Choice of Complete Excel Training Course or Excel Add-ins Collection on all purchases totaling over $70.00. ALL purchases totaling over $150.00 gets you BOTH! Send payment proof to [email protected] 31 days after purchase date.
See Also: Barcodes - Fonts, ActiveX, labels and DLL's Index. Barcode MICR CMC-7 || Codabar Barcode Font || Code 11 Barcode Font || Code 128 Barcode Font || Code 25 Barcode Font || Code 39 Barcode Font || Code 93 Barcode Font || Code39 Full ASCII Barcode Font || Data Matrix Encoder || Interleaved 25 Barcode Font || MICR E13B Font || MSI Barcode Font || OCR Font || PDF417 Encoder || Telepen Barcode Font || UPC EAN Barcode Font
Instant Download and Money Back Guarantee on Most Software
Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!
Microsoft � and Microsoft Excel � are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft
Some of our more popular products are below...
Convert Excel Spreadsheets To Webpages | Trading In Excel | Construction Estimators | Finance Templates & Add-ins Bundle | Code-VBA | Smart-VBA | Print-VBA | Excel Data Manipulation & Analysis | Convert MS Office Applications To...... | Analyzer Excel | Downloader Excel
| MSSQL Migration
Toolkit |
Monte Carlo Add-in |
Excel
Costing Templates