Great question, Thanks for sharing.

Steve is referring to following...

Whole point of creating a dynamic query is to avoid this kind of scenario. So instead of creating a dynamic query with IF ELSE you should be implementing this flag...

A calendar table can help a great deal for such working and also some other calculations. Just type Calendar table on the search SSC and you will see tons of...

Seems like you have manual partition and your report is a comparison between this two years. Which means you have fair amount of data to play with.
How much...

First thing first, lets format your sp in a readable form so that if someone interested to help, he/she could easily read the code.

...

Its looks more like a formatting issue when exported to excel from SSRS. I believe the filter on that particular column contain only one row reset are on the other...

Well if its not the permission issue (which seems not the case) i would suggest the following method.
As the error suggest this might not be the exact issue. there...

Just want to share few comments might help the OP

If you are running in your ssis package in the Designer mode i.e. in SSDT then you need to...

Do you have any control on LinkedServer and is it a SQL SERVER ? If yes then you can use sp_whoisactive SQL Server Monitoring Stored Procedure by Adam...