Dear ,

I want to add the price in SAR(conversion Price)in the report. I have attached my layout.

Following is my script.

functions:
function read.main.table()
{
select tdpur041.*
from tdpur041
where tdpur041.orno between :orno.f and :orno.t
and tdpur041.item between :item.f and :item.t
and tdpur041.cwar between :cwar.f and :cwar.t
and tdpur041.odat between :odat.f and :odat.t
|and tdpur041.ssls < 15
|* --and tdpur041.pric = 0.0
|* --or tdpur041.oqua = 0.0
order by tdpur041.orno,tdpur041.item
selectdo
select tdpur996.*
from tdpur996
where tdpur996.docn.c between :docn.f and :docn.t
and tdpur996.orno.c = :tdpur041.orno
and tdpur996.pono.c = :tdpur041.pono
and tdpur996.item.c = :tdpur041.item
selectdo
select tdpur040.*
from tdpur040
where tdpur040.cotp between :cotp.f and :cotp.t
and tdpur040.orno = :tdpur041.orno
|and tdpur040.cwar = :tdpur041.cwar
selectdo


select tiitm001.*
from tiitm001
where tiitm001.item = :tdpur041.item
selectdo
endselect

select tccom020.*
from tccom020
where tccom020.suno = :tdpur041.suno
selectdo
endselect

rprt_send()
endselect
endselect
endselect
}Thanks,
Suhaib