Share via

SSRS report - Export hidden columns to Excel

Zolotoy 226 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.
3,061 questions

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    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 47,436 Reputation points
    2023-01-30T06:28:09.52+00:00

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

  3. Anonymous
    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

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.