Linking issue - Multiple links cause Query Engine Error

[nells1]

Hi

My report is based on a few related tables in a dataset schema. The report shows the details of a "Job". However it also needs to link to two other tables "Customers" (to get the customer name) and "Status" (to get the status name).

So I have set up these links in the Visual Linking Expert. Individually these links bring back the desired result. But when the two links are in place I get the following:

"Query Engine Error: [Path to temp .rpt file]"

It seems I can only link to one table.

Does anyone know what might be causing this?

Many thanks
Nells

 

[paulmarr]

nells,

Make sure you are using an System DSN ODBC driver - you can have multiple links between tables - provided the links are valid for the relational database you are using.

Hope this helps

paulmarr

 

[nells1]

Hi again Paulmarr

The Report is based on a Dataset, though. The dataset has the valid relationships and everything is showing up correctly on the forms.

Have I got things completely wrong and need to do something different?

I wouldn't be suprised )

 

[nells1]

Problem solved!

Its a little bit of a mystery to me what was going on here.. but I created a new report where the datasource read directly off the database, played with the links I'd set up so it showed me the correct information, played with the links back in my original report.. and it works. I had to use Left Outer Joins rather than the Inner Joins it was previously using, so that may explain it.

Anyway all in all I think its down to user stupidity )

Thanks for your time!!