Hello Crystal Reports Book community,

I urgently need some help with a report I am attempting to build. I have been able to complete 95% the report, which I would consider to be easy!

I have two data sources. An ingres db and an access db.  One table in ingres, called cases, contains the bulk of the information I require however there are two fields: facility_id and agency_id in the cases table which relate to the location_id fields of two access tables: agency and facility.

Using a join I want to pull the description fields for the ids from each of these tables and add them to my report.

I have been able to successfully join both of the fields independently in separate reports i.e. facility or agency, and return the description. However unfortunately when I create the second inter db join I get the following errors: "Failed to retrieve data from database" and "Invalid argument provided".

I have even tried duplicating the access db and creating the join and  creating another join between the two dbs and I seems every time I add a second inter db join I get the error.

I need to produce the report by COB next Monday so any assistance would be greatly appreciated.