Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

NPrinting Excel Template Issue

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.

1 Solution

Accepted Solutions
Not applicable
Author

A solution has been found. The setting 'Display fields in report filter area:' was changed from 'Down, Then Over' to 'Over, Then Down.

View solution in original post

7 Replies
Daniel_Jenkins
Specialist III
Specialist III

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.

Not applicable
Author

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.

Not applicable
Author

OK - after I sent the last message, I found it in the Control Panel - Region and Language. The two symbols are diferent

Daniel_Jenkins
Specialist III
Specialist III

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.

Not applicable
Author

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.

Daniel_Jenkins
Specialist III
Specialist III

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.

Not applicable
Author

A solution has been found. The setting 'Display fields in report filter area:' was changed from 'Down, Then Over' to 'Over, Then Down.