topic Re: Inserting Table Adds Excel Rows in Qlik NPrinting

Inserting Table Adds Excel Rows

rwb139 — Thu, 17 Dec 2020 21:48:49 GMT

Hi all,

I'm having some issues with Excel and nPrinting. Unfortunately, not only are my inserted charts creating excessive excel rows, but also the tables that I insert are creating rows. As you can see from the pictures, they are really knocking off the format of my reports. Any suggestions?

Re: Inserting Table Adds Excel Rows

Lech_Miszkiewicz — Thu, 17 Dec 2020 22:06:09 GMT

Suggestions?

study https://help.qlik.com as this is how NPrinitng works and report design needs to cater for that. If you have static report template with set number of rows you may want to play with property called: "Expand range" https://help.qlik.com/en-US/nprinting/November2020/Content/NPrinting/ReportsDevelopment/Designer-properties.htm#anchor-6 which may be a solution for what you need.
Regarding images - you have already discussed this here: https://community.qlik.com/t5/Qlik-NPrinting-Discussions/Images-in-Excel-keep-adding-rows/td-p/1763379 - and this is how it works... full stop. The workaround is to use excel charts but only if they are not part of the level...

I know that it may be annoying, but you kinda need to know tools limitations when designing reports hence my suggestion to study help tutorials as a start...

Re: Inserting Table Adds Excel Rows

rwb139 — Thu, 17 Dec 2020 22:11:41 GMT

Thank you for the fast response and solution! Unchecking expand did what I needed it too. I really appreciate it.