Using CR 8.5 with SQL.
tables:
Orderhdr -> OrderDetail -> OrderNotes
they are all linked as left outer.
Each OrderDetail record can have several OrderNotes
therefore OrderDetail can have none, 1, 2 or 3 records of notes in OrderNotes
I am constructing a very basic report to print the orders along the notes.
----
[Detail section]:
order#, order date, salesman, eta date, item, description, qty, Unit price, extprice, notes
----
It works fine with no records or 1 rec in orderNotes but the problem arises when there are several recs for the same detail.
In this case if notesOrder has 3 recs, the detail for the same item will be printed 3 times. and also summing the qty and extprice will be triple.
How can I have all 3 rec of notesOrder appear at once.
Please advice, thank you.
dré
tables:
Orderhdr -> OrderDetail -> OrderNotes
they are all linked as left outer.
Each OrderDetail record can have several OrderNotes
therefore OrderDetail can have none, 1, 2 or 3 records of notes in OrderNotes
I am constructing a very basic report to print the orders along the notes.
----
[Detail section]:
order#, order date, salesman, eta date, item, description, qty, Unit price, extprice, notes
----
It works fine with no records or 1 rec in orderNotes but the problem arises when there are several recs for the same detail.
In this case if notesOrder has 3 recs, the detail for the same item will be printed 3 times. and also summing the qty and extprice will be triple.
How can I have all 3 rec of notesOrder appear at once.
Please advice, thank you.
dré