erathosthenes
Programmer
Hi everybody,
as time goes by I found another big issue in my reports I can't work around, and I don't know what the problem is.
I only want to show on screen a single database view,
this view has a Cust.No., a delivery date, how much pieces per Cust.No, what kind of piece, and also a price per delivered piece.
This means the view could look like this:
Cust.No. | Date | Count | Type | Price
10001 X 1 1 2,50
10001 X 2 2 3,00
10001 Z 1 3 3,50
10002 X 5 1 2,50
10002 Y 3 3 2,85
10003 Z 1 6 4,00
10004 Z 4 4 3,50
... ... ... ... ...
So in words... the view shows me the 'customer'
that has 'X' pieces of kind 'Y' on date 'Z', that cost the corresponding price.
What works is: my report remembers all different counts of the amount, how much the customer gets. He also remembers of what type the amount is. But he can go to hell, because he doesn't remembers, what the price of each type is.
I have four pictures for your service, there you can see, that the logic of the reports is correct. It works like in the other reports I build and in this report also, but not with the price and this makes me jumping around for anger.
The two important formulas are these:
formula @ShowActPrice
WhilePrintingRecords;
{VRPT_LIEFERSCHEIN.PREIS}
formula @RemPreis
WhilePrintingRecords;
EvaluateAfter ({@ShowActPrice});
stringvar menunum := menunum + totext({VRPT_LIEFERSCHEIN.MENUNUMMER},0) + ","; // Menü Nummer
stringvar rempreise := rempreise + totext({@ShowActPrice},0) + ",";
" MenuNum: "+ menunum +"; Preise: "+ rempreise;
You can see that the 'MenuNum' is collected right like it should, and it is the same logic I use with the price
.
You can find the pics under:
Any help or advice would be thankfully accepted.
Regards,
Frank
as time goes by I found another big issue in my reports I can't work around, and I don't know what the problem is.
I only want to show on screen a single database view,
this view has a Cust.No., a delivery date, how much pieces per Cust.No, what kind of piece, and also a price per delivered piece.
This means the view could look like this:
Cust.No. | Date | Count | Type | Price
10001 X 1 1 2,50
10001 X 2 2 3,00
10001 Z 1 3 3,50
10002 X 5 1 2,50
10002 Y 3 3 2,85
10003 Z 1 6 4,00
10004 Z 4 4 3,50
... ... ... ... ...
So in words... the view shows me the 'customer'
that has 'X' pieces of kind 'Y' on date 'Z', that cost the corresponding price.
What works is: my report remembers all different counts of the amount, how much the customer gets. He also remembers of what type the amount is. But he can go to hell, because he doesn't remembers, what the price of each type is.
I have four pictures for your service, there you can see, that the logic of the reports is correct. It works like in the other reports I build and in this report also, but not with the price and this makes me jumping around for anger.
The two important formulas are these:
formula @ShowActPrice
WhilePrintingRecords;
{VRPT_LIEFERSCHEIN.PREIS}
formula @RemPreis
WhilePrintingRecords;
EvaluateAfter ({@ShowActPrice});
stringvar menunum := menunum + totext({VRPT_LIEFERSCHEIN.MENUNUMMER},0) + ","; // Menü Nummer
stringvar rempreise := rempreise + totext({@ShowActPrice},0) + ",";
" MenuNum: "+ menunum +"; Preise: "+ rempreise;
You can see that the 'MenuNum' is collected right like it should, and it is the same logic I use with the price
You can find the pics under:
Any help or advice would be thankfully accepted.
Regards,
Frank