I am not sure if this applies to your situation....

I ran into a problem returning data when a stored procedure used an alias for a field. The sproc would not return the data in SSRS, but I could see it is SSMS. I solved the problem by using a cte and subsequent select statement in the sproc to return the records to SSRS. It worked, so I am using this solution wherever I have an alias in play.