Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Link relationships Crystal IX

have an application written in vb6, access and CR IX

In a report I tebelle with reports.

How do I establish relations ONE TO ONE and ONTE TO MANY ?

Sometimes the same report I generates error -2147189176 (not always)

I need some upgrade Crystal report IX ?

Before I used CR 8 and everything worked.

Former Member
Former Member replied


Mentioned below are the steps which I have followed at my end using Xtreme Sample database for one to many relation ship.

1)Click on any two tables(e.g. Customer table and Order table).

2)In Links tab |Click on particular link.

3)Right Click the particular link|Select "Link option".

4)Click on "Right Outer Join/left Outer Join" instead of inner Join.

5)Click On Ok.

6)The output is one customer has many order Id.

7)You can create group on Customer ID.

You can reverse the link also.For that; Right click on particular link and select "Reverse link".

For one to one relationship you can select "inner join".

Please let us know if it doesnt work.



0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question