Hi.Guru

I'am new to Baan. In baan report, i need a field which is to be calculated from the database(like total amount= unit cost * no. of pieces).

Can anybody help me out in this problem.
I would really appreciate if one could provide me a link to learn Baan reports from the scratch.

Warm regards,
Jatin Sanghi

Your can add a new field like tdpur401.pric*cprao020.quan with a domain of tc pric which in Baan V would give you the Purchase Price Times the Quantity on a reschedule Message. Hope this helps.

for the example you have :
total amount= unit cost * no. of pieces
if unit cost and no. of pieces are available in the report (ex: as report input fields), then it is simple.
do as you would, to insert a new fild on the layout, put this in the first field
under report field properties:
unit cost * no. of pieces
assign domain of tcamnt or suitable one depending on your appln.

If these are not actual database fields, you may have to check if the variables have the required values filled in before putting the above expn.

May require additional coding in report script if the variables are not present or if you are looking at dynamic values at different points in the report.