Query Engine Error - If tables are already linked then join type cannot change
I recevied this error when I added a table to an exisiting report. I didn't change any joins.
ASKED:
Feb 9, 2012 4:15 PM GMT
UPDATED:
April 11, 2012 10:35:12 PM GMT
RELATED QUESTIONS
- Question on JOIN Clause
- SQL - left joins and where clauses
- Join and manipulate data from two separate databases
- Crystal Report Database Queries
- SQL-Using count and inner join in a single query
- Using Right() inside SQL Join
- Assign default values to SQL VIEW columns
- Pulling data from tables on different servers
- AS400-DML
- SQL server!
Answer Wiki:
This is because Crystal Report reorganised the links between all tables after you have added the extra table. Is it possible you have linked the extra table with a left join?
Any way to solve the problem, you should re-order your links to make sure that all inner joins are listed at the top.
To re-order links go to menu: Database >> Database Expert >> Links tab >> Order links...
I hope this helps.
A Baker
Any way to solve the problem, you should re-order your links to make sure that all inner joins are listed at the top.
To re-order links go to menu: Database >> Database Expert >> Links tab >> Order links...
I hope this helps.
A Baker
15 pts.
To see other answers submitted to the Answer Wiki View Answer History.
