Crystal Reports: Using the old DB until X date then switching over to the new DB

[former_member548403]

Hello, gurus.

At my workplace, we are retiring a database that we have been using for the number of reports and will have to start using a new database for the reports. Some reports need to be modified to use the old database until the set date, then use the new database for the data.

So for example, I am working on a report which needs to use the data from the old database until 9/3/2018 and then starts using the data from the new database after. BUT for the first three days of September, the report still needs data from the old database, as the report is supposed to show monthly data.

I suppose I start by adding an additional command to the report, but after that how do I configure the report to use the old database until 9/4/2018 date and use the new database after?

Thanks!

[DellSC]

There is no way to easily do this in Crystal. If you didn't need data from the old database and you were using ODBC connections, I would tell you to just delete/rename the old connection and create a new connection with the same name that connects to the new database. This should then allow the reports to work without any changes. However, without moving the data from the first three days of Sep to the new database, you won't be able to get that data in a report with a single connection.

-Dell

[former_member548403]

Since the report uses the same dataset from both databases, I was able to use UNION ALL function to combine the queries and bring the data into the report. So one problem is now solved, it seems.

Your comment about a single connection gave me an idea to use UNION ALL. So thanks!