Hide dynamically a tablix in SSRS

Question

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?

Answer 1

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

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

Regards,
Joy

Answer 2

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.