MartinCroft
Programmer
Hi
we are migrating one of our reporting servers to SQL2008 from SQL2000 and we have a new SQL server installed, of which we take a copy of the existing SQL2000 database each day. As part of the testing we have through Crystal Enterprise copied all our Crystal reporting folders to a test area. Updated the database setting to the new server and set the destination output ( as they are all exported as files) to a test area. I have migrated and ran several reports successfully doing this against the SQL2008 server.
How ever I have a report that has been copied over and updated that has 4 parameters, these are the same values as the live version. However when running the report it failed with a query engine error. Putting a trace on SQL shows that the value passed to the parameter are in the wrong order?
The parameters in the history tab show Van; NULL; NULL; W ( same as live, but the trace in sql shows NULL,NULL,D,Van
any suggestions, I have tried refreshing the report, opening in crystal and saving back,
we are migrating one of our reporting servers to SQL2008 from SQL2000 and we have a new SQL server installed, of which we take a copy of the existing SQL2000 database each day. As part of the testing we have through Crystal Enterprise copied all our Crystal reporting folders to a test area. Updated the database setting to the new server and set the destination output ( as they are all exported as files) to a test area. I have migrated and ran several reports successfully doing this against the SQL2008 server.
How ever I have a report that has been copied over and updated that has 4 parameters, these are the same values as the live version. However when running the report it failed with a query engine error. Putting a trace on SQL shows that the value passed to the parameter are in the wrong order?
The parameters in the history tab show Van; NULL; NULL; W ( same as live, but the trace in sql shows NULL,NULL,D,Van
any suggestions, I have tried refreshing the report, opening in crystal and saving back,