Linking tables in 2 ways, Like ELSE condition

[Guest_imported]

Hello,

i have a "small" problem within Crystal reports - i try to link 2 tables, the problem is i need something like an else statement - here the things i try to do:

link table 1 and table 2 via ID1

in the case there is no matching in the two tables, do to the reason, that the value in table 2 is "0", it should check ID2 within table 2, but stays with ID 1 in table 1

is there any possibility to do this

any help is welcome

thanks & regards

rainer

 

[MalcolmW]

What database? Are you using ODBC? Malcolm Wynden
I'm for sale at

http://wynden.net

malcolm@wynden.net

 

[nnaacc]

I'm just learning about this myself. I think this will get you pointed in the right direction:

Add a new table - add table2 again. It will ask you to give the new table a different name like table2_b

Then in the visual linking expert, link
table1.ID1 *= table2.ID1 and
table1.ID1 *= table2_b.ID2

make sure you do left joins.

And then you'll have to edit the selection formula...

 

[Guest_imported]

via ODBC on a sybase database

rainer

 

[Guest_imported]

Hi nnaacc,

i tried this, but unfortunately it doesn't work - i get several records doubled.

and an other problem there is, that the grouping is by a third table which is right of table 2

Rainer

 

[MalcolmW]

I'm not sure whether Sybase supports this in ODBC, but it is worth a try.
In Database|Show SQL Query, modify the FROM statement, so that instead of something like
FROM Table1
INNER JOIN Table2 ON Table1.ID = Table2.ID
INNER JOIN Table3 ON Table2.Blah = Table3.Blah
try
FROM Table1
INNER JOIN Table2 ON Table1.ID = CASE WHEN Table2.ID <> 0 THEN Table2.ID ELSE Table2.ID2 END
INNER JOIN Table3 ON Table2.Blah = Table3.Blah
I'm not sure whether you need inner joins or outer joins, as you don't indicate any reason to choose one over the other. Malcolm Wynden
I'm for sale at

http://wynden.net

malcolm@wynden.net

 

[Guest_imported]

HI Malcolm,

i'm not able to chose this point in the database-menu.

Rainer

 

[MalcolmW]

Are you going directly against Sybase/ODBC, or are you using a *.qry file created with the Crystal SQL Designer? Malcolm Wynden
I'm for sale at

http://wynden.net

malcolm@wynden.net