Hi, I am new to SSRS and I am using 2005 version.

http://www.sqlservercentral.com/articles/Development/2945/

I tried the solution to use dynamic connection string. I followed the instrunctions as stated and the report works fine when I hard code the server and database. But once I switch it (to use parameters for the server and database) and deploy, it does not run.

I am using a stored proc to retrieve the data for the report.

="Data Source=" & Parameters!Server.Value & ";Initial Catalog=" & Parameters!Database.Value

I get the following error...

An error has occurred during report processing. (rsProcessingAborted)

Error during processing of the ConnectString expression of datasource ‘RptData’. (rsDataSourceConnectStringProcessingError)

Can someone help me out?