Home » Developer & Programmer » Reports & Discoverer » help about the Report
help about the Report [message #88518] Sat, 26 October 2002 01:51 Go to next message
Sarita
Messages: 7
Registered: June 2002
Junior Member
my project name is vendor rating query in Data model
select
a.po_no,a.po_date,a.icode,b.iname, a.qty,D.QTY,
d.del_sch,e.doc_no,e.doc_dt,e.qty_rcpt, E.QTY, C.QTY
from
po_order a,
invmast b,
sch_ord d,
mrrstor e,
REJ_NOTE C,
rej_det f
where
a.po_no= e.po_no and a.po_date=e.po_date and a.icode=b.icode
and d.po_no=a.po_no and d.po_date=a.po_date and
f.mrr_no= e.doc_no and f.mrr_dt=e.doc_dt and
c.doc_no=f.doc_no and c.doc_dt=f.doc_dt

In a Formula Coloumn in query CF_1 am using the formula is :return :del_sch-:po_date;

Cf_2 am using the formula is return :doc_dt - :po_date;

the formula i Want to use in this type of format

Quality Rating (QR) = Qty.Accepted Q.A Deptt
_______________________ * 100
Qty Supplied

Delivery Rating (DR) = Q1 T
____ * ____________ * 100
Q T8P=1.5*T1*q

where (P) = (ACT_DEl_Qty) Q1
_________________
(Sch_Del_qty) Q

(Q) = 1-p

How to use this format of formula in my form 6 report
Re: help about the Report [message #88521 is a reply to message #88518] Sun, 27 October 2002 22:51 Go to previous message
Ravi
Messages: 251
Registered: June 1998
Senior Member
Hi,
its little bit confussion here because exactly i am not understanding what you want, like you want do to in the report all these calculation Or what ?

second thing :- why you mentioned CF_1 and CF_2 means what you are trying to tell....

Third thing :- You have written some fomula for Quality Rating like (QR),Qty.Accepted Q.A Deptt,Qty Supplied. i want to know these thing are there in the Query or not if it is there then what is the column names..

same thing for Delivery Rating also......

Can you post the Query in a more clear way... Or if i am wrong then pls. correct me.......

Regards,
Ravi
Previous Topic: need help about the report
Next Topic: division by zero
Goto Forum:
  


Current Time: Fri Mar 29 03:00:06 CDT 2024