SSRS report - Export hidden columns to Excel

Zolotoy 221 Reputation points
2023-01-27T14:55:58.4833333+00:00

Is it possible to export a report into Excel with some columns being hidden but not completely removed?

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,799 questions

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. AniyaTang-MSFT 12,316 Reputation points Microsoft Vendor
    2023-01-30T05:59:23.0233333+00:00

    Hi @Zolotoy

    By hiding do you mean the collapse action or complete hiding? According to my test, when you export the report to EXCEL, if you perform the collapse action, then excel can expand the hidden items, if you completely hide, then excel will not retain the hidden columns.

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

    Best regards,

    Aniya

  2. Olaf Helper 40,816 Reputation points
    2023-01-30T06:28:09.52+00:00

    Hidden where, in the report definition or in the Excel export?

  3. AniyaTang-MSFT 12,316 Reputation points Microsoft Vendor
    2023-01-31T02:52:51.29+00:00

    Hi @Zolotoy

    If you want to use fold operation, you can refer to this link: Add an expand or collapse action to a paginated report (Report Builder).

    I did a simple test, and the result exported to excel is shown in the figure below.

    1

    Best regards,

    Aniya