How to freeze header automatically in excel output using rtf template
Hi,
I have created a BI Publisher report using the RTF template. I have multiple templates in the RTF file which are invoked based on different input parameters. I set up table properties in such a way the title, sub-title and column heading can be repeated on each page. This function works fine when exporting the file in PDF format.
The issue is this function doesn't work as expected when export in excel format. Client requirements when printing the excel title, sub-title and column headings should be repeated on each page. This also includes the footer.
Any help regarding this?