Barcodes
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22190
Printed Date: 27 Apr 2024 at 11:45am
Topic: Barcodes
Posted By: TanyaCVV
Subject: Barcodes
Date 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.  ------------- Tanya Vander Vecht |
Replies:
Posted By: hilfy
Date 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 ------------- Proviti, Data & Analytics Practice http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics |