question

TomStone-8590 avatar image
0 Votes"
TomStone-8590 asked Joyzhao-MSFT commented

SSRS: create filters for downloaded Excel reports?

Is there any logic that I can create in an SSRS report, such that when the report is downloaded into Excel that are filters on one or more columns?
135152-excel-filters.png


sql-server-reporting-services
excel-filters.png (5.7 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @TomStone-8590 ,
Has your issue been resolved?
If you have any questions, please feel free to let me know.
If the answer is helpful, please click "Accept Answer" and upvote it.
Thanks for understanding.
Best Regards,
Joy

0 Votes 0 ·

1 Answer

Joyzhao-MSFT avatar image
1 Vote"
Joyzhao-MSFT answered Joyzhao-MSFT edited

Hi @TomStone-8590
When you export or download the report as an Excel file and want to achieve certain effects, it depends on the Excel rendering extension. You could view all the effects rendered in Excel in this document: Export a paginated report to Microsoft Excel (Report Builder).
Best Regards,
Joy


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.