I've created a report using CRXI which uses 2 seperate SQL servers as the datasources (company and tblCustomer_Portal).
I've had to link the datasources in crystal by creating cmd tables in the middle (CALM and CDI).
When I run the report from crystal I don't have any problems but when I put it into BOXI enterprise I keep getting the message Unknown Database Connector Error.
This error message only appears when I link the tblCustomer_Portal table more than once.
Is it not possible to link tables in this way or have I just missed something?
Any help would be greatly appreciated.
I've had to link the datasources in crystal by creating cmd tables in the middle (CALM and CDI).
When I run the report from crystal I don't have any problems but when I put it into BOXI enterprise I keep getting the message Unknown Database Connector Error.
This error message only appears when I link the tblCustomer_Portal table more than once.
Is it not possible to link tables in this way or have I just missed something?
Any help would be greatly appreciated.