Share via

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

Gim Yongjin 21 Reputation points
2022-10-11T05:49:58.807+00:00

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

249223-microsoftteams-image.png

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,949 questions
0 comments
Accepted answer
  1. Olaf Helper 45,291 Reputation points
    2022-10-11T05:55:11.88+00:00

    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.

    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.