HanShi (9/30/2014)
Did you setup a linked server for that? If so: the stored procedure will read the data from the other server using the authorization defined in the linked server connection.
So it should work. Did you test the report? Did you execute the stored procedure using the same credentials as in your report? Did you encounter any errors?
What have you tried and tested uptill now? What are the results of your effort sofar?