If you get the following Error whilst executing an Report:
Reporting Error
Reports cannot be run because the Connector for Microsoft SQL Server
Reporting Services, a required component for reporting, is not
installed on the server that is running Microsoft SQL Server Reporting
Services.
You may want to look at this post from Bhavesh Shastri.