on 09-18-2008 2:28 PM
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.
Hi
From CR 8 to CR XI the query engine has changed.
You can link one to one or one to many in Crystal reports
Find below :
When you link records from one table to another table, the records will typically fall under one of two relationship types:
One-to-one
One-to-many
One-to-one relationships
In a one-to-one relationship between records in two linked tables, for every record in the primary table there is only one matching record in the lookup table (based on the linked fields). For example, in the Xtreme.mdb database, the Employee table can be linked to the Employee Addresses table based on the Employee ID field in each table. The Employee table contains information about employees at the company, the positions they hold, their salaries, hiring information, and so on. The Employee Addresses table contains each employee's home address. There is only one record for each employee in each of these tables. Therefore, if the Employee table is linked to the Employee Addresses table, only one record will be found in the Employee Addresses table for each record in the Employee table. This is a one-to-one relationship.
One-to-many relationships
In a one-to-many relationship between records in two linked tables, for every record in the primary table, there may be more than one matching record in the lookup table, based on the linked fields. In the Xtreme.mdb database, the Customer table can be linked to the Orders table based on the Customer ID field in each table. The Customer table contains information about each customer that has placed an order with the company. The Orders table contains information about orders that customers have placed. Since customers can place more than one order, there may be more than one record in the Orders table for each customer record in the Customers table. This is a one-to-many relationship.
Thanks,
Sastry
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
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.
Regards
Asha.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.