reporting services - Is it possible to add “Auto Filter” in SSRS reports exported Excel Output file? -

Currently I am working in the project, where we are migrating all Excel reports ( VBA auto filter for excel reports generated from SSRs Reports SSRS behind strong logic> code) Can also help

I am trying to explain how to do this. So far, I have the following VBA to add an auto-filter to all sheets on the following 1 line:

  sub filter omitted (like dim WS_Count) WS_Count = ActiveWorkbook.Worksheets (I) for WS_Count = ActiveWorkbook.Worksheets.Count I = 1 as integer dimension integer. Choose Range ("A1"). AutoFilter Next I ActiveWorkbook.Worksheets (1). End Select sub  

It is less than ideal, but I have added it in my personal workbook so that I can generate a new report. I hope this helps, and if I think something better, then I will post again