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.
Asha Lund 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.