I'm using Microsoft Access 2003 and running a report off of it in Crystal. The report is pulling data from a query, which in turn is getting it's data from both internal and linked tables. There are four "tables" in the query, the first is a query that is based on internal tables. The following three are linked tables. So it looks like this:
QryIntTbls--LeftJoin--> LinkTbl#1--LeftJoin--> LinkTbl#2--LeftJoin--> LinkTbl#3
The query works great; the correct data is available in the correct field.
The problem is that the Crystal Report isn't pulling the data from all the fields. It can see all of the query fields, and correctly pulls data from fields from the QryIntTbl and the LinkTbl#1, but it shows no data from LinkTbl#2 or #3.
I'm not sure if this is a problem with Crystal or with the Query, which, by the way, is pretty slow. I'm not sure if the speed of the query is relevant or not. Also, I'm not sure it's important to note that the query requires a password as the linked tables are in a protected SQL DB.
Any suggestions or clues would be greatly appreciated!
Thank you.
QryIntTbls--LeftJoin--> LinkTbl#1--LeftJoin--> LinkTbl#2--LeftJoin--> LinkTbl#3
The query works great; the correct data is available in the correct field.
The problem is that the Crystal Report isn't pulling the data from all the fields. It can see all of the query fields, and correctly pulls data from fields from the QryIntTbl and the LinkTbl#1, but it shows no data from LinkTbl#2 or #3.
I'm not sure if this is a problem with Crystal or with the Query, which, by the way, is pretty slow. I'm not sure if the speed of the query is relevant or not. Also, I'm not sure it's important to note that the query requires a password as the linked tables are in a protected SQL DB.
Any suggestions or clues would be greatly appreciated!
Thank you.