Having Problems with accessing 2 fox pro databases at one time 1

[jerdel]

I am trying to create a report that pulls information from 2 linked tables. For some reason I can't get it to do that. It will only pull information from the table that contains the first field that I place on the report. When i try to use a field from the other table to filter the results using certain criteria, it brings up nothing. I have also tried using a subreport but it still does the same thing

The databases are fox pro 2.6 databases and i am running Crystal reports 8.5 with service pack 1 for it. If anyone could help, it would be greatly appreciated.

 

[synapsevampire]

Are you using a Left Outer Join?

If you're using a direct connection, switch to an ODBC connectivity and this should be an option.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com