Software Search, Categories and Specials
Ozgrid, Experts in Microsoft Excel Spreadsheets
Javascript DHTML Drop Down Menu Powered by dhtml-menu-builder.com

Active DataXL - Download

 

AnalyserXL - Download

 

DownloaderXL - Download

 

Smart VBA - Download

 

TraderXL - Download

Oracle Reports Barcode FAQ & Tutorial

Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS

 

 All purchases can be made via Id-Automations site

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.

Step 1 - Install the Bar Code Fonts

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.


Step 2 - Oracle Reports Barcode PLL Library Installation

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.

  1. Open Oracle Reports Builder.
  2. Open the report rdf file that will contain the barcodes.
  3. Select the attached libraries option.
  4. Press the create button (Green Plus symbol) on the left toolbar.
  5. In the dialog box, select the File System radio button, click on the Browse button.
  6. 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.
  7. Select the ID-Automation.pll file from the operating system.
  8. Press the Attach Button.
  9. 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.
  10. You are now ready to use the functions in the library from any where in your report. 
  11. Once the library is attached, the Object Navigator should look similar to the following under Attached Libraries:

The IDAutomation.com Barcode Library for Oracle Reports when attached.

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: 81007123452112WH5678.
(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.
  1. First you must add a Formula Column to your report by using the Data Model option of the Report Layout, clicking the Formula Column button on the toolbar, and sizing the column in the layout area.

  1. The properties of the newly added Formula Column need to be adjusted to call the PL/SQL function from the ID-Automation.pll library.  You may access the property page for the Formula Column by selecting the Formula Column and hitting the F4 key.  The following window will appear:

  1. Adjust the following properties:
    Name -- Choose a descriptive name for the Formula Column because you will need to reference the columns when designing the layout of the actual report
    Datatype -- This must be selected as Character from the drop-down menu
    Width -- Ensure the width of the field is large enough to hold all characters for the encoded data
  2. Click on the PL/SQL Formula button within the Property Inspector, so that you may call the appropriate ID-Automation function.  You will see a screen similar to the following:

  1. At the cursor, insert the appropriate ID-Automation PL/SQL function call.  This function will add the appropriate Start and stop characters, encode the data (if necessary), and add the check sum character (if required).  For example, if you are using character set A of Code 128, it would look like the graphic below. This Code 128 A function 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.

  1. Please note in the above example, that a constant value (Code128Test) was passed into this function, you may substitute the appropriate character field from your database, if necessary.
  2. Click Close in the above window and ensure your report has been saved.
  3. To add this Formula Column to your report, you must switch to Paper Layout mode for the report and add a Field object to the report by clicking the appropriate item in the toolbar and dragging into position on the report.

  1. Once the Field has been added to the report, it needs to be linked to the Formula Column that was created earlier.  To link the Field to the Formula Column, select the field and hit the F4 button to bring up the Property Inspector for the Field. 
  2. Adjust the following properties:
    optional Name -- Choose a descriptive name for the field
    required Source -- Select the name of Formula Column that was created earlier
  3. Modify the font for the field to the barcode font installed from ID-Automation.

 All purchases can be made via Id-Automations site

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