I wonder if any one can explain how to deploy a report server project to google sites? If a understand it right I need a report server for publishing the reports.
You cannot deploy a SQL Server Reporting Services project to Google Sites as running the reports requires... SQL Server Reporting Services, which is a part of the SQL Server ecosystem and not availabel on Google Sites.
You could perhaps run the report in SSRS and then export the output as HTML to the Google Sites project so you have a snapshot but you will not be able to run it in realtime. You may also be able to run it on a schedule to export the HTML version and have a process that auto uploads it via FTP.