Got to love Microsoft minutes. Having to uninstall an application on the Work PC, and the Installer showed it would take an impressive 68 Microsoft minutes. Some 5 minutes later...

The name is the server isn't SERVERTEST. The server is NR90F56ZX and the Instance name is SERVERTEST. You'll need to pass the Server name as NR90F56ZX\SERVERTEST. Also ensure you have...

That's a project connection manager. Make the connection manager in your package; then you'll be able to make it dynamic.

At a guess it's because SSMS doesn't know what to do with a .prc file. SSMS is really only designed with sql and sqlplan files in mind. Google tells me...

Wait... That SP is only doing deletes and inserts..? What would you be expecting your unnamed column to be returning in your select statement, considering that your SP isn't returning...

If you want the parameters pane to be hidden too, include rc:parameters=Collapsed in your URL. Building on Anthony's URL:
http://myReportsServer/ReportServer/ReportOne?ValueToFilterBy=123456&rc:parameters=Collapsed

What are you trying to do here exactly??? You can't execute a stored procedure inside a SELECT statement. At a pure guess, maybe what you're after is a (Table Value)...