Random rows missing in Excel data sheet

[Raju_6952]

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

[Frank_S]

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...

[Lech_Miszkiewicz]

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:

1. 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
2. your expressions are not trying to "go against" the way NPritning is trying to work!
3. 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

[Ruggero_Piccoli]

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

[Raju_6952]

Hi @Ruggero_Piccoli ,

Thanks for the suggestions, will follow the same thing.

Regards,

Raju