Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Barcodes Post Reply Post New Topic
Author Message
TanyaCVV
Newbie
Newbie
Avatar

Joined: 06 Sep 2016
Online Status: Offline
Posts: 17
Quote TanyaCVV Replybullet Topic: Barcodes
    Posted: 12 Jan 2017 at 2:18am
Good Morning,

I have a report I used in the past to generate barcodes that have stopped working.

The report is set up to show my inventory description, price and part # with the barcode above it that is dictated by either my SKU or if there is no SKU from the manufacturer the part #. The following formula is what I have used.
 if {UNIT_OF_MEASURE.UPC_ALTERNATE} = "" then
"*" + {INVENTORY.CODE} + "*"
else
"*" + {UNIT_OF_MEASURE.UPC_ALTERNATE} + "*"
I also have tried
 if {UNIT_OF_MEASURE.UPC_ALTERNATE} = "" then
"*"&{INVENTORY.CODE}&"*"
else
"*"&{UNIT_OF_MEASURE.UPC_ALTERNATE}&"*"
and I also have tried
 if {UNIT_OF_MEASURE.UPC_ALTERNATE}&"" then
"*"&totext{INVENTORY.CODE} + "*"
else
"*"&totext{UNIT_OF_MEASURE.UPC_ALTERNATE}&"*"

None of which have prevailed to work. I downloaded the Barcode functions from IDAutomation but I do not have Barcode fonts installed and am unsure if I need them. I did not have them in the past but the report was originally created by someone else that was with the company before me using only the first formula provided.

Can someone please help me to understand how to get this report working? Thank you.
Confused

Tanya Vander Vecht
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Quote hilfy Replybullet Posted: 13 Jan 2017 at 4:26am
In the formula editor, make sure that you have "Default values for nulls" turned on at the top-right of the screen.

Also, you WILL need to have a barcode font installed in order to get this to print correctly.

-Dell
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.