Hi,
As general suggestion, avoid to add new post on very old conversations. This was wrote in 2017 and in 2 years many things changed in Qlik NPrinting in that period.
If you are working on an Excel template you could use macros. Excel macros are supported in the meaning that the VBA code is copied from the template to the generated reports. So you could develop a piece of VBA code that delete the rows when there are no data and associate it with the event On Opening. VBA code is never executed by Qlik NPrinting during reports production so, for example, this will not work if you want to produce a PDF from an Excel and the recipient will see the macro's execution at first opening.
If you are working on a PixelPerfect report you can use formatting rules. Refer to https://community.qlik.com/t5/Qlik-NPrinting-Documents/How-to-Manage-PixelPerfect-Conditional-Output... there are also many posts on the community about them.
Best Regards,
Ruggero
Best Regards,
Ruggero
---------------------------------------------
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 with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
