reportdr
Technical User
- Apr 11, 2006
- 10
Hello
I am using Crystal 8.5. My data is a SQL database connected via ODBC and an Access 2003 database.
I have fields in both that can be connected. For all the SQL tables in the report they are connected as left outer join. For the Access table it won't allow me to connect via left outer join. It also seems to select via the index of the 3 fields I'm using (absractno, batchno, chartno). However, if I remove the index then it doesn't allow me to link because it's not indexed.
Is this possible to do? What am I doing wrong?
Any and all help greatly appreciated.
Shelley
I am using Crystal 8.5. My data is a SQL database connected via ODBC and an Access 2003 database.
I have fields in both that can be connected. For all the SQL tables in the report they are connected as left outer join. For the Access table it won't allow me to connect via left outer join. It also seems to select via the index of the 3 fields I'm using (absractno, batchno, chartno). However, if I remove the index then it doesn't allow me to link because it's not indexed.
Is this possible to do? What am I doing wrong?
Any and all help greatly appreciated.
Shelley