SSRS report - Toggle column

Zolotoy 221 Reputation points
2023-02-04T12:36:37.15+00:00

I know I can toggle column's visibility based on another item. That means the other item would have a plus sign for a user to click on. What I want is to use the same toggle mechanism to collapse a column but without user interaction. Another words, to have columns collapsed automatically. Is it possible to base toggle on an expression?

Thanks

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,801 questions
0 comments

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. AniyaTang-MSFT 12,316 Reputation points Microsoft Vendor
    2023-03-06T08:04:29.64+00:00

    Hi @Zolotoy

    I'm sorry this may not be easy to implement. Excel has some limitations on exported reports. If the report item that controls whether another report item is switched is not located in the previous or next row/column of the report item that you are switching, the outline feature is also disabled.

    For more details, you can refer to this link: https://learn.microsoft.com/en-us/sql/reporting-services/report-builder/exporting-to-microsoft-excel-report-builder-and-ssrs?view=sql-server-ver16.

    If this answer was helpful, please mark it as "accept answer".

    Best regards,

    Aniya

    0 comments