Header not printing on second page

[cuevasj]

9.4 m5

proc report to ods tagset.excelxp

When using a spanned header, and freezing the top two rows, the spanned header does not print on page two to the end of the report.

Run this code ( it uses sashelp.shoes )

ods escapechar='^';

ods tagsets.excelxp
file="c:\temp\span_hdr_xp.xml"
options(autofit_height='yes'
frozen_headers='2'
gridlines='yes'
orientation='landscape'
pages_fitwidth='1'
pages_fitheight='40'
row_repeat='2'
sheet_name='Header Print Issues'
/*wraptext='no'*/);

** the header shows correctly when you download the excel doc that is produced;
** but the top row of the header will not print on pages 2-the end of document;
** see attached pdf;

proc report data=sashelp.shoes;
column ('Spanning Header will not appear on pages 2-13 when printing' region product sales returns);
define product / group;
run;

ods _all_ close;

[SuryaKiran · Accepted solution]

Hello,

Try this options: row_repeat='1-2'