Dynamics GP - Deploy Excel Reports to Sharepoint

Before starting, create your Data connection and Reports Libraries in sharepoint first.
Go to sharepoint,
click Libraries>New>Select Reports Type>Name>Save
click Libraries>New>Select Data Connection Type>Name>Save

Make sure you're using a machine and user account that has access to the sharepoint site, otherwise it won't be able to upload the reports.

Go to DynamicsGP>Tools>Setup>System>Reporting Tools Setup
Click Excel Reports
Location:Sharepoint
Sharepoint site: http://yoursharepointsite
Data Connections Library: Dataconnectionlibraryname
Reports Library: Reportslibraryname
User Level Reports Directory: C:\Documents and Settings\%\My Documents\My Data
Click Deploy

And wait for reports to upload.