article How to create an NPrinting Cell by Cell Report in Official Support Articles https://community.qlik.com/t5/Official-Support-Articles/How-to-create-an-NPrinting-Cell-by-Cell-Report/ta-p/2056457 <P class="lia-message-template-content-zone">&nbsp;</P> <H3 class="lia-message-template-content-zone">Requirement:</H3> <P class="lia-message-template-content-zone">If you need to force a specific layout such as headers in the left column, you may choose to use NPrinting cell by cell reporting.&nbsp;</P> <P>This is a much more onerous, methodical 'cell by cell approach. But it is possible 'manually' shift default <EM>Horizontal Headers</EM> so that the 'headers' appear as a 'column' vertically.</P> <P>Then have corresponding column data appear horizontally as well.</P> <P>&nbsp;</P> <P><STRONG>Step 1: Choose Cells in template editor</STRONG></P> <P><STRONG><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="1. open cells.png" style="width: 697px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/104106i5BC2EA7DC85649CE/image-size/large?v=v2&amp;px=999" role="button" title="1. open cells.png" alt="1. open cells.png" /></span></STRONG></P> <P><STRONG>Step 2:choose chart object</STRONG></P> <P><STRONG><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2. choose chart object.PNG" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/104105i5AA0FA6984B133D9/image-size/large?v=v2&amp;px=999" role="button" title="2. choose chart object.PNG" alt="2. choose chart object.PNG" /></span></STRONG></P> <P><STRONG>Step 3: choose number of rows and charts for report</STRONG></P> <P><STRONG><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="3. choose number of rows and charts for report.PNG" style="width: 560px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/104104i6D9BA76B9A52A6EA/image-size/large?v=v2&amp;px=999" role="button" title="3. choose number of rows and charts for report.PNG" alt="3. choose number of rows and charts for report.PNG" /></span></STRONG></P> <P>&nbsp;</P> <P><STRONG>Step 4: Drag and drop individual cells in to the desired position</STRONG></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="4. Drag and drop individual cells in to the desired position.PNG" style="width: 882px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/104097i3F33D3A109A29185/image-size/large?v=v2&amp;px=999" role="button" title="4. Drag and drop individual cells in to the desired position.PNG" alt="4. Drag and drop individual cells in to the desired position.PNG" /></span></P> <P>&nbsp;</P> <DIV id="tinyMceEditorFrank_S_3" class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV> <P><STRONG>Step 5: Preview your report.</STRONG></P> <P>Notice and compare original chart against the left position of the field headers for chart <STRONG>"Top 25 Products"</STRONG></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="5. preview - example vs default chart.PNG" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/104098i4382EBCD57451378/image-size/large?v=v2&amp;px=999" role="button" title="5. preview - example vs default chart.PNG" alt="5. preview - example vs default chart.PNG" /></span></P> <DIV id="tinyMceEditorFrank_S_4" class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV> <P>&nbsp;</P> <H3 class="lia-message-template-content-zone">Related Information:</H3> <UL> <LI> <P><A title="NPrinting Excel Reports" href="https://help.qlik.com/en-US/nprinting/Content/NPrinting/ExcelReports/Intro-Excel.htm" target="_blank" rel="noopener">NPrinting Excel Reports</A></P> </LI> </UL> <DIV class="lia-message-template-content-zone">&nbsp;</DIV> Mon, 19 Jun 2023 19:17:34 GMT Frank_S 2023-06-19T19:17:34Z How to create an NPrinting Cell by Cell Report https://community.qlik.com/t5/Official-Support-Articles/How-to-create-an-NPrinting-Cell-by-Cell-Report/ta-p/2056457 <P class="lia-message-template-content-zone">&nbsp;</P> <H3 class="lia-message-template-content-zone">Requirement:</H3> <P class="lia-message-template-content-zone">If you need to force a specific layout such as headers in the left column, you may choose to use NPrinting cell by cell reporting.&nbsp;</P> <P>This is a much more onerous, methodical 'cell by cell approach. But it is possible 'manually' shift default <EM>Horizontal Headers</EM> so that the 'headers' appear as a 'column' vertically.</P> <P>Then have corresponding column data appear horizontally as well.</P> <P>&nbsp;</P> <P><STRONG>Step 1: Choose Cells in template editor</STRONG></P> <P><STRONG><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="1. open cells.png" style="width: 697px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/104106i5BC2EA7DC85649CE/image-size/large?v=v2&amp;px=999" role="button" title="1. open cells.png" alt="1. open cells.png" /></span></STRONG></P> <P><STRONG>Step 2:choose chart object</STRONG></P> <P><STRONG><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2. choose chart object.PNG" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/104105i5AA0FA6984B133D9/image-size/large?v=v2&amp;px=999" role="button" title="2. choose chart object.PNG" alt="2. choose chart object.PNG" /></span></STRONG></P> <P><STRONG>Step 3: choose number of rows and charts for report</STRONG></P> <P><STRONG><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="3. choose number of rows and charts for report.PNG" style="width: 560px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/104104i6D9BA76B9A52A6EA/image-size/large?v=v2&amp;px=999" role="button" title="3. choose number of rows and charts for report.PNG" alt="3. choose number of rows and charts for report.PNG" /></span></STRONG></P> <P>&nbsp;</P> <P><STRONG>Step 4: Drag and drop individual cells in to the desired position</STRONG></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="4. Drag and drop individual cells in to the desired position.PNG" style="width: 882px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/104097i3F33D3A109A29185/image-size/large?v=v2&amp;px=999" role="button" title="4. Drag and drop individual cells in to the desired position.PNG" alt="4. Drag and drop individual cells in to the desired position.PNG" /></span></P> <P>&nbsp;</P> <DIV id="tinyMceEditorFrank_S_3" class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV> <P><STRONG>Step 5: Preview your report.</STRONG></P> <P>Notice and compare original chart against the left position of the field headers for chart <STRONG>"Top 25 Products"</STRONG></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="5. preview - example vs default chart.PNG" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/104098i4382EBCD57451378/image-size/large?v=v2&amp;px=999" role="button" title="5. preview - example vs default chart.PNG" alt="5. preview - example vs default chart.PNG" /></span></P> <DIV id="tinyMceEditorFrank_S_4" class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV> <P>&nbsp;</P> <H3 class="lia-message-template-content-zone">Related Information:</H3> <UL> <LI> <P><A title="NPrinting Excel Reports" href="https://help.qlik.com/en-US/nprinting/Content/NPrinting/ExcelReports/Intro-Excel.htm" target="_blank" rel="noopener">NPrinting Excel Reports</A></P> </LI> </UL> <DIV class="lia-message-template-content-zone">&nbsp;</DIV> Mon, 19 Jun 2023 19:17:34 GMT https://community.qlik.com/t5/Official-Support-Articles/How-to-create-an-NPrinting-Cell-by-Cell-Report/ta-p/2056457 Frank_S 2023-06-19T19:17:34Z