Hi all, I have recently started at a new client. Alot of old code and they are macro crazy. I have a proc report with a compute before _page_ block within ODS output (excelxp tagset). It seems this compute block has the effect of shifting my autofilter to the first row of the data section and off the heading row. proc report data=work.dummy nowindows split='*' style(column)={background=#ffcc33 foreground=black font_weight=bold}; compute before _page_ / style=line; line "&session_fullName_oBlanks."; line ' '; endcomp; columns btrName eve_status mAnzahlAbsolut BE_Geplant_abs WDB_Geplant_abs mAnzahlProzent BE_Erwartung; define btrName / ''; define eve_status / ''; define mAnzahlAbsolut / '' style(Column)=[just=right tagattr='formula:subtotal(9,R[2]C[0]:R[50000]C[0]) format:#,##0']; define BE_Geplant_abs / '' style(Column)=[just=right tagattr='formula:subtotal(9,R[2]C[0]:R[50000]C[0]) format:#,##0']; define WDB_Geplant_abs / '' style(Column)=[just=right tagattr='formula:subtotal(9,R[2]C[0]:R[50000]C[0]) format:#,##0']; define mAnzahlProzent / '' style(Column)=[just=right tagattr='formula:subtotal(9,R[2]C[0]:R[50000]C[0]) format:#,##0']; define BE_Erwartung / '' style(Column)=[just=right tagattr='formula:subtotal(9,R[2]C[0]:R[50000]C[0]) format:#,##0']; run; Any thoughts on what to do with this issue ? Regards
... View more