Query Engine Error:

[Wajid55]

I am trying link a View to a table in Crystal it works fine when I link the view and a table in SQL Server but when i am trying to do it in Crystal it give me an error:

Query Engine Error: 'if tables already linked then the join cannot be changed'

What could be the reason?

Thanx

 

[synapsevampire]

Post your software version, and the connectivity used for SQL Server.

-k

 

[Wajid55]

Sorry about that...Im using Crystal X and I am using ODBC (RDO).

 

[synapsevampire]

Odd...

Well you can always create another View which does the linking for you, or you can use the Add Command listed under your datasource to paste in the SQL directly.

Can't see why it wouldn't work within the GUI though.

-k