How to migrate FRWS report (BS) from Test to Prod but the ledger is not the same?

Summary:

We need to migrate balance sheet & profit & loss from Test environment to Production environment but the ledger in test & production is not the same.
Steps that we did is

1) Archive the report in Test

2) Unarchive it in Prod

The upon opening the report we are getting error of

How to update the connection or to change the data connection to the new ledger ?

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):