New User? Sign Up  |  Sign In  |  Help
Barcode support and
tutorials from IDAutomation
and the community.
Click for the BBB Business Review of this Computers Hardware, Software & Services in Tampa FL
Resolved Questions Bookmark and Share
danigome

Oracle Reports example

Can you please send me and example of Oracle Reports formula to display barcode data "(02)88429259195141(37)88"?
I need to generate GS1 128 barcode and I don't know if I need to select barcode font in Paper Layout, include parentheses in data to encode, select ApplyTilde, etc.

Thanks.


06-12-14     1866 day(s) ago    

  Report Abuse

 

Ben

Best Answer

To generate GS1-barcodes in Oracle Reports, we have a couple of solutions:

NOTE: The solutions will only work in Oracle 9i and up.


The Java Component can generate GS1-128 barcodes as an image in Oracle Reports.

The Universal Font Package with PLL is also another option.



Posted 1866 day(s) ago

()
()
  Report Abuse
 
Find Interesting
 
Email to Others
 
Bookmark
 
Subscribe to Answer Alert
No comments yet.     Be the first to comment.
Other Answers (8)

Ben
The Universal Font Package includes PostScript Fonts as well as many other font file types.


PostScript files are located in the path
IDAutomation_UniversalFontAdvantageIDAutomation_UniversalFontAdvantagePostScript
and include .afm, .pfa, and .pfm files.


For Windows users:

1. In the Universal Font Package product folder named IDAutomation_UniversalFontAdvantage, double-click the sub folder named IDAutomation_UniversalFontAdvantage:
image


2. Double-click the PostScript folder.
image


3. There are several IDAutomation Universal PostScript files including .pfm
image

Posted 1861 day(s) ago

()
()
   Report Abuse

danigome
I need "font_name.pfm" and "font_name.pfb" to embed fonts in pdf generated by Oracle Reports, as you can see in the link you send me. Where can I get this files?

Thanks.

Posted 1861 day(s) ago

()
()
   Report Abuse

Ben
Danigome,

As mentioned in my previous message, the actual font is not responsible for the embedding process and all the PLL does is encode the data (it is not related to the display of the barcode other than the encoding).

Verify that when you are embedding as a PDF that you are pointing to the right font. I know that many users have this issue whether they are using barcode fonts or custom fonts. Sometimes the actual font is not selected to be embedded. Beyond this information, there is not much additional support that I can provide.

Oracle Font Embedding

Posted 1865 day(s) ago

()
()
   Report Abuse

danigome
I've been using older IDAutomation font in Oracle Reports pdf for several years without any problem. I have only changed the older pll for the newer one (and changed the function call method). Please, tell me what I have to change to get the barcode in the Oracle pdf report, instead of the characters.

Thanks.

Posted 1865 day(s) ago

()
()
   Report Abuse

Ben
If you are viewing in a PDF or an application that requires the font to be embedded, check to make sure it is actually embedded. If not, then you will only see the encoded data that you described: EBJMAIFFEMCAAEKAAOKEAFCBIEICECMAICECAMIBJEBANGIAH

Neither the font nor the encoder is responsible for this portion.

If you are printing directly to the printer (non-PDF), verify the printer drivers are updated.

Fonts do not Embed

Posted 1865 day(s) ago

()
()
   Report Abuse

danigome
I have selected "IDAutomation Uni L" font in Oracle Reports and when I print the barcode I get several characters instead of a barcode.
The data in the function IDAUTOMATION_UNI.CODE128(~2120298429259102337~212371,TRUE);
generates "EBJMAIFFEMCAAEKAAOKEAFCBIEICECMAICECAMIBJEBANGIAH".
I have installed universal fonts and I can't see the barcode.

Thanks.

Posted 1865 day(s) ago

()
()
   Report Abuse

Ben
When using an IDAutomation Universal function, the IDAutomation Universal Font such as IDAutomation Uni L (or demo version IDAutomation SUni L) must be applied to the encoded data.


image

Posted 1865 day(s) ago

()
()
   Report Abuse

danigome
I'm trying to print GS1-128 barcode in Oracle Reports 11 with data (02)88429259082359(37)110. I'm using tilde option and encode the data using the next function:
IDAUTOMATION_UNI.CODE128(~21288429259082359~21237110,TRUE);
The barcode is generated but is huge (half of page). I'm using barcode font IDAUTOMATIONC128M.
┬┐What I'm doing wrong?

Thanks.

Posted 1865 day(s) ago

()
()
   Report Abuse
Email this question link to friends
You must enter an email address, if name is entered or vice-versa for each friend.
Friend #1 -
Friend #2 -
Friend #3 -
Friend #4 -
Friend #5 -
  Your comment on this question
  |         |  
bold  italic  underline  strike       big  small       superscript  subscript 
  Allows to add a link. Added links would only be converted to actual clickable link, when the domain of the link is white-listed by administrator.
Caption :
Link URL :
(Must starts with "http://")
Add  |   Cancel
  Allow to insert an image. Must be among the following file types - *.jpg, *.gif, *.png & *.bmp.
Image Url :   Upload New
(Image url must always starts with " http:// ")
Width : pixels
(Must not be greater than 450px. Enter 0px for no resize)
Add  |   Cancel
  Allow to insert YouTube video. Insert the video embed code.
Embed Code :
Add  |   Cancel
Up to 5000 Characters are allowed. Current Count: 0
  Your comment on this answer
  |         |  
bold  italic  underline  strike       big  small       superscript  subscript 
  Allow you to add a link. Added links would only be converted to actual clickable link, when the domain of the link is white-listed by administrator.
Caption :
Link URL :
(Must start with "http://" or "https://")
Add  |   Cancel
  Allow to insert an image. Must be among the following file types - *.jpg, *.gif, *.png & *.bmp.
Image Url :   Upload New
(Image url must always start with "http://" or "https://")
Width : pixels
(Must not be greater than 450px. Enter 0px for no resize)
Add  |   Cancel
  Allow to insert YouTube video. Insert the video embed code.
Embed Code :
Add  |   Cancel
Up to 5000 characters are allowed. Current Count: 0

You may answer and comment on any thread according to the Terms and Conditions.

 © Copyright 2019 IDAutomation.com, Inc., All Rights Reserved. Legal Notices.

 Barcode Fonts | Components | Scanners | Support | Contact Us
Training Videos on YouTube Join us on Google Plus Join us on LinkedIn Follow us on Twitter Like us on Facebook