How can i create export excel with filter in ssrs rdl file?

Question

I want to automatically filter when exporting from rdl file to excel file, what should I do?

Answer 1

If you mean the Auto-Filter function in MS Excel itself; that's not possible.
An export SSRS report => MS Excel file exports the plain data & format information, but no further Excel functionality.

See Export a paginated report to Microsoft Excel (Report Builder) for all features and limitations.