Resolved Questions

danigome

Oracle Reports example

Tagged With:-

Can you please send me an example of the 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 10.4 year(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 10.4 year(s) ago (0) (0) Report Abuse

Find Interesting

Email to Others

Bookmark

Subscribe to Answer Alert

Add Comment

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 subfolder named IDAutomation_UniversalFontAdvantage:

2. Double-click the PostScript folder.

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

Posted 10.4 year(s) ago

(0)

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 these files?

Thanks.

Posted 10.4 year(s) ago

(0)

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 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 10.4 year(s) ago

(0)

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 10.4 year(s) ago

(0)

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 10.4 year(s) ago

(0)

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 10.4 year(s) ago

(0)

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. Posted 10.4 year(s) ago (0) (0) Report Abuse

danigome

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

Thanks.

Posted 10.4 year(s) ago

(0)

Report Abuse

Categories

» Barcode Applications » Barcode Components ● Barcode FAQ » Barcode Fonts » Barcode Hardware ● Barcode Learning » Font Encoders ● General License Questions ● General Sales Questions » MICR & OCR Fonts » Other ● Product Updates » Saas Hosted Products

Email this question link to friends

Your comment on this question

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

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

My Profile

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