I have an Excel template that currently has 15 report filters in a pivot table. I was asked to add a field, but NPrinting doesn't like it. I receive an 'Error: Attempted to divide by zero' error message. I've attached a screen shot to show what is happening.
I've tried everything I can think of to fix it. Even recreating the template, but the result is the same.
If anyone out there can verify that the NPrinting process only allows 15 report filters in a pivot table of an Excel template or has a solution to allow more, it would be much appreciated.
I'm not sure what you mean by: Did you create your report from an NPrinting template or did you manually create the pivot table? I built the pivot table in the NPrinting Excel report template. Using this method: How to Create a Pivot Table from Excel Table Columns
Also not clear how you are putting multiple filters into your template. I assumed you added them at the Report level. I did run the report Task without issues. If you list the exact steps you took, I can try to reproduce the issue and confirm. However, I suspect it has something to do with your source data. It would be great if you shared a sample project that demonstrates the issue (QVW, NSQ with the filters etc. & Excel report template). Or open a case with Tech. Support.
Sorry I wasn't very clear. What I should have asked you is if you created the report from the nsq executing a report task, and you indicated that you had. And it's that report you indicated you had 18 report filters, correct?
I'm attaching my report template, nsq and qvw. I had to remove the data from the qvw, so hopefully you can create dummy data to get this all to work together. That is if you have the time.