NPrinting Count Exceeded No. of Rows 1048576

[profilejamesbond]

Hi,

I have made a report and want to send that report via NPrinting but I see this error:

How to fix this issue ? I have rows around 55 Millions.

Thanks

[Lech_Miszkiewicz · Accepted solution]

Hi. What are you trying to do? It looks like you are trying to dump huge data set. Question i have is what template are you using (excel, power point..html…other?)

if it is excel then you hit the max which excel can store in single sheet which is excel limitation and not really nprinting problem so you need to think what you want to achieve with dumping such large volumes of data into single file. 

[Ruggero_Piccoli · Accepted solution]

Hi,

As per @Lech_Miszkiewicz answer it is an Excel limit documented by Microsoft at https://support.microsoft.com/en-us/office/excel-specifications-and-limits-1672b34d-7043-467e-8e27-2.... This is not a Qlik NPrinting limitation. 

You could:

- apply cycles and create around 55 different files

- apply pages and create a single Excel file with around 55 worksheets. It will be huge so you could have issues in sending it via email or opening it in Excel. 

- QlikView and Qlik Sense tables can be exported in csv (and other similar formats) by using QlikEntity reports but they have the same 1M rows limitation. Refer to https://help.qlik.com/en-US/nprinting/May2022/Content/NPrinting/QlikViewEntityReports/Intro-EntityRe...

Best Regards,

Ruggero