Jump to content

Adding Filter to Excel Column Header


Chad Smith

Recommended Posts

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

>

  • Like 1
Link to comment
Share on other sites

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

 

  • Like 2
  • Thanks 2
Link to comment
Share on other sites

  • 2 months later...

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
  • Create New...