SQL Server Crystal Report Change Datasource Swap Dev to QA

ijxebb2r 于 2023-06-21 发布在其他

关注(0)|答案(1)|浏览(149)

Trying to add a new DB field to an existing crystal report file with unknown/no-access datasource.

Grabbed the .rpt file from QA server ,
Opened in Local VS2019
Checked 'Set Datasource Location'

Now , Changed the connection to Local DB to add the new field
Checked 'Set Datasource Location' again

Now I put the file back to QA server and run the job but getting error in log files
Failed to open the connection. Details: [Database Vendor Code: 53 ]

Now question is, is there a way to set the initial datasource after making the changes with thelocal datasource. Developer will have access to only dev DB's, and initial datasource was of QA DB I guess, its basically unknown.

sql-server

来源：https://stackoverflow.com/questions/76462538/crystal-report-change-datasource-swap-dev-to-qa