After adding a new View using the Database Expert, I started getting the following error when running the report:
Database Connector Error: 'If tables are already linked then the join type cannot change.'
Failed to retrieve data from the database.
Error in File 04600test {FE1B1F52-937A-4372-9E11-E8220A9478FA}.rpt:
Database Connector Error: 'If tables are already linked then the join type cannot change.'
The issue seems to have been that the View was doing an Inner Join to Table A, while I was doing a Left Outer Join to the same table in the report (Database Expert).
The error disappeared after I did an Inner Join to the table in question, inside the report (Database Expert).
No comments:
Post a Comment