Well, what´s missing is the order 10555 that also has the Article 20000
10555 20000 10 <-- Not BETWEEN(Ordernr,10560,10675)
and the Report should look like this:
Articlenr 20000
Ordernr 10555 Qty 10
Ordernr 10560 Qty 10
Ordernr 10575 Qty 10
So I come back to my original...
Okey. Sorry. English is not my native language so I think I fooled myself.
Oh yes I have read the help files and the manuals from A to Z.
However, my problem is the following:
Order nr 10555 for 10 pcs of article nr 20000 comes in and I print our a "Worksheet" for my workshop manager for him...
Thanks JRB-Bldr and Tesar.
I have tried the SELECT command with INLIST and BETWEEN.
The SELECT command gives a DBF-file - ThisRpt - that is sorted on Ordernr and not on Articlenr. Therefore MyReport will not give the result I want.
Also, the records in ThisRpt covers only the orders in the...
Hi All!
I am working in FP 2.0.
I am trying to make a report based on a databasefile with the fields
Ordernr, Articlenr, Qty, Price etc.
The file is indexed on Articlenr, Ordernr.
The report is Grouped on Articlenr.
Details are Ordernr, Qty, Price etc.
Now, the records could be as follows...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.