views:

19

answers:

0

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