Multiprovider query

[Former Member]

Hi all,

I have a query based on multiprovider with IO 0DOC_NUM wich derive from ODS-ordes and IO 0REFER_DOC from ODS-delivery.

I need to rappresent quantity of order and quantity of delivery in the same query.

It's possible?

Any suggestion please?

Thanks

Gianmarco

[Former Member]

do u have record counters in both Info providers?

by what characteristic do you want to view the results?

[Former Member]

I need a layout like this:

0REFER_DOC 0REFER_ITM 0DELIV_NUMB 0ACT_DL_QTY 0QUANT_B

0REFER_DOC from ODS-Delivery

0REFER_ITM from ODS-Delivery

0DELIV_NUMB from ODS-Delivery

0ACT_DL_QTY from ODS-Delivery

0QUANT_B from ODS-Orders

I can't display data for 0QUANT_B because isn't in the same row of the other characteristics in multiprovider.

I don't have record counters in both Info providers.

Any suggestion please?

Thanks