Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
giulio_agnolett
Partner - Contributor
Partner - Contributor

Qlik NPrinting April 2019&Excel2016 - Excel Report Rows to repeat at top ranom resizes

When creating a Ms Excel report, 3 rows header is not repeated on the next page even if “repeat Header Rows” is activated.

Cattura.PNG

The resulting output launching the task is not repeating the 3 header rows in the pages after the 1st one.

Cattura2.PNG

The 3 header rows are containing an Image Tag and a row containing cell references to a table header setted with Show Headers -> Show above tag cell.

If I set “repeat Header Rows”  1 to 5 the the output is  exactly what I need:

Cattura3.PNG

Is there a way to understand how to set  “repeat Header Rows”  in an excel template and get the expected output?

1 Reply
Eva_B
Employee
Employee

Hello,

I wanted to respond to your post as I saw it did not receive any responses.

Please see the following Knowledge Article concerning the "Repeat Header Rows":

 
To solve this issue, you need to 
  • select the "Hide" value in the "Show Header" table property
  • Add a new header row in the table (see article). The new header row will be repeated once “repeat Header Rows” is activated

Please let me know if this helps at all? If so please mark as the Solution.

Regards,

Eva