The error is caused by the custom SQL view not existing in your new database. The custom view will need to be copied from a database where the report works. To do this, follow the relevant steps below.
Hosted
If you are hosted, our support team will need to carry out the steps, raise a case confirming the name of the report and the database it is not working on.
On-premise
Take a backup of the affected database.
Log in to the server where SelectPay is installed.
Click the Windows button, and then search for SelectPay reports administrator.
Click SelectPay Reports Administrator, and then enter your SQL instance name.
Click Ok.
🤓Tip: The description column contains the name from the front end.
Find and select the report, and then click Configure.
Note down the view name.
If it is separate, you will need to log in to your SQL server.
Log in to the server where SelectPay is installed.
Click the Windows button, and then search for SSMS.
Click SSMS, enter any required credentials, then click Connect.
Using the + icon, expand databases.
Expand the database where the report works, and then expand views.
Find and right-click the view from step 7.
Hover over Script View As, Create To, and click New Query Editor Window.
The first line will read 'Use [Databasename]'.
Change the database name in the square brackets to the impacted database.
Click Execute.