Mailing label from the Crystal Report

By | August 30, 2021

In Sage X3, there various reports in each module which are printed by users whenever applicable. Also for warehouse users it mandatory to print the labels and stick on the products/Assets. One of our client has requested to design barcode label for their assets in their inventory.

In this blog, we will see how to print the Barcode Labels by using the Crystal Reports. This report get prints all the labels as per the selected parameter range given by the user. This can be handled by using the “Mailing label report wizard” option which is available in the crystal report.

For this we have created a new custom screen name as “Barcode Generation”, from this screen user can print the barcode report. To print the report, we have created the filter parameter of “From Site” and “To Site”, “From Asset and “To Asset”, “From Physical Asset” and “To Physical Asset” from which user can filters the list of Barcode according to the selected range of the parameters.

New Stuff: How to do setup and process for loaned products in Sage X3

Barcode Generation Screen
Barcode Generation Screen

Follow the steps below:

Step 1: Open the Crystal Reports

Step 2: Select the “Mailing label report wizard” option, refer the below screenshot:

Home Screen
Home Screen

Step 3: Go to File -> Page Setup -> Page Option and adjust the size of the page like Margins, Horizontal and Vertical size according to the size of the label paper.
For Example, let’s assume the size of a label sheet is 4 x 1 inches, with 0 margins (left, right, top & bottom) as shown in the below screenshot:

Page Setup
Page Setup

Step 4: We have to adjust the detail line too, according to the size of the single label and give a gap between the labels. Here let’s assume the size of a single label will be 1.985 X 0.983 in.
To Adjust the size of the detail line: Right click on the Section->Section Expert->Layout.
We can adjust the size of the detail line from the “Detail Size” section and to adjust the gap we have to use the section “Gap Between Details”.
We can also give the printing direction from “Printing Direction” section.
If we want the labels to be printed sideways first and then downwards, then we need to select “Across then Down” radio button and if we want the labels to be printed downwards first and then sideways then we need to select “Down then Across” radio button.

Section Expert
Section Expert

Step 5: On the LHS is where we create the desired format for the Barcode, and the same will be displayed on the RHS.

Design
Design

Step 6: Create a group by on the field that gives the barcode, so that each barcode will get printed on a new page. Here we have created a group by based on PHYREF_0 and then created the barcode of the same field.

To get the Barcode of a field, place the field inside the formula like ‘‘ & {your field} & ‘‘ and drag and drop it on the design page.

Formula Editor
Formula Editor

After that right click on the formula field -> Format Editor, Go to Font section and change the text font to “Code39AzaleaRegular3”. By using this, we will get the field which is converted to the barcode. Refer below screenshot:

Format Editor
Format Editor

Step 7: Once done with the above steps from the crystal report, we have to save the report and deploy the report in the respective folder and then print this report from the screen.

Output
Output

As you can see from the above report output, the barcode is getting printed in “Across then Down” fashion with the help of Mailing Label option from the crystal report.