Hi there!
I will put the sofware used first, just in case it helps a bit:
Microsoft Visual Studio 2005. ,Microsoft Crystal Reports(year 2005), Crystal reports view as pdf from an webapplication (c#).
I have a crystal report document, created by the Crystal Reports IDE which has 2 parameters and setting them in preview mode work. I closed the preview tab and saved the file.
Has configured setting for:
database host, user, pass, database => "fooo.address,foouser,foopas,foodatabase"
And calls a stored procedure "fooProcedure" with "fooParam1,fooParam2" as params.
I got one c# method that replaces the database connection on the report passed as parameter. It uses the known way, explained here.
If that methods replaces the info for the same i configured on the C.R. IDE (in practice, it just sets the same values again), and i set the parameters through "setParameterValue" method, it works and shows the report without any trouble. Same functionality happens if i dont configure the database and just set the parameter values.
Then, if i make it change the database connection to => "fooo.address,foouser,foopas,foodatabase2" , which is a backup+restore full copy of "foodatabase" (cloned database) and do the set parameters task, i got a "missing param values" exception and the report doesnt show on the app.
I have tested the connection to the new db(works ok with the testConnectivity method), the currentvalues for parameterfields (which have values and are marked as "hascurrentvalue=true")... Also coded the param set methods using "parameterFields" instead "setParameterValue", etc.
None of the code i wrote worked.
What could be done to fix that problem?
Thanks in advance