I wrote this, and it works fine in SSMS. But i would prefer it in SSRS so the user can just run it and then open in Excel. I am wondering if i can port this to SSRS. I tried, it didn't work for me. Thoughts?
If the end result is going to be used in an Excel spreadsheet anyway, would it make sense to not pivot the data in SQL, not use SSRS, and just have a query and pivot table in Excel that they can refresh the data on?