Prevent Nprinting to add extra rows in Excel

[HenryM]

I am facing a problem with a Excel report that I am preparing in Nprinting June 2020 using Qlik Sense.

I have a simple application in Qlik Sense with two tables, those to tables have a relation 1-N.

So I have a static format in Excel and in need to paste some information from the main table and some information from the child table.

The thing is that everytime I paste a field from the child table Nprintng is adding new lines to the excel file, instead of paste them on my predefined format.

Is there a workaround for this? I tried to paste everything in a extra colum that I hide, and referencing the cells using "=" however this reference is also updated, so this workaround does not work.

Thanks in advance.

[Lech_Miszkiewicz · Accepted solution]

Hi,

I suggest you study official documentation. Feature you may want to play with is described here:

https://help.qlik.com/en-US/nprinting/November2020/Content/NPrinting/ReportsDevelopment/Designer-pro...

[HenryM]

Thank you, I was able to solve the problem.