Hello. I'm new to SSRS.
I have a data set and a tablix. Works fine.
I want another tablix that uses the same data set, but the SQL behind it needs to know which tablix it's feeding. This is because the query is almost the same, but slightly different. I was hoping to be able to pass a parameter to it, but I can't find a way to populate the data set parameter from the tablix.
I'm hoping to avoid copying the query and then modifying it. This would be a maintenance PITA.
And I can't simply filter off it, because the query really needs to know whether it's including certain data as it processes.