article How to Insert a Barcode Into a Report in Member Articles https://community.qlik.com/t5/Member-Articles/How-to-Insert-a-Barcode-Into-a-Report/ta-p/1487293 <HTML><HEAD></HEAD><BODY><DIV><DIV><P>This tutorial illustrates how to create a report with barcodes. We will use <STRONG>EAN-13</STRONG> (International Article Number) barcode fonts. You need a field with the EAN13 code in your .qvw.</P><P><STRONG>You must have installed an EAN-13 font on your machine</STRONG>. If you haven't it download one and installed it, refer to "<A href="http://windows.microsoft.com/en-us/windows-vista/install-or-uninstall-fonts" target="_blank">Install or uninstall fonts</A>".</P>&nbsp;&nbsp;&nbsp;&nbsp; </DIV>&nbsp;&nbsp;&nbsp;&nbsp; <DIV>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <DIV class="step-container">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <H2 class="step-title">Start New Excel Report Template and Add the Barcode Table</H2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <DIV class="step-image-container">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <IMG alt="Start-New-Excel-Report-Template-and-Add-the-Barcod.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/106638_Start-New-Excel-Report-Template-and-Add-the-Barcod.png" style="height: auto; width: auto;" />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </DIV>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <DIV class="step-instructions"><P>After adding <STRONG>Products Barcode </STRONG>as Table:</P><P>Drag the <STRONG>ProductID</STRONG>, <STRONG>ProductName </STRONG>and <STRONG>Ean13</STRONG> node icons to empty cells on your template</P></DIV>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </DIV>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <DIV class="clear"> </DIV>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <DIV class="step-container">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <H2 class="step-title">Deselect the Keep Source Formats Property</H2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <DIV class="step-image-container">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <IMG alt="Deselect-the-Keep-Source-Formats-Property.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/106639_Deselect-the-Keep-Source-Formats-Property.png" style="height: auto; width: auto;" />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </DIV>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <DIV class="step-instructions"><OL><LI>Right click on <STRONG>Products Barcode</STRONG></LI><LI>Select <STRONG>Properties</STRONG></LI><LI>Deselect the <STRONG>Keep Source Formats</STRONG> box</LI></OL><P>It is necessary to remove the source format only in the Ean13 column to be able to apply the barcode font to it. You can decide if you want to keep or remove the source format in the other columns</P></DIV>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </DIV>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <DIV class="clear"> </DIV>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <DIV class="step-container">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <H2 class="step-title">Format the &lt;Ean13&gt; Tag with the EAN-13 Font</H2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <DIV class="step-image-container">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <IMG alt="Format-the--lt-Ean13-gt--Tag-with-the-EAN-13-Font.png" class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/106640_Format-the--lt-Ean13-gt--Tag-with-the-EAN-13-Font.png" style="height: auto; width: auto;" />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </DIV>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <DIV class="step-instructions"><OL><LI>Click on <STRONG>Toolbar</STRONG></LI><LI>Click on <STRONG>HOME </STRONG>tab</LI><LI>Select the <STRONG>&lt;Ean13&gt; </STRONG>cell</LI><LI>Select<STRONG> Code EAN13 </STRONG>or similar as Font</LI></OL></DIV>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </DIV>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <DIV class="clear"> </DIV>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <DIV class="step-container">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <H2 class="step-title">Result</H2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <DIV class="step-image-container">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <IMG alt="Result.png" class="image-4 jive-image" src="https://community.qlik.com/legacyfs/online/106641_Result.png" style="height: auto; width: auto;" />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </DIV>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <DIV class="step-instructions"><P>Click on <STRONG>Preview</STRONG></P><P>The Ean13 tag will be replaced by the EAN-13 barcode</P></DIV>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </DIV>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <DIV class="clear"> </DIV>&nbsp;&nbsp;&nbsp;&nbsp; </DIV>&nbsp;&nbsp; </DIV></BODY></HTML> Tue, 24 Nov 2015 13:54:01 GMT Bjorn_Wedbratt 2015-11-24T13:54:01Z How to Insert a Barcode Into a Report https://community.qlik.com/t5/Member-Articles/How-to-Insert-a-Barcode-Into-a-Report/ta-p/1487293 <HTML><HEAD></HEAD><BODY><DIV><DIV><P>This tutorial illustrates how to create a report with barcodes. We will use <STRONG>EAN-13</STRONG> (International Article Number) barcode fonts. You need a field with the EAN13 code in your .qvw.</P><P><STRONG>You must have installed an EAN-13 font on your machine</STRONG>. If you haven't it download one and installed it, refer to "<A href="http://windows.microsoft.com/en-us/windows-vista/install-or-uninstall-fonts" target="_blank">Install or uninstall fonts</A>".</P>&nbsp;&nbsp;&nbsp;&nbsp; </DIV>&nbsp;&nbsp;&nbsp;&nbsp; <DIV>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <DIV class="step-container">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <H2 class="step-title">Start New Excel Report Template and Add the Barcode Table</H2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <DIV class="step-image-container">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <IMG alt="Start-New-Excel-Report-Template-and-Add-the-Barcod.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/106638_Start-New-Excel-Report-Template-and-Add-the-Barcod.png" style="height: auto; width: auto;" />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </DIV>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <DIV class="step-instructions"><P>After adding <STRONG>Products Barcode </STRONG>as Table:</P><P>Drag the <STRONG>ProductID</STRONG>, <STRONG>ProductName </STRONG>and <STRONG>Ean13</STRONG> node icons to empty cells on your template</P></DIV>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </DIV>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <DIV class="clear"> </DIV>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <DIV class="step-container">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <H2 class="step-title">Deselect the Keep Source Formats Property</H2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <DIV class="step-image-container">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <IMG alt="Deselect-the-Keep-Source-Formats-Property.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/106639_Deselect-the-Keep-Source-Formats-Property.png" style="height: auto; width: auto;" />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </DIV>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <DIV class="step-instructions"><OL><LI>Right click on <STRONG>Products Barcode</STRONG></LI><LI>Select <STRONG>Properties</STRONG></LI><LI>Deselect the <STRONG>Keep Source Formats</STRONG> box</LI></OL><P>It is necessary to remove the source format only in the Ean13 column to be able to apply the barcode font to it. You can decide if you want to keep or remove the source format in the other columns</P></DIV>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </DIV>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <DIV class="clear"> </DIV>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <DIV class="step-container">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <H2 class="step-title">Format the &lt;Ean13&gt; Tag with the EAN-13 Font</H2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <DIV class="step-image-container">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <IMG alt="Format-the--lt-Ean13-gt--Tag-with-the-EAN-13-Font.png" class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/106640_Format-the--lt-Ean13-gt--Tag-with-the-EAN-13-Font.png" style="height: auto; width: auto;" />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </DIV>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <DIV class="step-instructions"><OL><LI>Click on <STRONG>Toolbar</STRONG></LI><LI>Click on <STRONG>HOME </STRONG>tab</LI><LI>Select the <STRONG>&lt;Ean13&gt; </STRONG>cell</LI><LI>Select<STRONG> Code EAN13 </STRONG>or similar as Font</LI></OL></DIV>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </DIV>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <DIV class="clear"> </DIV>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <DIV class="step-container">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <H2 class="step-title">Result</H2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <DIV class="step-image-container">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <IMG alt="Result.png" class="image-4 jive-image" src="https://community.qlik.com/legacyfs/online/106641_Result.png" style="height: auto; width: auto;" />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </DIV>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <DIV class="step-instructions"><P>Click on <STRONG>Preview</STRONG></P><P>The Ean13 tag will be replaced by the EAN-13 barcode</P></DIV>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </DIV>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <DIV class="clear"> </DIV>&nbsp;&nbsp;&nbsp;&nbsp; </DIV>&nbsp;&nbsp; </DIV></BODY></HTML> Tue, 24 Nov 2015 13:54:01 GMT https://community.qlik.com/t5/Member-Articles/How-to-Insert-a-Barcode-Into-a-Report/ta-p/1487293 Bjorn_Wedbratt 2015-11-24T13:54:01Z Re: How to Insert a Barcode Into a Report https://community.qlik.com/t5/Member-Articles/How-to-Insert-a-Barcode-Into-a-Report/tac-p/1487294#M100 <HTML><HEAD></HEAD><BODY><P>is there way to call&nbsp;&nbsp; custom rest api to generate the bar code dynamically and stored the image in the some folder&nbsp; and&nbsp; map it as&nbsp; image file path dynamically to place for each customer.</P></BODY></HTML> Fri, 22 Dec 2017 23:30:17 GMT https://community.qlik.com/t5/Member-Articles/How-to-Insert-a-Barcode-Into-a-Report/tac-p/1487294#M100 Anonymous 2017-12-22T23:30:17Z