Here is one way to quickly deploy a SSRS Report.
I have left out the small details, as you as a pro DBA, might already know what i am talking about.
This is if your data source has been deployed/ready and you want to do a quick deployment of the existing report or deploy a new report.
If the developer has given you the .rdl files or Just a folder and asked you to deploy the report by the name “TestReport.rdl” as and example, here is what you can do.
Open the SSMS, then click on Connect – > Reporting Services in OBJECT EXPLORER
connect to the server you have reporting services installed (normally it is on the same box as your SQL Server.. with exceptions in some organizations) via the connect to Dialog box..
In the Home Folder, under the Report Folder/Project name right click and then select Import file.
In the Import File To dialog box select the .rdl File and check overwrite item, if the report already exists or leave it as it is.(unchecked)
click on Ok and your report is deployed.
now check for valid Data Source in the Data Sources under the Report Folder. Right click for properties and specify the correct data source or if the data source is correct (if you are overwriting the Report) leave it as it is.