Labels Dymo 1" x 2-1/8" for N Copies per Product ID

This report prints labels for all defined products, by product ID. The labels show the Product ID, Mfg Product ID, and Description, in addition to the barcode itself, which is the Product ID.

The template includes filter options for category and manufacturer, since companies with large numbers of items may need to print labels in multiple batches to avoid making a single document that has too many pages.

The labels are 1" x 2-1/8" suitable for a label printer that prints on rolls.

{
  "attrName": "##other003",
  "name": "Labels Dymo 1\" x 2-1/8\" for N copies per product ID",
  "group": "##other",
  "sortOrder": 62001,
  "type": "report/pivotTable",
  "params": {
    "dataSet": "product",
    "filters": [
      {
        "filter": "productStatus",
        "param": [
          "PRODUCT_ACTIVE"
        ]
      },
      {
        "filter": "productProductUrl",
        "isParameter": true,
        "param": "##null"
      },
      {
        "filter": "productCategory",
        "isParameter": true,
        "param": "##null"
      },
      {
        "filter": "productManufacturer",
        "isParameter": true,
        "param": "##null"
      }
    ],
    "rowDimensions": [
      {
        "dimension": "productProductId",
        "width": 0.0254
      },
      {
        "dimension": "productDescription",
        "width": 0.0254,
        "group": "sheet"
      },
      {
        "dimension": "productMfgProductId",
        "width": 0.0254
      }
    ],
    "metrics": [],
    "namedParameters": [
      {
        "key": "parameter_000",
        "label": "Quantity per label"
      }
    ],
    "pageTemplate": {
      "paperLabel": "##custom",
      "paperLabelSizeWidth": "2.125in",
      "paperLabelSizeHeight": "1.000in",
      "paperLabelSize": [
        0.05397501472438402,
        0.02540000692912189
      ],
      "sheetPrintMultiple": {
        "type": "##variable",
        "variable": "parameter_000"
      },
      "templateContent": "\n<div style=\"position:absolute;top:0.1in;left:0.1in;width:100in;font-size:10pt;font-weight:bold;text-align:left;line-height:1.1;\">\n  {{productProductId}}\n</div>\n\n<div style=\"position:absolute;top:0.1in;left:0.1in;width:1.9in;font-size:8pt;text-align:right;\">\n  {{productMfgProductId}}\n</div>\n\n<div style=\"position:absolute;top:0.3in;left:0.15in;width:1.8in;height:0.44in\">\n  <img style=\"display:block;width:1.8in;height:0.44in;\"  \n       src=\"barcode:quiet=0,{{productProductId}}\">\n</div>\n\n<!-- Display bottom left corner -->\n<div style=\"position:absolute;top:0.76in;left:0.1in;width:100in;font-size:10pt;text-align:left;\">\n  {{productDescription}}\n</div>\n\n<br> <br> <br> <br> <br> <br> <br> <br> \n<br> <br> <br> <br> <br> <br> <br> <br>"
    }
  }
}