Help with Report Headers

[hopkinsc]

Hi All,

I am trying to figure out how to get report headings to appear on every page. I have created an EXCEL template that uses several levels and above all of the levels i have 4 rows of headings (which come from variables in the QVW).

i want to be able to repeat the headings on every page without having to hardcode the template (as the report can be anywhere from 1 page to 20 pages long depending on the users selections)

does anyone know of a way to do this please? i have tried using the Headers/Footers in excel but that doesn't work.

[#2 · Accepted solution]

Unfortunately, Excel headers do not support QlikView variables.

You can build the information you want in the header above the first level and use the repeat rows function in Excel:

[hopkinsc]

thats great, that does exactly what i want. Thanks!