Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
"the join type cannot change"
CR Professinoal, 9.2.0.448 The message occurs after working in database expert, adding a left outer join.- bnix
- Post #7
- Forum: Business Objects: Crystal Reports 2 Data Access
-
"the join type cannot change"
CR9. I don't disagree that it exists; I just can't figure out how to turn it off. Back to the original problem - I have a series of tables linked, but when I add a reference table to the list and link it using a left outer join, I get 'Query engine error: "if tables are already linked...- bnix
- Post #5
- Forum: Business Objects: Crystal Reports 2 Data Access
-
"the join type cannot change"
Under the File tab, Report Options, there is no Smart Link item, or anything similar, to check or uncheck. Under File tab, Options, ditto. I have been in the Help tab, and have seen sample screens where there is a "smart link" button, but cannot find that button on any screen on my...- bnix
- Post #3
- Forum: Business Objects: Crystal Reports 2 Data Access
-
"the join type cannot change"
I am using several tables for my report. One table is used as a "common lookup table". I want to refine my report by using the "look-up table" descriptions. I developed the query initially, with links to all the interesting tables, except the lookup table. I go back into...- bnix
- Thread
- Replies: 11
- Forum: Business Objects: Crystal Reports 2 Data Access
