Here, I met problem when report customization. Environment is baan v 5.0c.
I want to customize the Purchase report tdpur440101000 and display purchase order no., supplier name, and supplier address on the header of the paper. This is a normal and easy customization as everybody think, and I think so. I make a new report linked to the session and maintain layout and write script as below,
----------------------------------------------------------
select tdpur400.otbp
from tdpur400
where tdpur400._index1={:tdpur400.orno}
selectdo
select tccom100.*
from tccom100
where tccom100._index1={:tdpur400.otbp}
selectdo
select tccom130.*
from tccom130
where tccom130._index1={:tccom100.cadr}
selectdo
endselect
endselect
rprt_send()
endselect
----------------------------------------------------------

I complied the report and found no errors and warnings. But address of the supplier cannot be displayed correctly. Whatever the supplier is, the address is all the same. I don't know way.
Anybody can give me advice? Thank you.

Hello Gigaman,

if you do a new report, and this one to the "print purchase order....." you have do read all additional information in report script.
All additional fields shoud be "input fields".
Do the select in report area as before.???????: , detail.??: a.s.o.
No rprt_send() is needed.

Regards

Hi,

Please check for following


select tdpur400.otbp
from tdpur400
where tdpur400._index1={:tdpur400.orno}
selectdo
select tccom100.*
from tccom100
where tccom100._index1={:tdpur400.otbp}
selectdo
select tccom130.*
from tccom130
where tccom130._index1={:tccom100.cadr}
selectdo
selectempty
(What if control comes here ?)
endselect
selectempty
(What if control comes here ?)
endselect
selectempty
(What if control comes here ?)endselect
rprt_send()
endselect

How can u have a rprt_send() in a Report Script??????
And that too for the same report where u want the info.

Actually, technically one could prograp a rprt_send() in a report script without getting comilation errors, but hey, Gigaman, to start with: Isn't the supplier's address printed in STANDARD BAAN on the purchase orders as field otbp.addr???

What version do you have exactly and what is it exactly you want to change from the standard Baan version?