The key thing is that the estimator doesn't know the same facts about the data that you do. The estimator is just that, an estimator; if you can help it...

I have to ask, but why why is your company's policy to not use SSISDB? It is far superior to file system and MSDB deployment methods.

I know a lot of us have unsubscribed from things, due to the spam, but has anyone had all of them completely stop? I've not had a notification since 03:16...

I agree, I don't know why this wouldn't work using a Matrix; unfortunately we have no data to base off here though. The only thing I can think of is...

Simply put, don't; SSRS doesn't support dynamic dataset. It does support dynamic SQL, but the dataset returned still has to be predefined.

Instead use a fixed dataset (you might...