We're considering using the VS 2010 Microsoft Report Viewer in Remote mode. My question has to do with is where data retrieval takes place. Let me give an example. Say we have a report with two parameters. These parameters are then passed as stored procedure parameters when data is retrieved. So, my question is, when is the stored procedure called? Is it called from the SSRS 2008 server and then the data and report sent to the report viewer client or, is the stored procedure called from the report viewer client? Secondly, let's say the report is being displayed in the report viewer client, and the user changes the parameter values and refreshes the report. Is the stored proc called from the client or is the stored proc somehow called from the server?

Hi Randy Minder, The ReportViewer control provides an integrated design environment so that you can build client report definitions (.rdlc) using data from any ADO.NET data object or set a remote model for Reports(.rdl) on the report server. If you set the reportviewer for a remote model, the stored procedure are processed on the report server. In the client, you just pass the parameter value for store procedure, even if you modify the parameter value, store procedure is executed on the report server as well. For more information about the data retrieval difference between local report or server report, please see: http://msdn.microsoft.com/en-us/library/ms345248.aspx Thanks, Challen Fu