topic Re: nPrinting Excel Report Table Border in Qlik NPrinting

nPrinting Excel Report Table Border

samrat_g — Thu, 24 May 2018 04:57:51 GMT

Hi All,

I am facing a problem in nPrinting excel report.

Data source is qlikview.

For generating the report in nPrinting, I added two tables in same sheet of an excel report.

I have created the excel template as below:

But the problem is when I generate the report, the output is coming as below:

Whereas the desired output is as below:

Is there any possible solution for this..

Thanks,

SAMRAT

Re: nPrinting Excel Report Table Border

Lech_Miszkiewicz — Fri, 25 May 2018 03:13:56 GMT

as you probably noticed this is because you are creating new rows based on your template's first row. Since your first table on the left has more rows the formatting is carried across to the second table too for every created row in spreadsheet (not in this first table)!

I am not sure if you could use conditional border formatting for it? like if cell is empty then no formatting - i am not an excel guru?

I might have to test it further to give you correct answer. I am suspecting it can be achieved by using tables instead of ranges in excel.

regards

Lech

Re: nPrinting Excel Report Table Border

_rohitgharat — Wed, 09 Aug 2023 10:05:06 GMT

Hi @samrat_g @Lech_Miszkiewicz ,

Even I am facing the same issue. Is there any workaround to avoid this?

Regards,

Rohit Gharat

Re: nPrinting Excel Report Table Border

Lech_Miszkiewicz — Wed, 09 Aug 2023 12:00:02 GMT

Hi @_rohitgharat

sure there is - I am just not able to test it now and take screenshots but one or maybe two options should work:

put extra row between header row and data row and make sure that extra row does not have border. Same applies to row below. details below
1. Header is in row 3 and it has all borders
2. row 4 has no borders and you can hide it - but having it without borders will mean that data populated in row 5 and downwards will not have borders
3. add extra row (row 6) so the bottom border is not copied as data gets populated and remove it using <deleterow>
4. in row 7 use top border to create a wrapping border around whole table

that is in the nutshell the concept i often use.

You may try to put <deleterow> also in row 4, however I am not sure if that will work then - test it

cheers

Re: nPrinting Excel Report Table Border

Lech_Miszkiewicz — Wed, 09 Aug 2023 12:09:56 GMT

to add to this - If you are trying to situation where you have 2 different tables side by side then the issue is more complex. In those scenarios you may choose to disable "Expand range". Any other option I would need to test - but cannot do it now unfortunatelly.

Re: nPrinting Excel Report Table Border

Frank_S — Mon, 14 Aug 2023 21:59:06 GMT

@_rohitgharat

Nprinting works best vertically when it comes to adding data tables to an NPrinting excel report. It can be done to a certain extent but it is tricky

It's more effective to use image chart table object rather than table data objects if need a side by side representation.

https://help.qlik.com/en-US/nprinting/May2023/Content/NPrinting/ExcelReports/Create-Excel-Reports.htm#anchor-5

If you must use tables, ideally place your tables vertically not horizontally (also as per the point made by @Lech_Miszkiewicz regarding expanded ranges). For more information about "expand range" visit this help page for details).

If you must use side by side tables, you can experiment with the expand range table property feature.

https://help.qlik.com/en-US/nprinting/May2023/Content/NPrinting/ReportsDevelopment/Designer-properties.htm#anchor-6

Kind regards.