Home » Developer & Programmer » Reports & Discoverer » need help about the form6 report
need help about the form6 report [message #88510] Wed, 23 October 2002 00:29 Go to next message
Sarita
Messages: 7
Registered: June 2002
Junior Member
I need to calculate the lowest price (wt_rate ) in the given period i am writing the query
which am using in forms6 report.

select a.icode,b.iname,b.unit,a.po_no,
a.po_date,a.rate,a.wt_rate,
c.dis_per,c.st_per,c.ex_per,c.frt_per,c.cdays,c.pf_per
from po_order a,
invmast b, ord_det c
where a.icode= b.icode and a.po_no= c.po_no and a.po_date= c.po_dt

I have given the formula to calculate the lowest price(wt_rate) of
the item.

function CF_1Formula return Number is
fromdt date;
todate date;
cf_1 number;
begin
select min(wt_rate ) into cf_1 from po_order
where po_date >=fromdt and po_date <=todate
and icode=:icode ;
end;

after writing the pl/sql whenever I run this report . A Error come

ERROR
colomn 'cf_1' references coloumn 'icode',which has incompatible frequency
Re: need help about the form6 report [message #88511 is a reply to message #88510] Wed, 23 October 2002 01:02 Go to previous message
Ravi
Messages: 251
Registered: June 1998
Senior Member
Hi Sarita,

The Formula cf_1 i think you created outside that Query Group. Create that formula inside that Query Group your prob. will solve....

all the best....

Regards,
Ravi
Previous Topic: Generate to a TXT file
Next Topic: Reg Page Layout
Goto Forum:
  


Current Time: Fri Mar 29 06:05:10 CDT 2024