Reporting Services Error -- Could not find stored procedure 'spPM_ProjectManager'

Hi All,

I built this report same way like the other reports but in different database. When preview in visual stuodio, it is fine. When deploy to the server, I got this message:

Report Services Error

An error has occurred during report processing. (rsProcessingAborted) Get Online Help Query execution failed for data set 'ProjectManager'. (rsErrorExecutingCommand) Get Online Help Could not find stored procedure 'spPM_ReportManager'.

Do you know what cause the error?

Thanks in advance for your help!

Rabbie

Basically the error message is telling you it cant find the stored procedure. I would verify that the shared datasource this report is using in the designer is deployed to the reporting server. If it does exist, I would redeploy it anyway just in case.|||

Somehow the shared datasource's xml file missing initial catalog key/value pair in <ConnectString> tag. Even redeploy the shared datasource, xml file still did not change. I had to go to the server to change the value.

Thanks for your tip, Jonathan!

|||is the s.p. in the new db?