I am unable to pass parameter values to a stored procedure locate in a subreport. Works fine if I use the ServerName and DatabaseName that was used to design reports, but does not work if I change the db name at runtime.

I am looping through the tables in the main report and subreport to set the ConnectionInfo, which works, but I am prompted by the application to enter a parameter value.

Is there a known issues with stored procedures and subreports???

Pierre