In a previous article I demonstrated how to create a SSRS report that runs against a SSAS Cube. This time I am going to show you how to create a report with a query that you already have created.
Sql Server Management Studio is very robust and can do many things, but like any other product cannot do everything. Luckily there are add-ins available that fill in some of the gaps. My favorite and one I use every single day is SSMSBoost, (I no longer use it due to the change in the community license and the useful functions being taken away.)