If your default output is XLSX then printing settings to PDF are coming from your office printing setting.
Did you try to execute report distribution to XLSX, then open produced file and try to print it to PDF? I have got a feeling that you will encounter the same problem. From my experience you have to make sure PDF printer or rather i should say "Excel Page Layout->Prinintg settings" are not changing content.
So this requires you to properly setup printing are in your EXCEL when editing NPrinting template. All options below will make a difference.
hope this helps.
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.
lets investigate bit more:
- when you run it as XLSX and then did you use Save or Print option to PDF? What i meant in my previous post was to Print it to PDF
- is there any particular reason why you are using Excel template? Maybe you could consider Pixel Perfect template? I guess it would be easier to get it all alligned in PixelPerfect
- are you connecting NPrinting to QlikSense or QlikView?
I now see what you mean. You're right, when I print to PDF within Excel my report actually bleeds onto the next page, which is actually not the same behaviour but I understand your point - something is happening during the conversion that is incorrect and not in my control. We've always used Excel because people typically ask for reports in Excel. This is the first time we've been asked for the PDF format, so we've never tried Pixel Perfect. I think I'll explore that option in order to gain more control of how the report is being generated. Thanks for your help!