aw, geeze - i was supposed to deploy the SubReports, too!

i have a long way to go...

after i deployed the SR's the entire report ran. sorry to waste your time...

i'm having the same exact problem! runs fine in BIDS (3 subreports) but after deploy all 3 subreports come up as errors.

right after i learned how to use subreports.

i read...

ok - i'm sort of understanding this, but would the fact that I have RS loaded & running on my PC constitute a 2nd hop or just a single...

Jacob, yes, i'm running RS on my PC and grabbing reports created here, but using data (in this case a SP running on a SQL Cluster (but both on the...

Point well taken, Jacob. for now, i am the sole recipient of all reports run through RS, but i will close down what i need to before i allow others...

i did what you recommended... - I also went into the Props of the SP & added "reportexecution" to the list of execution users for the sp. still the same...

my feeling is that i'm missing one "simple" piece.

i opened SQL Serv. Mgmt Studio

drilled down to Security/Logins to ReportExecution.

right-clicked & opened properties.

re-input the password to double check that...

my knowlege of most of this is limited.

but would it help to let you know that the SQL server is running SQL2005 on a MS-Server2003 OS and the server is...

i have have had the same problem - i have the RS on my PC but i'm trying to access a report from a SQL instance on a different SQL...