Here is the situation:

1. I want to count all the open purchase orders
2. I want the count of all open Sales Orders

on one report by item

Item PO Count SO count
A 10 5

I can do them separetly, but when I select the tables it automatically links Sales Orders and Purchase Orders based on the order no and Position no.

Any idea how to resolve the conflict

Can you post the relevant excerpt from your code showing the sql calls; perhaps that would help in resolving your issue.

It basically generates the SQL byitself. Right ? Do you want to see the SQL generated ?

Are you using Easy SQL? Irrespective of the tool you are using to generate this report, it would help to see the actual sql code. Thanks.

I am using Crystal Reports. It does not show the SQL query.

IMHO you will have to create two subreports first, linked to the different tables. Then, in the main report, disable the showing of the subs, and just pull a summary from them.

Further help needed? Sorry, you'll have to contact a Crystal guru. I haven't worked with the combination Baan & Crystal for about 5 years now, so I lost the touch :(

Regards
Nico