Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
A solution has been found. The setting 'Display fields in report filter area:' was changed from 'Down, Then Over' to 'Over, Then Down.
Hi Allan,
Can you check your OS advanced Regional Settings and ensure that these two are not set to the same symbol:
By the way, I just tried an Excel Pivot Table report with 18 report level filters and it worked just fine.
HTH - Daniel.
Hi Daniel,
Where am I navigating to get to the screen shot you posted? Thanks
Did you create your report from an NPrinting template or did you manually create the pivot table?
I can open my template, past data in it, and put in as many report filters I want.
I think the issue lies within NPrinting not liking more than 15 when it generate a report.
OK - after I sent the last message, I found it in the Control Panel - Region and Language. The two symbols are diferent
Hi Allan,
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.
HTH - Daniel.
Daniel,
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.
Hi Allan,
"... I suspect it has something to do with your source data"
Without the data I'm afraid I cannot reproduce the issue so I have nothing to work with.
- Daniel.
A solution has been found. The setting 'Display fields in report filter area:' was changed from 'Down, Then Over' to 'Over, Then Down.