topic Re: Excel Report NPrinting Designer Size Error? in Qlik NPrinting

Excel Report NPrinting Designer Size Error?

Asuod_ — Thu, 25 Aug 2022 19:22:44 GMT

Hello,

I am building out a excel report through NPrinting Designer and im getting the following error below when I try to preview or save it. Ive been troubleshooting this for a while and it seems to be a sizing issue. If i remove some columns of data and/or filters then it runs perfectly fine but when i add even one more columns or filters it gives the error. Maybe an object or filter limitations? Has anyone come across this or know a workaround? Thank you!

Re: Excel Report NPrinting Designer Size Error?

Frank_S — Thu, 25 Aug 2022 19:41:25 GMT

Show us a snapshot of your entire designer/report template so we can analyze if you've missed something in your report configuration.

kind regards...

Re: Excel Report NPrinting Designer Size Error?

Asuod_ — Thu, 25 Aug 2022 20:17:57 GMT

Hi Frank,

Attached is the template and a screenshot of the table objects, sorry had to redact all the information but hopefully it enough to provide an idea . My goal is to have 5 straight table object, each filtered differently and placed on 5 separate tabs in the excel report. Currently, I could only get 4 straight table objects due to the error and each table contains about 141 columns. I am able to run preview/ save the report through tab1,2 and 3 w/ the straight table objects and filters applied but tab 4 is when i start having issues, i get the error if i populate columns pass column DN on tab or if i add any filters to the 4th table object.

Re: Excel Report NPrinting Designer Size Error?

Frank_S — Thu, 25 Aug 2022 21:33:37 GMT

It seems that you might actually be using more that 256 columns which is a known limitation. Perhaps you have hidden columns as well. If so , those count.

https://help.qlik.com/en-US/nprinting/Content/NPrinting/ReportsDevelopment/Common-editing-feature.htm#anchor-6

Limitations

Report templates should only be edited by one person at a time. While it is possible for two people to open a report template in Qlik NPrinting Designer, it is not supported.

...tables with more than 256 columns cannot be imported into Qlik NPrinting report templates.

Generated reports can be a maximum of 512 MB.

Qlik NPrinting Designer must be the same version as Qlik NPrinting Server.

But on closer inspection, it appears you have 258 columns.

The act of removing a couple of columns, which you've done based on your initial statement, is a good workaround.

Kind regards...

Re: Excel Report NPrinting Designer Size Error?

Asuod_ — Fri, 26 Aug 2022 14:28:18 GMT

Hi Frank,

I have the same amount of columns for Tab1,2,3 which work fine, if i only highlight the columns there are only 141 columns. The top row on each tab are just the columns names and I exported a file and it is only 501kb in size. So not sure what the reasoning is for the error.

Re: Excel Report NPrinting Designer Size Error?

Ruggero_Piccoli — Fri, 26 Aug 2022 14:47:22 GMT

Hi,

You could try to create a new template and add a worksheet at a time until you get the error again so you can isolate the cause. Like @Frank_S I suppose the generated report is bigger than one of the limitations. For example, check the number of rows.

Otherwise, open a support ticket with everything we need to reproduce the issue.

Best Regards,

Ruggero

Re: Excel Report NPrinting Designer Size Error?

Asuod_ — Fri, 26 Aug 2022 15:15:42 GMT

Hi,

I did try to add a worksheet at a time and it worked fine which makes me believe its some kind of limitation. I only kept tab 1,2,3 then add another table object so now i have 5 table objects and 3 excel tabs with 141 columns on each tab and it threw the same error. Starting to wonder if it could be a NPrinting Designer or NPrinting Server limitation?