Home > IT Answers > Business Intelligence > Query Engine Error – If tables are already linked then join type cannot change
CherylinJax
5 pts.
 Query Engine Error – If tables are already linked then join type cannot change
Crystal Report, Query Engine error
I recevied this error when I added a table to an exisiting report. I didn't change any joins.

Software/Hardware used:
ASKED: February 9, 2012  4:15 PM
UPDATED: April 11, 2012  10:35 PM
RELATED QUESTIONS
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
Last Wiki Answer Submitted:  April 11, 2012  10:34 pm  by  ABakerUltraSoft   15 pts.
All Answer Wiki Contributors:  ABakerUltraSoft   15 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _