Generating and displaying barcodes in reports

Shop floor and warehouse reports require barcodes to be printed to handle goods. Many other reports also demand barcode strings to be printed in the report. This recipe is focused on building barcodes in SSRS. Here, we will attempt to print the barcode of the inventory batch table.

How to do it…

1. Create a simple query. Add the InventBatch table as the data source. Keep the fields selective only with InventBatch and ItemId.

2. This will be an RDP-based report, so create a temporary table with the fields shown in the screenshot. The fields Barcode and BarcodeHR will store encoded values and so must extend the EDT BarcodeString.

   

3. Create a contract class where the barcode setup field in the contract is used to choose the format of the barcode, such as Code39/EAN and so on:

    [
       DataContractAttribute,
       SysOperationGroupAttribute('BatchGroup', "Batch", '1')
   ]
   class PktInventBatchBarCodeContract
   {
       InventBatchId           batchId;
       BarcodeSetupId ...