SSRS report - hide matrix

mark goldin 691 Reputation points

I have a table and a matrix. When I export it into Excel I want to hide either. Hiding table is working fine, but hiding matrix leaves in Excel this:

So, data is hidden, but not the whole matrix. Any idea?


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,793 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Joyzhao-MSFT 15,566 Reputation points

    Hi @mark goldin ,
    Did you set the matrix's visibility to "Hide" in the Tablix properties?
    Are there rectangles or other settings in your matrix?
    In my report, after hiding the matrix and exporting to Excel format, everything works fine.
    Please let me know if I have missed any important information.
    Best Regards,

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    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.

    0 comments No comments