Chad Smith Posted June 28 Share Posted June 28 I'm currently on version 8.2, is there any new code that will turn on the column filters within Excel output without having to hard-code via the old method? Old method: < DEFINE FILE CAR AUTOFILTER/A162 = '</td></tr><tr><td x:autofilter="all" x:autofilterrange="$A$2:$C$2">COUNTRY</td>' | '<td class=xl100 x:autofilter="all">CAR</td>' | '<td class=xl100 x:autofilter="all">MODEL' ; END TABLE FILE CAR HEADING "<AUTOFILTER " PRINT COUNTRY AS '' CAR AS '' MODEL AS '' ON TABLE PCHOLD FORMAT EXL07 END > 1 Link to comment Share on other sites More sharing options...
Clayton Peacock Posted July 1 Share Posted July 1 Hi @Chad Smith I've logged a NFR with TechSupport for this a while back- would love to see this functionality available for XLSX output. Link to comment Share on other sites More sharing options...
Angela Hildack Posted July 8 Share Posted July 8 Hi Chad and Clayton - WebFOCUS 9.0.0 added a feature in Designer for Excel Tables that will enable sorting and filtering on the column titles of the report. This video shows both how to add it and the resulting output - but keep in mind it will only work in a WF 9.x release 1 1 Link to comment Share on other sites More sharing options...
Clayton Peacock Posted July 9 Share Posted July 9 Hi @Angela Hildack thanks for sharing this is wonderful feature, we are on 9.3.0 and will definitely start using it. Code: TABLE FILE CAR PRINT * ON TABLE PCHOLD FORMAT XLSX ON TABLE SET STYLE * TYPE=DATA, IN-XLSXTABLE='My Table', $ ENDSTYLE END 3 1 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now