topic Random rows missing in Excel data sheet in Qlik NPrinting

Random rows missing in Excel data sheet

Raju_6952 — Fri, 15 Nov 2024 21:07:45 GMT

Hi,

I have created a pixel perfect report in nprintinng designer which has straight table data and found that some random rows were blank with no clue to I don't have any other filters applied except the month filter at publish task level.

Any suggestions would be highly appreciated to solve the issue .

Kind Regards,

Raju

Re: Random rows missing in Excel data sheet

Frank_S — Thu, 01 Feb 2024 22:34:12 GMT

If your source chart object structure (formula changes, added deleted columns etc) used in the PxP report has changed, then you may have lost some chart references.

You 'might' be able to update you data bindings the changes in your PxP report but if there are too many changes to your source data chart structure, it might be simpler to recreate your report.

This is one possibility.

Others here might have input as well.

Kind regards...

Re: Random rows missing in Excel data sheet

Lech_Miszkiewicz — Thu, 01 Feb 2024 23:14:30 GMT

hI @Raju_6952

1. Housekeeping first:

Are you doing excel template or pixel perfect template - it is confusing base on your title and description?
version of QlikView or Qlik Sense
version of NPrinting please

2. What are expressions in your source table?

is there any set analysis?
what is a structure of the table
we must understand dimensions and measures you are using to understand where the issue is

3. How does your template look like

we saw a lot of things people do so making sure you build your report properly following all required steps for PixelPerfect table is critical
are there any additional levels/sublevels

Once you provide above info we will know if:

you are running supported configuration - if not there is no point of trying to figure out that problem until you do. Often companies upgrade QlikView or Qlik Sense and leave NPrinting forgetting about very importand compatibility matrix
your expressions are not trying to "go against" the way NPritning is trying to work!
we will understand if there is any design issue

Ball in your corner now - good luck!

By the way - providing screenshots would be helpful!

cheers

Re: Random rows missing in Excel data sheet

Ruggero_Piccoli — Fri, 02 Feb 2024 09:48:42 GMT

Hi,

I would like to add only the suggestion that, if your goal is to generate Excel reports it is better to create Excel templates and use PixelPerfect templates to generate PDF reports. Of course generating Excel reports from PixelPerfect templates is supported but I suggest to use it if you already invested time in creating the PxP template and you need reports in Excel format fast.

It is always suggested to create the template of the same type of the output you desire.

Best Regards,

Ruggero

Re: Random rows missing in Excel data sheet

Raju_6952 — Fri, 02 Feb 2024 09:54:44 GMT

Hi @Ruggero_Piccoli ,

Thanks for the suggestions, will follow the same thing.

Regards,

Raju