Adding Barcodes to Reports - Revision history

ElliotD: Changed PONUmber to PONumber

2014-01-02T23:03:24Z

Changed PONUmber to PONumber

Marks at 13:03, 26 July 2011

2011-07-26T13:03:29Z

Marks at 12:59, 26 July 2011

2011-07-26T12:59:52Z

Marks at 12:57, 26 July 2011

2011-07-26T12:57:55Z

Marks: Created page with "You can add a barcode font to any report and have that barcode represent any data. First make sure you are working with a custom report rather than a standard report. See this a..."

2011-07-26T12:50:30Z

Created page with "You can add a barcode font to any report and have that barcode represent any data. First make sure you are working with a custom report rather than a standard report. See this a..."

New page

You can add a barcode font to any report and have that barcode represent any data.
First make sure you are working with a custom report rather than a standard report. See this article to create a custom report [[Duplicating Standard Reports for Custom Use]]

Go to the custom report in SME at Reports>Customize Reports and select Open Report Designer button.

Within the Report designer you can either add a fixed barcode or a barcode connected to some SME data.
[[File:BarcodeforReport.JPG]]
The first set is for adding a fixed barcode.
The second set is to add a barcode connected to SME data.
The third set showing on the second row to the left is new in SME7.1 for handling 2D barcodes.

To use the barcode, drag and drop one of these elements into the report and then

@@ Line 22: / Line 22: @@
 ) Select the barcode icon that is connected to the database and drag and drop into the report
-) Select this barcode element in the report and connect it to the PurchaseOrders table and the PONUmber Field
+) Select this barcode element in the report and connect it to the PurchaseOrders table and the PONumber Field
 [[File:BarcodePOnumber.JPG]]

@@ Line 15: / Line 15: @@
 Example:  Follow these steps to add the PO Number as a barcode:
 ) Duplicate an existing standard report [[Duplicating Standard Reports for Custom Use]] or edit an existing custom report. (Don't edit a standard report as it could get over-written in an update).
 ) Select Open Report Designer
 ) Select the barcode icon that is connected to the database and drag and drop into the report
 ) Select this barcode element in the report and connect it to the PurchaseOrders table and the PONUmber Field
 [[File:BarcodePOnumber.JPG]]
 ) Save the report.
 Now when you run this report, you will have a barcode label of the PO Number.

@@ Line 19: / Line 19: @@
 ) Select the barcode icon that is connected to the database and drag and drop into the report
 ) Select this barcode element in the report and connect it to the PurchaseOrders table and the PONUmber Field
-[[File:Example.jpg]]
+[[File:BarcodePOnumber.JPG]]
 ) Save the report.
 Now when you run this report, you will have a barcode label of the PO Number.

← Older revision		Revision as of 12:57, 26 July 2011
Line 10:		Line 10:
	The third set showing on the second row to the left is new in SME7.1 for handling 2D barcodes.		The third set showing on the second row to the left is new in SME7.1 for handling 2D barcodes.

−	To use the barcode, drag and drop one of these elements into the report and then	+	To use the barcode, drag and drop one of these elements into the report and then enter the label text or connect to the appropriate SME table and field.
		+
		+	For example, let's say that I want to add a barcode of the PO Number on a Purchase Order Report. This is useful with the [[Barcode for SME]] product to automatically barcode the PO number rather then entering it manually or scrolling to find it.
		+
		+	Example: Follow these steps to add the PO Number as a barcode:
		+	1) Duplicate an existing standard report [[Duplicating Standard Reports for Custom Use]] or edit an existing custom report. (Don't edit a standard report as it could get over-written in an update).
		+	2) Select Open Report Designer
		+	3) Select the barcode icon that is connected to the database and drag and drop into the report
		+	4) Select this barcode element in the report and connect it to the PurchaseOrders table and the PONUmber Field
		+	[[File:Example.jpg]]
		+	5) Save the report.
		+	Now when you run this report, you will have a barcode label of the PO Number.