title: How to add automatic filters to Excel output in Cognos reports?
body: <p>I am working on a project in <code>Cognos Report Studio version 10.2.1</code>.
  One of the business requirement is that the output format of the report should be in Excel 2007 with auto filter on the headers of the row.</p>
  
  <p>I tried inserting one html item above the list and one below the list with the following code:</p>
  
  <p>1st HTML code above the list:</p>
  
  <pre><code> &lt;table&gt;
      &lt;td x:autofilterrange="$A$1:$D$1" /td&gt;
  </code></pre>
  
  <p>2nd HTML code below the list:      </p>
  
  <pre><code>&lt;/table&gt;
  </code></pre>
  
  <p>Can anyone please suggest where I am going wrong? Thank you in advance</p>