VendPurchOrderTrans and PurchLine Problem

[Eduardo]

Hi,

I'm created a query (visual query using the AOT) where I want to join the
VendPurchOrderTrans with PurchLines. I'm currently creating a query where the
first datasource is VendPurchOrderTrans. Its ranges are (1) PurchId and (2)
PurchOrderDate. Then within VendPurchOrderTrans I'm adding a new Datasource
(PurchLine). PurchLine relationships is VendPurchOrderTrans.purchId ==
PurchLine.Purchid.

The FetchMode in PurchLine is 1:n and the JoinMode is "InnerJoin"

When I run the query in SSRS, I get all the values from VendPurchOrderTrans,
but only the FIRST record in PurchLine where the PurchId is eaqual to
VendPurchOrderTrans.PurchId.

I don't know how to join these two tables as I'm passing the correct
parameters.

How else can I create a query where I can have more control of what happenes?

Any help will be greatly appreciated.

[Rudi Hansen]

Can i ask what you need to do in your code?
It would make it a little easier to answer your question.

Post by Eduardo
Hi,
I'm created a query (visual query using the AOT) where I want to join the
VendPurchOrderTrans with PurchLines. I'm currently creating a query where the
first datasource is VendPurchOrderTrans. Its ranges are (1) PurchId and (2)
PurchOrderDate. Then within VendPurchOrderTrans I'm adding a new Datasource
(PurchLine). PurchLine relationships is VendPurchOrderTrans.purchId ==
PurchLine.Purchid.
The FetchMode in PurchLine is 1:n and the JoinMode is "InnerJoin"
When I run the query in SSRS, I get all the values from VendPurchOrderTrans,
but only the FIRST record in PurchLine where the PurchId is eaqual to
VendPurchOrderTrans.PurchId.
I don't know how to join these two tables as I'm passing the correct
parameters.
How else can I create a query where I can have more control of what happenes?
Any help will be greatly appreciated.