Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Migrating SQL2000 > 2008 Reports Parameter issues

Status
Not open for further replies.

MartinCroft

Programmer
Jun 12, 2003
151
GB
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,
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top