JeroenBoon
Technical User
Hello,
CE10, CR10, Oracle database:
I have a report that collects information from two different locations that communicate via a lan2lan. At the remote location I get some general order information and locally I get the orderdetails. When I run a query on the table on the remote location I get the results within no time. Same case for the local database. But when I connect the tables, the report runs very slowly.
Is there a way to force the report to first collect all the orders I want to see from the remote database and pass that data set in one time to the local database?
Greetings, Jeroen.
CE10, CR10, Oracle database:
I have a report that collects information from two different locations that communicate via a lan2lan. At the remote location I get some general order information and locally I get the orderdetails. When I run a query on the table on the remote location I get the results within no time. Same case for the local database. But when I connect the tables, the report runs very slowly.
Is there a way to force the report to first collect all the orders I want to see from the remote database and pass that data set in one time to the local database?
Greetings, Jeroen.