Skip to main content

Qlik NPrinting

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
afbraga1
Creator
Creator

NPrinting excel error - The row index should not be inside the pivottable report

Hello,

When trying to generate an excel report with contains excel pivot tables I get the following error:

"ERROR: The row index should not be inside the pivottable report"

I believe the issue is with the 2 pivot tables to the right (image below), but I don't know what is the issue. The pivot tables will grow to the right where there is nothing and never touch each other. Any idea why this happens? I haven't found anything about this error so far.

Best regards,

André Braga

CaptureS.PNG

Labels (2)
1 Solution

Accepted Solutions
Ruggero_Piccoli
Support
Support

Hi,

What are tags on the C column? Are they columns? If yes, did you hide the headers?

Are tags on the G column pivot tables in the source connection? If yes why are you using pivot tables with fixed titles on the left?

I suggest you to place each single tag on a cleat template so you can see their behaviour and understand what is overlapping. Then remember to hide the headers and in case test the Expand rows option.

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.

View solution in original post

3 Replies
Ruggero_Piccoli
Support
Support

Hi,

What are tags on the C column? Are they columns? If yes, did you hide the headers?

Are tags on the G column pivot tables in the source connection? If yes why are you using pivot tables with fixed titles on the left?

I suggest you to place each single tag on a cleat template so you can see their behaviour and understand what is overlapping. Then remember to hide the headers and in case test the Expand rows option.

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.
afbraga1
Creator
Creator
Author

Hello Ruggero,

Thanks for your answer.

Columns B and C have respectively header and values for straight table objects I have imported from Qlikview.

Yes, Column G are in the source connection.

The reason I did it this way was because I felt that importing pivot tables from Qlikview with keep source formats  or transforming a straight table to pivot table in excel was very unreliable on the column width. Sometimes it is far too wide or too narrow with no apparent reason that I was able discern. And since it was a requirement for what I'm doing, I'm trying to make it more reliable as possible.

I don't know if there is anything else that I might not be aware and that can help on this issue. What I am talking about can be seen on images below. Two excel sheets that are the result of cycling through a Page field. In both pages the width of columns H and I is far too different and I don't see a reason. It also resizes in excel to the correct width when I double click on the column width.

CaptureDDSD.PNGCaptureSDA.PNG

 

 

 

 

 

 

 

 

 

 

I did redo it on a clean template and the overlapping issue is now fixed, but I'm not too confident on why since I did not visually notice any objects overlapping. Still I'm taking your comments in consideration as I develop. Thank you.

Best Regards,

André Braga

 

Aditya_Chitale
Creator III
Creator III

In my case the issue resolved after selecting the rows in which the pivot table was placed and selecting the clear formats option.

Regards,

Aditya