Adding Automatic filters to Excel output in Cognos reports

One of the challenging report requirement is to have automatic filters in Cognos report for an excel output report ,The purpose of this post is to illustrate the trick of adding automatic filters in an Excel output report

The following are the required steps

1) Build a simple list report

2) Add two HTML Item …one before the list report component and the other after list report component

3) Inside the first HTML item add the following Html Code

               
            <table> 
               <td x:autofilterrange="$A$1:$D$1" /td> 


4) Inside the second HTML item add the following HTML code

           </table> 

Enjoy :)