Hide dynamically a tablix in SSRS

Bola Razaki 1 Reputation point
2020-09-03T18:37:50.84+00:00

Hi,
I have a SSRS report with 2 tables. There are kind of the same except one has summary data and the other one has details.
I am trying to display one table at a time.

Basically, when we launch the report, we should only see the summary table.
If the user wants to see the details, I would like them to click on a textbox ( or a link...) that will hide the summary table and display the detail table instead.
Is that possible?

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

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Joyzhao-MSFT 15,576 Reputation points
    2020-09-04T02:25:14.88+00:00

    Hi,
    If you would like them to click on a textbox (or a link...), then that will hide the summary table and display the detail table instead, you could add drill-through operations in the report by creating two reports.
    The specific operations are as follows:

    1. Create report 1 and named Summary, create report 2 and named Details.
      22520-01.jpg
    2. Add a details text box in the Summary report. Right click and select Text Properties. Select "Go to report" in the Action option and assign it to the Details report.
      22498-02.jpg

    After previewing, you will get the effect you want. Hope this helps！

    Regards,
    Joy

    0 comments
  2. Joyzhao-MSFT 15,576 Reputation points
    2020-09-07T02:47:51.257+00:00

    Hi @Bola Razaki

    Has your issue been resolved? If you have any question, please feel free to let me know.

    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.

    0 comments

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.