title: SSRS 2008 R2: How to apply filtering on Excel columns while exporting report(.rdl)
body: <p><strong>SSRS 2008 R2:</strong> I have created a report(.rdl) using Shared datasource. I am following the tabular approach to generate the report. While exporting the report to excel I need to apply the filters to all the columns, so that the generated excel will have the filtration in its columns. But I am unable to find any option with respect to it.</p>
  
  <p><strong>Current Generated excel</strong></p>
  
  <p><a href="https://i.stack.imgur.com/tHUqP.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/tHUqP.jpg" alt="Current Result"></a></p>
  
  <p><strong>Expected Generated excel</strong></p>
  
  <p><a href="https://i.stack.imgur.com/1oClJ.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/1oClJ.jpg" alt="Expected Result with Filter"></a></p>
  
  <p>Please let me know in case of any other information is required.</p>