A lot of functionality of SSRS is ignored when exported to CSV.
How did you implement the switch between the two tablixes? The interactivity section in the mentioned article says show/hide is ignored.
Maybe you can try an implementation with subreports?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP