problem with displaying all data from all tables 1

[mhs377]

Hi All

I'm going to display all data from all tables that are linked outer join (everytable to another one) in one report(in crystal reports)
but it shows this error:
"
can not determine the queries necessary to get data for this report
Details: this query cannot be performed. the link orde requires Many to One configuration, which is not supported. please rearrange the links.
failed to open a rowset.
"

Can anyone help me find out why this error occurs?

 

[kray4660]

What driver are you using (SQL, Oracle, MySQL, etc.)? How many tables are involved. I had an issue some years ago with a propertary (sp?) ODBC driver that would not let me link more than three tables at once (what a pain).

It could be that the ODBC does not allow a number of tables to be linked as outer joins.

I hope this helps.

 

[lbass]

It sounds like you have multiple tables pointing TO the same table. Try reversing the joins so that one table is pointing to multiple other tables. Use left outer joins.

-LB

 

[mhs377]

thank you lbas
you are right
the error does not occur after changing the direction of the links
but it does not show all records
it shows just some of them and I did not find any relationship between them

so what (and where) is the problem?

 

[lbass]

You haven't provided enough information to tell. Are the all the other tables joined to the first table or are you linking them sequentially? Are you sure each join is left outer? You also cannot have any selection criteria on any of the right-hand tables.

-LB

 

[mhs377]

these are my tables that all of them connected outer join

 

[lbass]

Please note these rules:

You can only have ONE starting table (you have three).

Only one table can point to another table or set of tables (I'm not quite sure what is happening with Table 11 with regard to this).

Two tables cannot point TO the same table (e.g., Table 11). You should add it a second time.

-LB

 

[mhs377]

I removed table11 and table12 and reversed the links between (table5 and table6) and (table1 and table2)
so I have ONE starting table and non of them point TO the same table
but it still does not show all records(although there are more records than the previous report)
Is there any problem left?

 

[lbass]

I'm not sure what the result of your changes is, but regardless, if there is a null in a middle table that the outer table won't return any records either. To show all records, you would have to have only tables with the same or fewer records to the right, and again there can be no selection criteria on those right hand tables.

I think it would be more helpful if we understood what kinds of records are in the tables. If the tables contained the same fields, a different approach would make more sense than what you are trying to do.

-LB

 

[mhs377]

I found the problem
I changed my tables and there is no problem right now
thank you very much