topic Re: How to border excel report ? in Qlik NPrinting

How to border excel report ?

ashmitp869 — Fri, 23 Jul 2021 02:28:05 GMT

Hi there,

How to achieve the border line in my nprinting excel report-

Though I used the below in the edit template-

Re: How to border excel report ?

Lech_Miszkiewicz — Fri, 23 Jul 2021 03:08:29 GMT

The reason your border disapears is the fact that you have "Keep source formats" set on fields which produce your data. If you want to retain Excel format you need to uncheck "Keep source format" for whole table/each individual field.

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

Customize the formatting on an entire table

This causes the contents of all cells in all columns of the table to be exported from QlikView or Qlik Sense without formatting. You can apply new formatting using the Excel ribbon.

Do the following:

On the left-hand pane, select the table you want to customize.
Go to the Properties pane.
Clear the Keep Source Formats check box.
Use the Excel ribbon to customize the table.
For example, change font size or color.

Re: How to border excel report ?

ashmitp869 — Fri, 23 Jul 2021 04:11:01 GMT

Hi Lech,

I did uncheck the keep source formats but still it didn't work.

output is still same. Only the table data format got change which I understand , can be change from Excel Ribbon.

Re: How to border excel report ?

Lech_Miszkiewicz — Fri, 23 Jul 2021 04:31:10 GMT

Ohh ok - I thought you were using straight table which would normally be used in such scenario.

Are you using pivot table? Or maybe you are using some conditional hide/show on table columns which makes you unable to pick and choose individual columns to populate your template (just like in the tutorial I initially sent you?

You may want to provide us with more info about the source, structure of your source table etc so we can understand how to built it properly.

I would encourage you to make sure your source table is a straight table WITHOUT any conditional hide/show options on columns. Then use each column as a placeholder of data which will give you great control over its format.

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

by the way - make sure your QVW is supported:

https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/GettingStarted/HowCreateConnections/Connect-to-QlikView-docs.htm#anchor-1

https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/ReportsDevelopment/Qlik-objects-supported-NP.htm#anchor-2

cheers

Re: How to border excel report ?

ashmitp869 — Fri, 23 Jul 2021 05:14:37 GMT

Hi there,

I made my table as a straight table but it contains measures like

Total Errors=Num(Sum({$<FinancialYear=,Month=,[_date]={">=$(=vPrevCurrentMonthStart)<=$(=vPrevCurrentMonthEnd)"}>}_error_count), '#,##0')

Is it the reason why the columns is not coming in nprinting.

as I saw in this https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/ExcelReports/Create-Excel-Reports.htm?&_ga=2.179739872.553619111.1626998751-338438192.1621834330#anchor-4

that with calculated column it won't work.

Re: How to border excel report ?

Lech_Miszkiewicz — Fri, 23 Jul 2021 06:10:09 GMT

Have you regenerated metadata and removed and added objects again to the template?

highlighted area is what the "calculated column means"