Yes, you limit from qlik side or Nprint side by using conditions (i.e using this method report will generate when it meet the condition so u can define rule like
=if(sum(Sales)>0,1,0) // QV side
create condition rule like below
sum(Sales)>0 // How to Control Report Generation with Conditions
Hope this helps to you
also check this article,
Hi Devarasu R, thank you for your reply.
we have hid the columns in QV side. But for NPrinting excel report we should add all columns no matter it's empty or not.
We can use VBA script to hide the empty columns for excel report. But now we need stored as PDF format for the excel report. The PDF report will include empty columns. How to remove these empty columns in PDF file.